ehsan2007
چهارشنبه 31 تیر 1388, 22:20 عصر
سلام به دوستان برنامه نويس دو روزه اين كدا وقتمو گرفته
من دو تا reference word رو اضافه كردم و كلاس زيرم استفاده كردم
using System;
using System.ComponentModel;
/// <summary>
/// Summary description for CCWordApp
/// </summary>
public class CCWordApp
{
private Word.ApplicationClass oWordApplic; // a reference to Word application
public Word.Document oDoc; // a reference to the document
public CCWordApp()
{
// activate the interface with the COM object of Microsoft Word
oWordApplic = new Word.ApplicationClass();
}
// Open a file (the file must exists) and activate it
public void Open(string strFileName)
{
object fileName = strFileName;
object readOnly = false;
object isVisible = true;
object missing = System.Reflection.Missing.Value;
oDoc = oWordApplic.Documents.Open(ref fileName, ref missing, ref readOnly,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref isVisible, ref missing, ref missing, ref missing);
oDoc.Activate();
}
// Open a new document
public void Open()
{
object missing = System.Reflection.Missing.Value;
oDoc = oWordApplic.Documents.Add(ref missing, ref missing, ref missing, ref missing);
oDoc.Activate();
}
public void Quit()
{
object missing = System.Reflection.Missing.Value;
oWordApplic.Application.Quit(ref missing, ref missing, ref missing);
}
public void Save()
{
oDoc.Save();
}
public void SaveAs(string strFileName)
{
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;
oDoc.SaveAs(ref fileName, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
}
// Save the document in HTML format
public void SaveAsHtml(string strFileName)
{
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;
object Format = (int)Word.WdSaveFormat.wdFormatHTML;
oDoc.SaveAs(ref fileName, ref Format, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
}
public void AddPicture(string strFileName)
{
object myFalse = false;
object myTrue = true;
object myEndOfDoc = "Image";
object myImageRange = oDoc.Bookmarks.Item(ref myEndOfDoc).Range;
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;
Word.InlineShape ObjPic = oDoc.InlineShapes.AddPicture(strFileName, ref myFalse, ref myTrue, ref myImageRange);
oDoc.Activate();
}
public void InsertText(string strText)
{
oWordApplic.Selection.TypeText(strText);
}
public void InsertLineBreak()
{
oWordApplic.Selection.TypeParagraph();
}
public void InsertLineBreak(int nline)
{
for (int i = 0; i < nline; i++)
oWordApplic.Selection.TypeParagraph();
}
// Change the paragraph alignement
public void SetAlignment(string strType)
{
switch (strType)
{
case "Center":
oWordApplic.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
break;
case "Left":
oWordApplic.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
break;
case "Right":
oWordApplic.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphRight;
break;
case "Justify":
oWordApplic.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphJustify;
break;
}
}
// if you use thif function to change the font you should call it again with
// no parameter in order to set the font without a particular format
public void SetFont(string strType)
{
switch (strType)
{
case "Bold":
oWordApplic.Selection.Font.Bold = 1;
break;
case "Italic":
oWordApplic.Selection.Font.Italic = 1;
break;
case "Underlined":
oWordApplic.Selection.Font.Subscript = 0;
break;
}
}
// disable all the style
public void SetFont()
{
oWordApplic.Selection.Font.Bold = 0;
oWordApplic.Selection.Font.Italic = 0;
oWordApplic.Selection.Font.Subscript = 0;
}
public void SetFontName(string strType)
{
oWordApplic.Selection.Font.Name = strType;
}
public void SetFontSize(int nSize)
{
oWordApplic.Selection.Font.Size = nSize;
}
public void InsertPagebreak()
{
// VB : Selection.InsertBreak Type:=wdPageBreak
object pBreak = (int)Word.WdBreakType.wdPageBreak;
oWordApplic.Selection.InsertBreak(ref pBreak);
}
// Go to a predefined bookmark, if the bookmark doesn't exists the application will raise an error
public void GotoBookMark(string strBookMarkName)
{
// VB : Selection.GoTo What:=wdGoToBookmark, Name:="nome"
object missing = System.Reflection.Missing.Value;
object Bookmark = (int)Word.WdGoToItem.wdGoToBookmark;
object NameBookMark = strBookMarkName;
oWordApplic.Selection.GoTo(ref Bookmark, ref missing, ref missing, ref NameBookMark);
}
public void GoToTheEnd()
{
// VB : Selection.EndKey Unit:=wdStory
object missing = System.Reflection.Missing.Value;
object unit;
unit = Word.WdUnits.wdStory;
oWordApplic.Selection.EndKey(ref unit, ref missing);
}
public void GoToTheBeginning()
{
// VB : Selection.HomeKey Unit:=wdStory
object missing = System.Reflection.Missing.Value;
object unit;
unit = Word.WdUnits.wdStory;
oWordApplic.Selection.HomeKey(ref unit, ref missing);
}
public void GoToTheTable(int ntable)
{
// Selection.GoTo What:=wdGoToTable, Which:=wdGoToFirst, Count:=1, Name:=""
// Selection.Find.ClearFormatting
// With Selection.Find
// .Text = ""
// .Replacement.Text = ""
// .Forward = True
// .Wrap = wdFindContinue
// .Format = False
// .MatchCase = False
// .MatchWholeWord = False
// .MatchWildcards = False
// .MatchSoundsLike = False
// .MatchAllWordForms = False
// End With
object missing = System.Reflection.Missing.Value;
object what;
what = Word.WdUnits.wdTable;
object which;
which = Word.WdGoToDirection.wdGoToFirst;
object count;
count = 1;
oWordApplic.Selection.GoTo(ref what, ref which, ref count, ref missing);
oWordApplic.Selection.Find.ClearFormatting();
oWordApplic.Selection.Text = "";
}
public void GoToRightCell()
{
// Selection.MoveRight Unit:=wdCell
object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdCell;
oWordApplic.Selection.MoveRight(ref direction, ref missing, ref missing);
}
public void GoToLeftCell()
{
// Selection.MoveRight Unit:=wdCell
object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdCell;
oWordApplic.Selection.MoveLeft(ref direction, ref missing, ref missing);
}
public void GoToDownCell()
{
// Selection.MoveRight Unit:=wdCell
object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdLine;
oWordApplic.Selection.MoveDown(ref direction, ref missing, ref missing);
}
public void GoToUpCell()
{
// Selection.MoveRight Unit:=wdCell
object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdLine;
oWordApplic.Selection.MoveUp(ref direction, ref missing, ref missing);
}
// this function doesn't work
public void InsertPageNumber(string strType, bool bHeader)
{
object missing = System.Reflection.Missing.Value;
object alignment;
object bFirstPage = false;
object bF = true;
//if (bHeader == true)
//WordApplic.Selection.HeaderFooter.PageNumbers.Show FirstPageNumber = bF;
switch (strType)
{
case "Center":
alignment = Word.WdPageNumberAlignment.wdAlignPageNumberCenter ;
//WordApplic.Selection.HeaderFooter.PageNumbers.Add( ref alignment,ref bFirstPage);
//Word.Selection objSelection = WordApplic.pSelection;
oWordApplic.Selection.HeaderFooter.PageNumbers.Ite m(1).Alignment = Word.WdPageNumberAlignment.wdAlignPageNumberCenter ;
break;
case "Right":
alignment = Word.WdPageNumberAlignment.wdAlignPageNumberRight;
oWordApplic.Selection.HeaderFooter.PageNumbers.Ite m(1).Alignment = Word.WdPageNumberAlignment.wdAlignPageNumberRight;
break;
case "Left":
alignment = Word.WdPageNumberAlignment.wdAlignPageNumberLeft;
oWordApplic.Selection.HeaderFooter.PageNumbers.Add (ref alignment, ref bFirstPage);
break;
}
}
}
//object units = WdUnits.wdCharacter;
//object last=doc.Characters.Count;
//doc.Range(ref first, ref last).Delete(ref units, ref last)اينم تكه كديه كه يك فايل word روي سرور رو ميخونه bookmark هارو جايگزين ميكنه و ميزاره توي فايل word
DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/AdminMadrese/Ra/doc"));
FileInfo[] files = di.GetFiles();
foreach (FileInfo file in files)
{
file.Delete();
}
test = new CCWordApp();
test.Open(Server.MapPath("~/AdministratorAll/Ra/ImageUserRa/Temp.doc"));
SqlConnection Cnn = new SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlDataReader DR = null;
SqlCommand Cmd = new SqlCommand("SELECT TblRaDaneshamoz.DanID, TblRaDaneshamoz.DanName, TblRaDaneshamoz.NameFamili, TblRaDaneshamoz.NamePedar, TblRaDaneshamoz.RozeTavalod, TblRaDaneshamoz.MaheTavalod, TblRaDaneshamoz.SaleTavalod, TblRaDaneshamoz.MahaleSodor, TblRaSaleTahsili.SalName, TblRaPyetahsili.PayName, TblRaMadrese.MadrName, TblRaMadrese.MadrID, TblClassName.ClaName, TblRaMantaghe.ManName FROM TblRaDaneshamoz INNER JOIN TblRaEntekhabDaneshamoz ON TblRaDaneshamoz.DanID = TblRaEntekhabDaneshamoz.DanID INNER JOIN TblRaSaleTahsili ON TblRaEntekhabDaneshamoz.SalID = TblRaSaleTahsili.SalID INNER JOIN TblRaPyetahsili ON TblRaEntekhabDaneshamoz.PayID = TblRaPyetahsili.PayID INNER JOIN TblRaMadrese ON TblRaEntekhabDaneshamoz.MadrID = TblRaMadrese.MadrID INNER JOIN TblClassName ON TblRaEntekhabDaneshamoz.ClaID = TblClassName.ClaID INNER JOIN TblRaMantaghe ON TblRaMadrese.MantID = TblRaMantaghe.MantID WHERE (TblRaEntekhabDaneshamoz.DanID = " + DropDownList4.SelectedValue.ToString() + ") AND (TblRaEntekhabDaneshamoz.SalID = " + DropDownList1.SelectedValue.ToString() + ") AND (TblRaEntekhabDaneshamoz.PayID = " + DropDownList2.SelectedValue.ToString() + ") AND (TblRaEntekhabDaneshamoz.ClaID = " + DropDownList3.SelectedValue.ToString() + ") AND (TblRaEntekhabDaneshamoz.MadrID = " + Session["UserModirRa"].ToString() + ")", Cnn);
try
{
Cmd.Connection.Open();
DR = Cmd.ExecuteReader();
if (DR.Read())
{
InsertBookMark("DanName", DR["DanName"].ToString());
InsertBookMark("NamePedar", DR["NamePedar"].ToString());
InsertBookMark("NameFamili", DR["NameFamili"].ToString());
InsertBookMark("MahaleSodor", DR["MahaleSodor"].ToString());
InsertBookMark("DanID", DR["DanID"].ToString());
InsertBookMark("Date", DR["RozeTavalod"].ToString() + "/" + DR["MaheTavalod"].ToString() + "/" + DR["SaleTavalod"].ToString());
InsertBookMark("SalName", DR["SalName"].ToString());
InsertBookMark("PayName", DR["PayName"].ToString());
InsertBookMark("MadrName", DR["MadrName"].ToString());
InsertBookMark("MadrID", DR["MadrID"].ToString());
InsertBookMark("ClaName", DR["ClaName"].ToString());
InsertBookMark("ManName", DR["ClaName"].ToString());
}
}
catch (SqlException)
{
Label1.Text = "خطا در كوئري"; return;
}
catch (Exception)
{
Label1.Text = "خطا در برنامه"; return;
}
finally
{
if (DR != null) DR.Close();
Cnn.Close();
}
test.AddPicture(Server.MapPath("~/AdministratorAll/Ra/ImageUserRa/B851200726.jpg"));
test.SaveAs(Server.MapPath("~/AdminMadrese/Ra/doc/AdminMadrese.doc"));
test.Quit();اين كد هم ميفرسته واسه خروجي
string name = Server.MapPath("~/AdminMadrese/Ra/doc/AdminMadrese.doc");
System.IO.FileStream fileStream = null;
byte[] bytes = null;
try
{
fileStream = new System.IO.FileStream(name, System.IO.FileMode.Open, System.IO.FileAccess.Read);
bytes = new byte[(int)fileStream.Length];
fileStream.Read(bytes, 0, (int)fileStream.Length);
}
finally
{
if (fileStream != null)
{
fileStream.Close();
}
}
ServerDocument sd1 = null;
try
{
sd1 = new ServerDocument(bytes, name);
sd1.Save();
Response.ContentType = "application/msword";
Response.AddHeader("Content-disposition", "filename=" + name);
Response.BinaryWrite(sd1.Document);
}
finally
{
if (sd1 != null)
{
sd1.Close();
}
}تمام اين درد سر هام سر اين كده test.AddPicture(Server.MapPath("~/AdministratorAll/Ra/ImageUserRa/B851200726.jpg"));
كه عكس هر كاربر رو ذخيره كنم داخل word اگه دوستان راهي دارن كه من فايل word رو روي سرور ذخيره نكنم و مستقيم بخونمش و بفرستم به خروجي ممنون ميشم
من دو تا reference word رو اضافه كردم و كلاس زيرم استفاده كردم
using System;
using System.ComponentModel;
/// <summary>
/// Summary description for CCWordApp
/// </summary>
public class CCWordApp
{
private Word.ApplicationClass oWordApplic; // a reference to Word application
public Word.Document oDoc; // a reference to the document
public CCWordApp()
{
// activate the interface with the COM object of Microsoft Word
oWordApplic = new Word.ApplicationClass();
}
// Open a file (the file must exists) and activate it
public void Open(string strFileName)
{
object fileName = strFileName;
object readOnly = false;
object isVisible = true;
object missing = System.Reflection.Missing.Value;
oDoc = oWordApplic.Documents.Open(ref fileName, ref missing, ref readOnly,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref isVisible, ref missing, ref missing, ref missing);
oDoc.Activate();
}
// Open a new document
public void Open()
{
object missing = System.Reflection.Missing.Value;
oDoc = oWordApplic.Documents.Add(ref missing, ref missing, ref missing, ref missing);
oDoc.Activate();
}
public void Quit()
{
object missing = System.Reflection.Missing.Value;
oWordApplic.Application.Quit(ref missing, ref missing, ref missing);
}
public void Save()
{
oDoc.Save();
}
public void SaveAs(string strFileName)
{
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;
oDoc.SaveAs(ref fileName, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
}
// Save the document in HTML format
public void SaveAsHtml(string strFileName)
{
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;
object Format = (int)Word.WdSaveFormat.wdFormatHTML;
oDoc.SaveAs(ref fileName, ref Format, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
}
public void AddPicture(string strFileName)
{
object myFalse = false;
object myTrue = true;
object myEndOfDoc = "Image";
object myImageRange = oDoc.Bookmarks.Item(ref myEndOfDoc).Range;
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;
Word.InlineShape ObjPic = oDoc.InlineShapes.AddPicture(strFileName, ref myFalse, ref myTrue, ref myImageRange);
oDoc.Activate();
}
public void InsertText(string strText)
{
oWordApplic.Selection.TypeText(strText);
}
public void InsertLineBreak()
{
oWordApplic.Selection.TypeParagraph();
}
public void InsertLineBreak(int nline)
{
for (int i = 0; i < nline; i++)
oWordApplic.Selection.TypeParagraph();
}
// Change the paragraph alignement
public void SetAlignment(string strType)
{
switch (strType)
{
case "Center":
oWordApplic.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
break;
case "Left":
oWordApplic.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
break;
case "Right":
oWordApplic.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphRight;
break;
case "Justify":
oWordApplic.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphJustify;
break;
}
}
// if you use thif function to change the font you should call it again with
// no parameter in order to set the font without a particular format
public void SetFont(string strType)
{
switch (strType)
{
case "Bold":
oWordApplic.Selection.Font.Bold = 1;
break;
case "Italic":
oWordApplic.Selection.Font.Italic = 1;
break;
case "Underlined":
oWordApplic.Selection.Font.Subscript = 0;
break;
}
}
// disable all the style
public void SetFont()
{
oWordApplic.Selection.Font.Bold = 0;
oWordApplic.Selection.Font.Italic = 0;
oWordApplic.Selection.Font.Subscript = 0;
}
public void SetFontName(string strType)
{
oWordApplic.Selection.Font.Name = strType;
}
public void SetFontSize(int nSize)
{
oWordApplic.Selection.Font.Size = nSize;
}
public void InsertPagebreak()
{
// VB : Selection.InsertBreak Type:=wdPageBreak
object pBreak = (int)Word.WdBreakType.wdPageBreak;
oWordApplic.Selection.InsertBreak(ref pBreak);
}
// Go to a predefined bookmark, if the bookmark doesn't exists the application will raise an error
public void GotoBookMark(string strBookMarkName)
{
// VB : Selection.GoTo What:=wdGoToBookmark, Name:="nome"
object missing = System.Reflection.Missing.Value;
object Bookmark = (int)Word.WdGoToItem.wdGoToBookmark;
object NameBookMark = strBookMarkName;
oWordApplic.Selection.GoTo(ref Bookmark, ref missing, ref missing, ref NameBookMark);
}
public void GoToTheEnd()
{
// VB : Selection.EndKey Unit:=wdStory
object missing = System.Reflection.Missing.Value;
object unit;
unit = Word.WdUnits.wdStory;
oWordApplic.Selection.EndKey(ref unit, ref missing);
}
public void GoToTheBeginning()
{
// VB : Selection.HomeKey Unit:=wdStory
object missing = System.Reflection.Missing.Value;
object unit;
unit = Word.WdUnits.wdStory;
oWordApplic.Selection.HomeKey(ref unit, ref missing);
}
public void GoToTheTable(int ntable)
{
// Selection.GoTo What:=wdGoToTable, Which:=wdGoToFirst, Count:=1, Name:=""
// Selection.Find.ClearFormatting
// With Selection.Find
// .Text = ""
// .Replacement.Text = ""
// .Forward = True
// .Wrap = wdFindContinue
// .Format = False
// .MatchCase = False
// .MatchWholeWord = False
// .MatchWildcards = False
// .MatchSoundsLike = False
// .MatchAllWordForms = False
// End With
object missing = System.Reflection.Missing.Value;
object what;
what = Word.WdUnits.wdTable;
object which;
which = Word.WdGoToDirection.wdGoToFirst;
object count;
count = 1;
oWordApplic.Selection.GoTo(ref what, ref which, ref count, ref missing);
oWordApplic.Selection.Find.ClearFormatting();
oWordApplic.Selection.Text = "";
}
public void GoToRightCell()
{
// Selection.MoveRight Unit:=wdCell
object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdCell;
oWordApplic.Selection.MoveRight(ref direction, ref missing, ref missing);
}
public void GoToLeftCell()
{
// Selection.MoveRight Unit:=wdCell
object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdCell;
oWordApplic.Selection.MoveLeft(ref direction, ref missing, ref missing);
}
public void GoToDownCell()
{
// Selection.MoveRight Unit:=wdCell
object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdLine;
oWordApplic.Selection.MoveDown(ref direction, ref missing, ref missing);
}
public void GoToUpCell()
{
// Selection.MoveRight Unit:=wdCell
object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdLine;
oWordApplic.Selection.MoveUp(ref direction, ref missing, ref missing);
}
// this function doesn't work
public void InsertPageNumber(string strType, bool bHeader)
{
object missing = System.Reflection.Missing.Value;
object alignment;
object bFirstPage = false;
object bF = true;
//if (bHeader == true)
//WordApplic.Selection.HeaderFooter.PageNumbers.Show FirstPageNumber = bF;
switch (strType)
{
case "Center":
alignment = Word.WdPageNumberAlignment.wdAlignPageNumberCenter ;
//WordApplic.Selection.HeaderFooter.PageNumbers.Add( ref alignment,ref bFirstPage);
//Word.Selection objSelection = WordApplic.pSelection;
oWordApplic.Selection.HeaderFooter.PageNumbers.Ite m(1).Alignment = Word.WdPageNumberAlignment.wdAlignPageNumberCenter ;
break;
case "Right":
alignment = Word.WdPageNumberAlignment.wdAlignPageNumberRight;
oWordApplic.Selection.HeaderFooter.PageNumbers.Ite m(1).Alignment = Word.WdPageNumberAlignment.wdAlignPageNumberRight;
break;
case "Left":
alignment = Word.WdPageNumberAlignment.wdAlignPageNumberLeft;
oWordApplic.Selection.HeaderFooter.PageNumbers.Add (ref alignment, ref bFirstPage);
break;
}
}
}
//object units = WdUnits.wdCharacter;
//object last=doc.Characters.Count;
//doc.Range(ref first, ref last).Delete(ref units, ref last)اينم تكه كديه كه يك فايل word روي سرور رو ميخونه bookmark هارو جايگزين ميكنه و ميزاره توي فايل word
DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/AdminMadrese/Ra/doc"));
FileInfo[] files = di.GetFiles();
foreach (FileInfo file in files)
{
file.Delete();
}
test = new CCWordApp();
test.Open(Server.MapPath("~/AdministratorAll/Ra/ImageUserRa/Temp.doc"));
SqlConnection Cnn = new SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlDataReader DR = null;
SqlCommand Cmd = new SqlCommand("SELECT TblRaDaneshamoz.DanID, TblRaDaneshamoz.DanName, TblRaDaneshamoz.NameFamili, TblRaDaneshamoz.NamePedar, TblRaDaneshamoz.RozeTavalod, TblRaDaneshamoz.MaheTavalod, TblRaDaneshamoz.SaleTavalod, TblRaDaneshamoz.MahaleSodor, TblRaSaleTahsili.SalName, TblRaPyetahsili.PayName, TblRaMadrese.MadrName, TblRaMadrese.MadrID, TblClassName.ClaName, TblRaMantaghe.ManName FROM TblRaDaneshamoz INNER JOIN TblRaEntekhabDaneshamoz ON TblRaDaneshamoz.DanID = TblRaEntekhabDaneshamoz.DanID INNER JOIN TblRaSaleTahsili ON TblRaEntekhabDaneshamoz.SalID = TblRaSaleTahsili.SalID INNER JOIN TblRaPyetahsili ON TblRaEntekhabDaneshamoz.PayID = TblRaPyetahsili.PayID INNER JOIN TblRaMadrese ON TblRaEntekhabDaneshamoz.MadrID = TblRaMadrese.MadrID INNER JOIN TblClassName ON TblRaEntekhabDaneshamoz.ClaID = TblClassName.ClaID INNER JOIN TblRaMantaghe ON TblRaMadrese.MantID = TblRaMantaghe.MantID WHERE (TblRaEntekhabDaneshamoz.DanID = " + DropDownList4.SelectedValue.ToString() + ") AND (TblRaEntekhabDaneshamoz.SalID = " + DropDownList1.SelectedValue.ToString() + ") AND (TblRaEntekhabDaneshamoz.PayID = " + DropDownList2.SelectedValue.ToString() + ") AND (TblRaEntekhabDaneshamoz.ClaID = " + DropDownList3.SelectedValue.ToString() + ") AND (TblRaEntekhabDaneshamoz.MadrID = " + Session["UserModirRa"].ToString() + ")", Cnn);
try
{
Cmd.Connection.Open();
DR = Cmd.ExecuteReader();
if (DR.Read())
{
InsertBookMark("DanName", DR["DanName"].ToString());
InsertBookMark("NamePedar", DR["NamePedar"].ToString());
InsertBookMark("NameFamili", DR["NameFamili"].ToString());
InsertBookMark("MahaleSodor", DR["MahaleSodor"].ToString());
InsertBookMark("DanID", DR["DanID"].ToString());
InsertBookMark("Date", DR["RozeTavalod"].ToString() + "/" + DR["MaheTavalod"].ToString() + "/" + DR["SaleTavalod"].ToString());
InsertBookMark("SalName", DR["SalName"].ToString());
InsertBookMark("PayName", DR["PayName"].ToString());
InsertBookMark("MadrName", DR["MadrName"].ToString());
InsertBookMark("MadrID", DR["MadrID"].ToString());
InsertBookMark("ClaName", DR["ClaName"].ToString());
InsertBookMark("ManName", DR["ClaName"].ToString());
}
}
catch (SqlException)
{
Label1.Text = "خطا در كوئري"; return;
}
catch (Exception)
{
Label1.Text = "خطا در برنامه"; return;
}
finally
{
if (DR != null) DR.Close();
Cnn.Close();
}
test.AddPicture(Server.MapPath("~/AdministratorAll/Ra/ImageUserRa/B851200726.jpg"));
test.SaveAs(Server.MapPath("~/AdminMadrese/Ra/doc/AdminMadrese.doc"));
test.Quit();اين كد هم ميفرسته واسه خروجي
string name = Server.MapPath("~/AdminMadrese/Ra/doc/AdminMadrese.doc");
System.IO.FileStream fileStream = null;
byte[] bytes = null;
try
{
fileStream = new System.IO.FileStream(name, System.IO.FileMode.Open, System.IO.FileAccess.Read);
bytes = new byte[(int)fileStream.Length];
fileStream.Read(bytes, 0, (int)fileStream.Length);
}
finally
{
if (fileStream != null)
{
fileStream.Close();
}
}
ServerDocument sd1 = null;
try
{
sd1 = new ServerDocument(bytes, name);
sd1.Save();
Response.ContentType = "application/msword";
Response.AddHeader("Content-disposition", "filename=" + name);
Response.BinaryWrite(sd1.Document);
}
finally
{
if (sd1 != null)
{
sd1.Close();
}
}تمام اين درد سر هام سر اين كده test.AddPicture(Server.MapPath("~/AdministratorAll/Ra/ImageUserRa/B851200726.jpg"));
كه عكس هر كاربر رو ذخيره كنم داخل word اگه دوستان راهي دارن كه من فايل word رو روي سرور ذخيره نكنم و مستقيم بخونمش و بفرستم به خروجي ممنون ميشم