public ActionResult GetAutoNo()
{
try
{
string no = AutoNoGenerator.GetMaxNo("AssetsTransfer");
return(Content(no, "text/html"));
}
catch (Exception ex)
{
AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "AssetsTransferController.GetAutoNo", "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace);
return(Content("[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace, "text/html"));
}
}
public ActionResult GetAutoNo()
{
string no = AutoNoGenerator.GetMaxNo("AssetsMerge");
return(Content(no, "text/html"));
}
public static StringBuilder CreateCardExcel(DataSet ds)
{
DataRow dr = ds.Tables["Assets"].Rows[0];
string scrapDate = "";
if (ds.Tables["AssetsScrapDetail"].Rows.Count > 0)
{
scrapDate = DataConvert.ToDateTime(ds.Tables["AssetsScrapDetail"].Rows[0]["scrapDate"]).ToString("yyyy-MM-dd");
}
StringBuilder sbHtml = new StringBuilder();
sbHtml.Append("<table border='1' cellspacing='0' cellpadding='0' style='width:800px'>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;text-align:center;height:40px;' colspan=8><span style='font-weight:bold;font-size:20px;'>{0}</span>　　　　{1}</td>", "固定资产存档表", "存档表编号：" + AutoNoGenerator.GetMaxNo("AssetsCunDang", false, 5));
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;text-align:center;height:20px;' colspan=8><span style='font-weight:bold;'>{0}</span></td>", "基本情况");
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "入库日期");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", DataConvert.ToDateTime(dr["purchaseDate"]).ToString("yyyy-MM-dd"));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "报废日期");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", scrapDate);
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "资产名称");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", DataConvert.ToString(dr["assetsName"]));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "规格/型号");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", DataConvert.ToString(dr["spec"]));
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "资产金额");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", DataConvert.ToString(dr["assetsValue"]));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "原单位资产编号");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", DataConvert.ToString(dr["assetsNo"]));
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "相关附件");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", "");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "出厂编号");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", "");
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "供应厂家/资产来源");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:680px;' colspan=7>{0}</td>", "");
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "资产编号");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", DataConvert.ToString(dr["assetsBarcode"]));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "对应课题号");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:280px;' colspan=3>{0}</td>", "");
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;text-align:center;height:20px;' colspan=8><span style='font-weight:bold;'>{0}</span></td>", "使用记录");
sbHtml.Append("</tr>");
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "领用(移交)日期");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:80px;'>{0}</td>", "领用人");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:80px;'>{0}</td>", "移交人");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "研发小组(所属部门)");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:100px;'>{0}</td>", "联系方式");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:120px;'>{0}</td>", "地点");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:80px;'>{0}</td>", "退库日期");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;width:100px;'>{0}</td>", "备注");
sbHtml.Append("</tr>");
DataTable dtTransfer = ds.Tables["AssetsTransfer"];
foreach (DataRow drTrans in dtTransfer.Rows)
{
sbHtml.Append("<tr>");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;'>{0}</td>", DataConvert.ToDateTime(drTrans["transferDate"]).ToString("yyyy-MM-dd"));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;'>{0}</td>", DataConvert.ToString(drTrans["newUsePeople"]));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;'>{0}</td>", DataConvert.ToString(drTrans["originalUsePeople"]));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;'>{0}</td>", DataConvert.ToString(drTrans["newDepartmentId"]));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;'>{0}</td>", DataConvert.ToString(drTrans["tel"]));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;'>{0}</td>", DataConvert.ToString(drTrans["newStoreSiteId"]));
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;'>{0}</td>", "");
sbHtml.AppendFormat("<td style='font-size:12px;height:20px;'>{0}</td>", DataConvert.ToString(drTrans["remark"]));
sbHtml.Append("</tr>");
}
sbHtml.Append("</table>");
string ss = sbHtml.ToString();
return(sbHtml);
}
