protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginModel"] == null)
{
Response.Write("<script>alert('请重新登录');opener.top.location.href='../../Default.aspx';window.close();</script>");
return;
}
id = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["id"]));
if (!IsPostBack)
{
studentsRotaryModel = new StudentsRotaryModel();
studentsRotaryBLL = new StudentsRotaryBLL();
studentsRotaryModel = studentsRotaryBLL.GetModelById(id);
real_name.Text = studentsRotaryModel.real_name;
training_base_name.Text = studentsRotaryModel.training_base_name;
professional_base_name.Text = studentsRotaryModel.professional_base_name;
rotary_begin_time.Text = studentsRotaryModel.rotary_begin_time;
rotary_end_time.Text = studentsRotaryModel.rotary_end_time;
rotary_dept_name.Text = studentsRotaryModel.rotary_dept_name;
instructor.Text = studentsRotaryModel.instructor;
writor.Text = studentsRotaryModel.writor;
register_date.Text = studentsRotaryModel.register_date;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginModel"] == null)
{
Response.Write("<script>alert('请重新登录');opener.top.location.href='../../Default.aspx';window.close();</script>");
return;
}
id = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["id"]));
pi = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["pi"]));
studentsRotaryBLL = new StudentsRotaryBLL();
if (studentsRotaryBLL.GetQuestionnaire(id) == "已填写")
{
Response.Write("<script language='javascript'> alert('该问卷已填写，请勿重复');window.close();</script>");
return;
}
//Response.Write("<script> alert('"+id+"');</script>");
if (!IsPostBack)
{
studentsRotaryModel = new StudentsRotaryModel();
studentsRotaryBLL = new StudentsRotaryBLL();
studentsRotaryModel = studentsRotaryBLL.GetModelById(id);
training_base_name.Text = studentsRotaryModel.training_base_name;
training_base_code.Value = studentsRotaryModel.training_base_code;
professional_base_name.Text = studentsRotaryModel.professional_base_name;
professional_base_code.Value = studentsRotaryModel.professional_base_code;
rotary_dept_name.Text = studentsRotaryModel.rotary_dept_name;
rotary_dept_code.Value = studentsRotaryModel.rotary_dept_code;
instructor.Text = studentsRotaryModel.instructor;
writor.Value = studentsRotaryModel.writor;
register_date.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//loginModel = Session["loginModel"] as LoginModel;
//string name = loginModel.name.ToString();
//string tbCode = loginModel.training_base_code.ToString();
string tempPath = Server.MapPath("RotaryTemplete.docx");
string outputPath = Server.MapPath("God.doc");
Document doc = new Document(tempPath);
DocumentBuilder builder = new DocumentBuilder(doc);
StudentsRotaryBLL studentsRotaryBLL = new StudentsRotaryBLL();
dt = studentsRotaryBLL.GetDtByNT("wangj", "32017");
//String[] fieldNames = new String[] { "TrainingBaseName", "StudentsRealName", "ProfessionalBaseName", "DeptName", "RotaryBeginTime", "RotaryEndTime","TeachersRealName" };
//Object[] fieldValues = new Object[] { dt.Rows[0]["training_base_name"].ToString(), dt.Rows[0]["real_name"].ToString(), dt.Rows[0]["professional_base_name"].ToString(), dt.Rows[0]["rotary_dept_name"].ToString(), dt.Rows[0]["rotary_begin_time"].ToString(), dt.Rows[0]["rotary_end_time"].ToString(), dt.Rows[0]["instructor"] };
int count = 0;
//doc.MailMerge.Execute(fieldNames, fieldValues);
//Bookmark mark1 = doc.Range.Bookmarks["training_base_name"];
//Bookmark mark2 = doc.Range.Bookmarks["RealName"];
//Bookmark mark3 = doc.Range.Bookmarks["ProfessionalBaseName"];
//if (doc.Range.Bookmarks["training_base_name"] != null)
//{
// Bookmark mark = doc.Range.Bookmarks["training_base_name"];
// mark.Text = dt.Rows[0]["training_base_name"].ToString(); ;
//}
//mark1.Text = dt.Rows[0]["training_base_name"].ToString();
//mark2.Text = "王杰";
//mark3.Text = "医学院";
//记录要显示多少列
for (var i = 0; i < dt.Columns.Count; i++)
{
if (doc.Range.Bookmarks[dt.Columns[i].ColumnName.Trim()] != null)
{
Bookmark mark = doc.Range.Bookmarks[dt.Columns[i].ColumnName.Trim()];
mark.Text = "";
count++;
}
}
System.Collections.Generic.List <string> listcolumn = new System.Collections.Generic.List <string>(count);
for (var i = 0; i < count; i++)
{
builder.MoveToCell(0, 0, i, 0); //移动单元格
if (builder.CurrentNode.NodeType == NodeType.BookmarkStart)
{
listcolumn.Add((builder.CurrentNode as BookmarkStart).Name);
}
}
double width = builder.CellFormat.Width; //获取单元格宽度
builder.MoveToBookmark("table"); //开始添加值
for (var m = 0; m < dt.Rows.Count; m++)
{
for (var i = 0; i < listcolumn.Count; i++)
{
builder.InsertCell(); // 添加一个单元格
builder.CellFormat.Borders.LineStyle = LineStyle.Single;
builder.CellFormat.Borders.Color = System.Drawing.Color.Black;
builder.CellFormat.Width = width;
builder.CellFormat.VerticalMerge = Aspose.Words.Tables.CellMerge.None;
builder.CellFormat.VerticalAlignment = CellVerticalAlignment.Center; //垂直居中对齐
builder.ParagraphFormat.Alignment = ParagraphAlignment.Center; //水平居中对齐
builder.Write(dt.Rows[m][listcolumn[i]].ToString());
}
builder.EndRow();
}
doc.Range.Bookmarks["table"].Text = ""; // 清掉标示
doc.Save("王杰" + ".doc", SaveFormat.Doc, SaveType.OpenInWord, Page.Response);
//doc.Save(outputPath);
}
protected void save_Click(object sender, EventArgs e)
{
questionnaireModel = new QuestionnaireModel();
questionnaireBLL = new QuestionnaireBLL();
studentsRotaryBLL = new StudentsRotaryBLL();
questionnaireModel.id = Guid.NewGuid().ToString();
questionnaireModel.training_base_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(training_base_name.Text.Trim()));
questionnaireModel.training_base_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(training_base_code.Value.Trim()));
questionnaireModel.professional_base_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(professional_base_name.Text.Trim()));
questionnaireModel.professional_base_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(professional_base_code.Value.Trim()));
questionnaireModel.rotary_dept_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(rotary_dept_name.Text.Trim()));
questionnaireModel.rotary_dept_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(rotary_dept_code.Value.Trim()));
questionnaireModel.instructor = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(instructor.Text.Trim()));
questionnaireModel.one = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList1.SelectedValue));
questionnaireModel.two = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList2.SelectedValue));
questionnaireModel.three = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList3.SelectedValue));
questionnaireModel.four = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList4.SelectedValue));
questionnaireModel.five = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList5.SelectedValue));
questionnaireModel.six = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList6.SelectedValue));
questionnaireModel.seven = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList7.SelectedValue));
questionnaireModel.eight = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList8.SelectedValue));
questionnaireModel.nine = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList9.SelectedValue));
questionnaireModel.ten = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList10.SelectedValue));
questionnaireModel.eleven = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList11.SelectedValue));
questionnaireModel.twelve = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList12.SelectedValue));
questionnaireModel.thirteen = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList13.SelectedValue));
questionnaireModel.advice = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(advice.Text.Trim()));
questionnaireModel.register_date = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(register_date.Text.Trim()));
questionnaireModel.writor = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(writor.Value.Trim()));
if (RadioButtonList1.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第一项未选择", null);
return;
}
if (RadioButtonList2.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第二项未选择", null);
return;
}
if (RadioButtonList3.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第三项未选择", null);
return;
}
if (RadioButtonList4.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第四项未选择", null);
return;
}
if (RadioButtonList5.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第五项未选择", null);
return;
}
if (RadioButtonList6.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第六项未选择", null);
return;
}
if (RadioButtonList7.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第七项未选择", null);
return;
}
if (RadioButtonList8.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第八项未选择", null);
return;
}
if (RadioButtonList9.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第九项未选择", null);
return;
}
if (RadioButtonList10.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第十项未选择", null);
return;
}
if (RadioButtonList11.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第十一项未选择", null);
return;
}
if (RadioButtonList12.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第十二项未选择", null);
return;
}
if (RadioButtonList13.SelectedItem == null)
{
ShowMessageBox.Showmessagebox(this, "第十三项未选择", null);
return;
}
if (string.IsNullOrEmpty(questionnaireModel.advice))
{
ShowMessageBox.Showmessagebox(this, "第十四项不能为空", null);
return;
}
if (questionnaireBLL.InsertQuestionnaire(questionnaireModel) && studentsRotaryBLL.UpdateQuestStatus(questionnaireyi, id))
{
try
{
Response.Write("<script language='javascript'> alert('问卷调查提交成功');window.opener.window.loadPageList('" + pi + "');window.close();</script>");
return;
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginModel"] == null)
{
Response.Write("<script>alert('请重新登录');opener.top.location.href='../../Default.aspx';window.close();</script>");
return;
}
id = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["id"]));
pi = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(Request.QueryString["pi"]));
if (!IsPostBack)
{
loginModel = new LoginModel();
studentsPersonalInformationModel = new StudentsPersonalInformationModel();
studentsPersonalInformationBLL = new StudentsPersonalInformationBLL();
dt = new DataTable();
professionalBaseDeptBLL = new ProfessionalBaseDeptBLL();
loginModel = (LoginModel)Session["loginModel"];
writor.Text = loginModel.real_name;
real_name.Text = loginModel.real_name; real_name.ReadOnly = true;
if (string.IsNullOrEmpty(id))
{
register_date.Text = DateTime.Now.Date.ToString("yyyy-MM-dd");
}
na = loginModel.name;
name.Value = na;
tbcode = loginModel.training_base_code;
studentsPersonalInformationModel = studentsPersonalInformationBLL.GetModelByNameTBCode(na, tbcode);
if (studentsPersonalInformationModel == null)
{
Response.Write("<script> alert('请完善个人基本信息');window.close();</script>");
return;
}
else
{
training_base_code.Value = studentsPersonalInformationModel.training_base_code.ToString();
training_base_name.Text = studentsPersonalInformationModel.training_base_name.ToString(); training_base_name.ReadOnly = true;
professional_base_code.Value = studentsPersonalInformationModel.professional_base_code.ToString();
professional_base_name.Text = studentsPersonalInformationModel.professional_base_name.ToString(); professional_base_name.ReadOnly = true;
dt = professionalBaseDeptBLL.GetDeptDataTableByCode(studentsPersonalInformationModel.professional_base_code.ToString());
rotary_dept_name.DataSource = dt;
rotary_dept_name.DataTextField = "dept_name";
rotary_dept_name.DataValueField = "dept_code";
rotary_dept_name.DataBind();
rotary_dept_name.Items.Insert(0, new ListItem("==请选择==", "0"));
}
if (!string.IsNullOrEmpty(id))
{//如果不是表单提交，并且带了id值来做修改操作，则在界面上把值都呈现出来
studentsRotaryModel = new StudentsRotaryModel();
studentsRotaryBLL = new StudentsRotaryBLL();
studentsRotaryModel = studentsRotaryBLL.GetModelById(id);
//rotary_dept_name.SelectedItem.Text = studentsRotaryModel.rotary_dept_name.ToString();
rotary_dept_name.SelectedValue = studentsRotaryModel.rotary_dept_code.ToString();
dt = new LoginBLL().GetTeachersDtByDeptCode(studentsRotaryModel.training_base_code, studentsRotaryModel.professional_base_code, studentsRotaryModel.rotary_dept_code, "teachers");
Teacher.DataSource = dt;
Teacher.DataTextField = "real_name";
Teacher.DataValueField = "name";
Teacher.DataBind();
Teacher.Items.Insert(0, new ListItem("==请选择==", "0"));
Teacher.SelectedValue = studentsRotaryModel.instructor_tag;
//instructor.Text = studentsRotaryModel.instructor.ToString();
//instructor_tag.Value = studentsRotaryModel.instructor_tag.ToString();
//Teacher.SelectedItem.Text = studentsRotaryModel.instructor.ToString();
//Teacher.SelectedItem.Value = studentsRotaryModel.instructor_tag.ToString();
rotary_begin_time.Text = studentsRotaryModel.rotary_begin_time.ToString();
rotary_end_time.Text = studentsRotaryModel.rotary_end_time.ToString();
register_date.Text = studentsRotaryModel.register_date.ToString();
}
}
}
protected void save_Click(object sender, EventArgs e)
{
studentsRotaryModel = new StudentsRotaryModel();
studentsRotaryBLL = new StudentsRotaryBLL();
studentsRotaryModel.rotary_begin_time = CommonFunc.SafeGetDateTimeStringFromObjectByFormat(CommonFunc.FilterSpecialString(rotary_begin_time.Text.Trim()), "yyyy-MM-dd");
studentsRotaryModel.rotary_end_time = CommonFunc.SafeGetDateTimeStringFromObjectByFormat(CommonFunc.FilterSpecialString(rotary_end_time.Text.Trim()), "yyyy-MM-dd");
studentsRotaryModel.rotary_dept_code = CommonFunc.FilterSpecialString(rotary_dept_name.SelectedItem.Value);
studentsRotaryModel.rotary_dept_name = CommonFunc.FilterSpecialString(rotary_dept_name.SelectedItem.Text);
studentsRotaryModel.instructor = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Text);
studentsRotaryModel.instructor_tag = CommonFunc.FilterSpecialString(Teacher.SelectedItem.Value);
studentsRotaryModel.writor = CommonFunc.FilterSpecialString(writor.Text.Trim());
if (string.IsNullOrEmpty(id))
{
id = Guid.NewGuid().ToString();
studentsRotaryModel.id = id;
studentsRotaryModel.name = name.Value.ToString();
studentsRotaryModel.real_name = CommonFunc.FilterSpecialString(real_name.Text.Trim());
studentsRotaryModel.training_base_code = CommonFunc.FilterSpecialString(training_base_code.Value);
studentsRotaryModel.training_base_name = CommonFunc.FilterSpecialString(training_base_name.Text);
studentsRotaryModel.professional_base_code = CommonFunc.FilterSpecialString(professional_base_code.Value);
studentsRotaryModel.professional_base_name = CommonFunc.FilterSpecialString(professional_base_name.Text);
studentsRotaryModel.register_date = CommonFunc.FilterSpecialString(register_date.Text.Trim());
studentsRotaryModel.outdept_status = CommonFunc.FilterSpecialString(outdeptwei);
studentsRotaryModel.outdept_application = CommonFunc.FilterSpecialString(outdeptapplicationwei);
studentsRotaryModel.questionnaire_status = CommonFunc.FilterSpecialString(questionnairewei);
if (studentsRotaryModel.rotary_dept_code == "0" || studentsRotaryModel.rotary_dept_name == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null);
return;
}
if (studentsRotaryModel.instructor == "==请选择==" || studentsRotaryModel.instructor_tag == "0")
{
ShowMessageBox.Showmessagebox(this, "指导医师不能为空", null);
return;
}
if (string.IsNullOrEmpty(rotary_begin_time.Text.Trim()) || string.IsNullOrEmpty(rotary_end_time.Text.Trim()))
{
ShowMessageBox.Showmessagebox(this, "轮转时间不能为空", null);
return;
}
if (studentsRotaryBLL.InsertStudentsRotary(studentsRotaryModel))
{
try
{
Response.Write("<script language='javascript'> alert('科室轮转信息添加成功');window.opener.parent.frames.bodyFrame.frames.frmright.window.loadPageList(1);;window.close();</script>");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
else
{
if (studentsRotaryModel.rotary_dept_code == "0" || studentsRotaryModel.rotary_dept_name == "==请选择==")
{
ShowMessageBox.Showmessagebox(this, "轮转科室不能为空", null);
return;
}
if (studentsRotaryModel.instructor == "==请选择==" || studentsRotaryModel.instructor_tag == "0")
{
ShowMessageBox.Showmessagebox(this, "指导医师不能为空", null);
return;
}
if (string.IsNullOrEmpty(rotary_begin_time.Text.Trim()) || string.IsNullOrEmpty(rotary_end_time.Text.Trim()))
{
ShowMessageBox.Showmessagebox(this, "轮转时间不能为空", null);
return;
}
if (studentsRotaryBLL.UpdateRotary(studentsRotaryModel, id))
{
try
{
Response.Write("<script language='javascript'> alert('科室轮转信息修改成功');window.opener.window.loadPageList('" + pi + "');window.close();;</script>");
Response.End();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
else
{
Response.Write("<script language='javascript'> alert('科室轮转信息修改失败');window.close();</script>");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
StudentsRotaryBLL studentsRotaryBLL = new StudentsRotaryBLL();
dt = new DataTable();
try
{
string templatePath = HttpContext.Current.Server.MapPath(@"../RotaryTemplete/RotaryTemplete.docx");
//生成的文档路径
filePath = HttpContext.Current.Server.MapPath(@"../RotaryWord/");
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
if (!File.Exists(templatePath))
{
Response.Write("<script>alert('error：服务器没有模版');</script>"); return;
}
;
DataTable dt_Stu = studentsRotaryBLL.GetDtByNT(name, tbCode);
filePath = filePath + "个人轮转表-" + dt_Stu.Rows[0]["real_name"] + ".doc";
//copy一份
File.Copy(templatePath, filePath, true);
object oMissing = System.Reflection.Missing.Value;
app = new Word.Application();
app.Visible = false;
object fileName = filePath;
doc = app.Documents.Open(ref fileName,
ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing);
if (doc == null)
{
Response.Write("<script>alert('error：服务器没有打开Word');</script>");
return;
}
////判断书签 //加入doc书签的方法
//if (doc.Bookmarks.Exists("KJJBJNF"))
//{
// doc.Bookmarks["KJJBJNF"].Range.Text = DateTime.Now.ToString("yyyyMMddHHmmss").ToString() + "标题";
//}
Word.Tables tabs1 = doc.Tables;
if (tabs1 != null && tabs1.Count > 0)
{
Word.Table dt_Word = tabs1[1];
doc.Bookmarks["TrainingBaseName"].Range.Text = dt_Stu.Rows[0]["training_base_name"].ToString();
//默认从第2行开始，第1行为模板中的标头
int rowIdex = 2;
foreach (DataRow row in dt_Stu.Rows)
{
object miss = System.Reflection.Missing.Value;
dt_Word.Rows.Add(miss);
//将从数据库中查询的数据，此处进行循环加载即可
//1. 设置该单元格中字体的对齐方式
dt_Word.Cell(rowIdex, 1).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
//2.向单元格中添加数据
dt_Word.Cell(rowIdex, 1).Range.Text = row["real_name"].ToString();
dt_Word.Cell(rowIdex, 2).Range.Text = row["professional_base_name"].ToString();
dt_Word.Cell(rowIdex, 3).Range.Text = row["rotary_dept_name"].ToString();
dt_Word.Cell(rowIdex, 4).Range.Text = row["rotary_begin_time"].ToString();
dt_Word.Cell(rowIdex, 5).Range.Text = row["rotary_end_time"].ToString();
dt_Word.Cell(rowIdex, 6).Range.Text = row["instructor"].ToString();
// 3 .合并单元格Merge（行，列）
//dt_Word.Cell(rowIdex, 3).Merge(dt_Word.Cell(rowIdex, 4));
rowIdex++;
}
}
doc.Save();
QuitWord();
}
catch (Exception ex)
{
QuitWord();
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
//Word._Application appWord = new Word.ApplicationClass();
//Word._Document docFile = null;
//try
//{
// appWord.Visible = false;
// object objTrue = true;
// object objFalse = false;
// object objTemplate = Server.MapPath(@"../RotaryTemplete/RotaryTemplete.docx");//模板路径
// object objDocType = Word.WdDocumentType.wdTypeDocument;
// docFile = appWord.Documents.Add(ref objTemplate, ref objFalse, ref objDocType, ref objTrue);
// //第一步生成word文档
// //定义书签变量
// object TrainingBaseName = "TrainingBaseName";
// object StudentsRealName = "StudentsRealName";
// object ProfessionalBaseName = "ProfessionalBaseName";
// object DeptName = "DeptName";
// object RotaryBeginTime = "RotaryBeginTime";
// object RotaryEndTime = "RotaryEndTime";
// object TeachersRealName = "TeachersRealName";
// //第二步 读取数据，填充数据集
// //SqlDataReader dr = XXXXX;//读取出来的数据集
// //第三步 给书签赋值
// //给书签赋值
// dt = studentsRotaryBLL.GetDtByNT(name, tbCode);
// if (dt == null)
// {
// Response.Write("<script>alert('暂无轮转信息');</script>");
// return;
// }
// else
// {
// foreach (DataRow row in dt.Rows)
// {
// docFile.Bookmarks.get_Item(ref TrainingBaseName).Range.Text = row["training_base_name"].ToString();
// docFile.Bookmarks.get_Item(ref StudentsRealName).Range.Text = row["real_name"].ToString();
// docFile.Bookmarks.get_Item(ref ProfessionalBaseName).Range.Text = row["professional_base_name"].ToString();
// docFile.Bookmarks.get_Item(ref DeptName).Range.Text = row["rotary_dept_name"].ToString();
// docFile.Bookmarks.get_Item(ref RotaryBeginTime).Range.Text = row["rotary_begin_time"].ToString();
// docFile.Bookmarks.get_Item(ref RotaryEndTime).Range.Text = row["rotary_end_time"].ToString();
// docFile.Bookmarks.get_Item(ref TeachersRealName).Range.Text = row["instructor"].ToString();
// }
// }
// //第四步 生成word
// object filename = Server.MapPath("../RotaryWord/") + "个人轮转表-"+dt.Rows[0]["real_name"]+".doc";
// object miss = System.Reflection.Missing.Value;
// docFile.SaveAs(ref filename, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss);
// object missingValue = Type.Missing;
// object doNotSaveChanges = Word.WdSaveOptions.wdDoNotSaveChanges;
// docFile.Close(ref doNotSaveChanges, ref missingValue, ref missingValue);
// appWord.Quit(ref miss, ref miss, ref miss);
// docFile = null;
// appWord = null;
//}
//catch (Exception ex)
//{
// //捕捉异常，如果出现异常则清空实例，退出word,同时释放资源
// string aa = e.ToString();
// object miss = System.Reflection.Missing.Value;
// object missingValue = Type.Missing;
// object doNotSaveChanges = Word.WdSaveOptions.wdDoNotSaveChanges;
// docFile.Close(ref doNotSaveChanges, ref missingValue, ref missingValue);
// appWord.Quit(ref miss, ref miss, ref miss);
// docFile = null;
// appWord = null;
// throw ex;
//}
}
