public ActionResult BonusPointData_10()
{
Dictionary<string, string> sitemaster = GetSiteMaster();
ViewData["SiteMaster"] = sitemaster;
int UserId = Convert.ToInt32(sitemaster["userid"]);
int Type = 10;
BonusPointDataDao Dao = new BonusPointDataDao();
int Count = Dao.GetCountByUserIdAndTypeId(UserId, Type);
BonusPointData Obj = new BonusPointData();
if (Count == 0)
{
MakeBidDocZJDao Daozj = new MakeBidDocZJDao();
IList<MakeBidDocZJ> ObjzjList = Daozj.FindByUserId(UserId);
MakeBidDocZJ Objzj = new MakeBidDocZJ();
if (ObjzjList != null && ObjzjList.Count != 0)
{
Objzj = ObjzjList.First();
}
Obj.Label1 = Objzj.Label9;
Obj.Label2 = Objzj.Label10;
Obj.Label3 = Objzj.Label11;
Obj.UserId = UserId;
Obj.Type = Type;
Dao.Insert(Obj);
return View(Obj);
}
else
{
Obj = Dao.FindByUserIdAndTypeId(UserId, Type);
return View(Obj);
}
}
public FileResult MakeFile(int ActionCode)
{
Dictionary<string, string> sitemaster = GetSiteMaster();
ViewData["SiteMaster"] = sitemaster;
int UserId = Convert.ToInt32(sitemaster["userid"]);
MakeBidDocZJDao Dao = new MakeBidDocZJDao();
MakeBidDocZJ Obj = Dao.FindByUserId(UserId).SingleOrDefault();
Microsoft.Office.Interop.Word.Application appWord = null;//应用程序
Microsoft.Office.Interop.Word.DocumentClass doc = null;//文档
Dictionary<string, string> Labels = new Dictionary<string, string>();
try
{
object Nothing = System.Reflection.Missing.Value;
appWord = new Microsoft.Office.Interop.Word.Application();
appWord.Visible = false;
object objTrue = true;
object objFalse = false;
object objTemplate = null;
if (ActionCode == 1)
objTemplate = Server.MapPath("~/Template/1.doc");//模板路径
if (ActionCode == 2)
objTemplate = Server.MapPath("~/Template/2.doc");
if (ActionCode == 3)
objTemplate = Server.MapPath("~/Template/3.doc");
object objDocType = Microsoft.Office.Interop.Word.WdDocumentType.wdTypeDocument;
doc = (Microsoft.Office.Interop.Word.DocumentClass)appWord.Documents.Add(ref objTemplate, ref objFalse, ref objDocType, ref objTrue);
//=========================================================================
if (ActionCode == 1)
{
object Label9_1 = "Label9_1";
doc.Bookmarks.get_Item(ref Label9_1).Range.Text = Obj.Label9;
object Label9_2 = "Label9_2";
doc.Bookmarks.get_Item(ref Label9_2).Range.Text = Obj.Label9;
object Label9_3 = "Label9_3";
doc.Bookmarks.get_Item(ref Label9_3).Range.Text = Obj.Label9;
object Label9_4 = "Label9_4";
doc.Bookmarks.get_Item(ref Label9_4).Range.Text = Obj.Label9;
object Label10_1 = "Label10_1";
doc.Bookmarks.get_Item(ref Label10_1).Range.Text = Obj.Label10;
object Label10_2 = "Label10_2";
doc.Bookmarks.get_Item(ref Label10_2).Range.Text = Obj.Label10;
object Label10_3 = "Label10_3";
doc.Bookmarks.get_Item(ref Label10_3).Range.Text = Obj.Label10;
object Label10_4 = "Label10_4";
doc.Bookmarks.get_Item(ref Label10_4).Range.Text = Obj.Label10;
object Label10_5 = "Label10_5";
doc.Bookmarks.get_Item(ref Label10_5).Range.Text = Obj.Label10;
object Label29_1 = "Label29_1";
doc.Bookmarks.get_Item(ref Label29_1).Range.Text = Obj.Label29;
object Label30_1 = "Label30_1";
doc.Bookmarks.get_Item(ref Label30_1).Range.Text = Obj.Label30;
object Label30_2 = "Label30_2";
doc.Bookmarks.get_Item(ref Label30_2).Range.Text = Obj.Label30;
//object Label30_3 = "Label30_3";
//doc.Bookmarks.get_Item(ref Label30_3).Range.Text = Obj.Label30;
object Label31_1 = "Label31_1";
doc.Bookmarks.get_Item(ref Label31_1).Range.Text = Obj.Label31;
object Label32_1 = "Label32_1";
doc.Bookmarks.get_Item(ref Label32_1).Range.Text = Obj.Label32;
object Label33_1 = "Label33_1";
doc.Bookmarks.get_Item(ref Label33_1).Range.Text = Obj.Label33;
object Label33_2 = "Label33_2";
doc.Bookmarks.get_Item(ref Label33_2).Range.Text = Obj.Label33;
object Label34_1 = "Label34_1";
doc.Bookmarks.get_Item(ref Label34_1).Range.Text = Obj.Label34;
object Label34_2 = "Label34_2";
doc.Bookmarks.get_Item(ref Label34_2).Range.Text = Obj.Label34;
if (Obj.Label35 != null)
Labels["Label35_f_1"] = Obj.Label35;
if (Obj.Label36 != null)
Labels["Label36_f_1"] = Obj.Label36;
if (Obj.Label38 != null)
Labels["Label38_f_1"] = Obj.Label38;
if (Obj.Label39 != null)
Labels["Label39_f_1"] = Obj.Label39;
if (Obj.Label40 != null)
Labels["Label40_f_1"] = Obj.Label40;
if (Obj.Label41 != null)
Labels["Label41_f_1"] = Obj.Label41;
foreach (KeyValuePair<string, string> Label in Labels)
{
object InsertKey = Label.Key;
string InsertValue = Label.Value;
if (doc.Bookmarks.Exists((string)InsertKey))
{
string[] InsertValues = InsertValue.Split('|');
for (int i = InsertValues.Length - 1; i > -1; i--)
{
if (System.IO.File.Exists(GetAppSettings("FilePathBase") + InsertValues[i].Replace('/', '\\')))
{
doc.Bookmarks.get_Item(ref InsertKey).Range.InlineShapes.AddPicture(GetAppSettings("FilePathBase") + InsertValues[i].Replace('/', '\\'), ref Nothing, ref Nothing, ref Nothing);
}
}
}
}
}
if (ActionCode == 2)
{
object LabelP2 = "LabelP2_f_1";
doc.Bookmarks.get_Item(ref LabelP2).Range.Text = Obj.LabelP2;
object LabelP4 = "LabelP4_f_1";
doc.Bookmarks.get_Item(ref LabelP4).Range.Text = Obj.LabelP4;
object LabelP5 = "LabelP5_f_1";
doc.Bookmarks.get_Item(ref LabelP5).Range.Text = Obj.LabelP5;
object LabelP8 = "LabelP8_f_1";
doc.Bookmarks.get_Item(ref LabelP8).Range.Text = Obj.LabelP8;
if (Obj.Label1 != null)
Labels["Label1_f_1"] = Obj.Label1;
if (Obj.Label2 != null)
Labels["Label2_f_1"] = Obj.Label2;
if (Obj.Label3 != null)
Labels["Label3_f_1"] = Obj.Label3;
if (Obj.Label4 != null)
Labels["Label4_f_1"] = Obj.Label4;
if (Obj.Label5 != null)
Labels["Label5_f_1"] = Obj.Label5;
if (Obj.Label6 != null)
Labels["Label6_f_1"] = Obj.Label6;
if (Obj.Label7 != null)
Labels["Label7_f_1"] = Obj.Label7;
if (Obj.Label8 != null)
Labels["Label8_f_1"] = Obj.Label8;
if (Obj.Label37 != null)
Labels["Label37_f_1"] = Obj.Label37;
if (Obj.Label42 != null)
Labels["Label42_f_1"] = Obj.Label42;
if (Obj.Label43 != null)
Labels["Label43_f_1"] = Obj.Label43;
foreach (KeyValuePair<string, string> Label in Labels)
{
object InsertKey = Label.Key;
string InsertValue = Label.Value;
if (doc.Bookmarks.Exists((string)InsertKey))
{
string[] InsertValues = InsertValue.Split('|');
for (int i = InsertValues.Length - 1; i > -1; i--)
{
if (System.IO.File.Exists(GetAppSettings("FilePathBase") + InsertValues[i].Replace('/', '\\')))
{
doc.Bookmarks.get_Item(ref InsertKey).Range.InlineShapes.AddPicture(GetAppSettings("FilePathBase") + InsertValues[i].Replace('/', '\\'), ref Nothing, ref Nothing, ref Nothing);
}
}
}
}
}
//doc.Bookmarks.get_Item(ref Test2).Range.InlineShapes.AddPicture("c:\\1.jpg", ref Nothing, ref Nothing, ref Nothing);
//===========================================================================
//doc.Paragraphs.Last.Range.Text = "";
//第四步 生成word
string TempName = Chinaemed.Common.Util.ChinaEmedMD5.GetFullMD5(Guid.NewGuid().ToString()) + ".doc";
object filename = Server.MapPath("~/Template/data/" + TempName);
object miss = System.Reflection.Missing.Value;
doc.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 = Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges;
doc.Close(ref doNotSaveChanges, ref missingValue, ref missingValue);
appWord.Application.Quit(ref miss, ref miss, ref miss);
doc = null;
appWord = null;
return File(filename.ToString(), "application/msword", Obj.LabelP2 + "产品册封面.doc");
}
catch (System.Exception ex)
{
//throw new Exception(ex.Message);
//捕捉异常，如果出现异常则清空实例，退出word,同时释放资源
string aa = ex.ToString();
object miss = System.Reflection.Missing.Value;
object missingValue = Type.Missing;
object doNotSaveChanges = Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges;
doc.Close(ref doNotSaveChanges, ref missingValue, ref missingValue);
appWord.Application.Quit(ref miss, ref miss, ref miss);
doc = null;
appWord = null;
}
return null;
}
public ActionResult MakeBidDoc_ZJ_Save(MakeBidDocZJ M, int? Section)
{
Dictionary<string, string> sitemaster = GetSiteMaster();
ViewData["SiteMaster"] = sitemaster;
int UserId = Convert.ToInt32(sitemaster["userid"]);
MakeBidDocZJDao Dao = new MakeBidDocZJDao();
MakeBidDocZJ Obj = Dao.FindByUserId(UserId).Single();
try
{
if (Section == 1)
{
Obj.Label9 = M.Label9;
Obj.Label10 = M.Label10;
Obj.Label11 = M.Label11;
Obj.Label29 = M.Label29;
Obj.Label30 = M.Label30;
Obj.Label31 = M.Label31;
Obj.Label32 = M.Label32;
Obj.Label33 = M.Label33;
Obj.Label34 = M.Label34;
//Obj.Label12 = M.Label12;
//Obj.Label13 = M.Label13;
//Obj.Label14 = M.Label14;
}
if (Section == 2)
{
Obj.Label35 = M.Label35;
Obj.Label36 = M.Label36;
Obj.Label38 = M.Label38;
Obj.Label39 = M.Label39;
Obj.Label40 = M.Label40;
Obj.Label41 = M.Label41;
}
Dao.UpdateByUserId(Obj);
return RedirectToAction("MakeBidDoc_ZJ");
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
public ActionResult MakeBidDoc_ZJ()
{
Dictionary<string, string> sitemaster = GetSiteMaster();
ViewData["SiteMaster"] = sitemaster;
int UserId = Convert.ToInt32(sitemaster["userid"]);
//ViewData["maxcount"] = 5;
MakeBidDocZJDao Dao = new MakeBidDocZJDao();
int Count = Dao.GetCountByUserId(UserId);
if (Count == 0)
{
MakeBidDocZJ Obj = new MakeBidDocZJ();
Obj.UserId = UserId;
Dao.Insert(Obj);
//ViewData["epcounts"] = 0;
return View(Obj);
}
else
{
MakeBidDocZJ Obj = Dao.FindByUserId(UserId).SingleOrDefault();
//得到已经导出过标书的产品列表
/*IList<IDictionary> list = ProjectManagementMapper.Get().QueryForList<IDictionary>("ExportProduct.GetProducts",UserId);
ViewData["epcounts"] = list.Count;
StringBuilder sb = new StringBuilder();
foreach (IDictionary l in list)
{
sb.Append("<tr><td>" + l["ChineseProductName"] + "</td><td>" + l["Formulation"] + "</td><td>" + l["ChineseSpecification"] + "</td><td>" + l["ChineseManufactureName"] + "</td><td><a href='/ProjectManagement/MakeProductDoc.mvc/"+l["ProductCode"]+"'>修改标书</a></td><tr>");
}
ViewData["Exportlist"] = sb.ToString();*/
return View(Obj);
}
//return View();
}
public ActionResult ExportProducts()
{
Dictionary<string, string> sitemaster = GetSiteMaster();
ViewData["SiteMaster"] = sitemaster;
int UserId = Convert.ToInt32(sitemaster["userid"]);
if (sitemaster["Memberlevel"] == "定制")
ViewData["maxcount"] = ProjectManagementMapper.Get().QueryForObject<int>("MakeBidDocZJ.findmaxcount", UserId);
else
ViewData["maxcount"] = 999;
MakeBidDocZJDao Dao = new MakeBidDocZJDao();
int Count = Dao.GetCountByUserId(UserId);
if (Count == 0)
{
ViewData["epcounts"] = 0;
return View();
}
else
{
//MakeBidDocZJ Obj = Dao.FindByUserId(UserId).SingleOrDefault();
//得到已经导出过标书的产品列表
IList<IDictionary> list = ProjectManagementMapper.Get().QueryForList<IDictionary>("ExportProduct.GetProducts", UserId);
ViewData["epcounts"] = list.Count;
StringBuilder sb = new StringBuilder();
foreach (IDictionary l in list)
{
sb.Append("<tr><td>" + l["ChineseProductName"] + "</td><td>" + l["Formulation"] + "</td><td>" + l["ChineseSpecification"] + "</td><td>" + l["ChineseManufactureName"] + "</td><td><a target='_blank' href='/ProjectManagement/MakeProductDoc.mvc/" + l["ProductCode"] + "'>修改标书</a></td><tr>");
}
ViewData["Exportlist"] = sb.ToString();
return View();
}
}
