/// <summary>
/// 生成单据根据
/// </summary>
/// <param name="templeteFile">模板文件</param>
/// <param name="saveToFile"></param>
/// <param name="mainDT"></param>
/// <param name="dtls"></param>
public void MakeDocByDataSet(string templeteFile, string saveToPath,
string saveToFileName, DataTable mainDT, DataSet dtlsDS)
{
string valMain = DBAccess.RunSQLReturnString("SELECT NO FROM SYS_MapData");
this.HisGEEntity = new GEEntity(valMain);
this.HisGEEntity.Row.LoadDataTable(mainDT, mainDT.Rows[0]);
this.AddEn(this.HisGEEntity); //增加一个主表。
if (dtlsDS != null)
{
foreach (DataTable dt in dtlsDS.Tables)
{
string dtlID = DBAccess.RunSQLReturnString("SELECT NO FROM SYS_MapDtl ");
GEDtls dtls = new GEDtls(dtlID);
foreach (DataRow dr in dt.Rows)
{
GEDtl dtl = dtls.GetNewEntity as GEDtl;
dtl.Row.LoadDataTable(dt, dr);
dtls.AddEntity(dtl);
}
this.AddDtlEns(dtls); //增加一个明晰。
}
}
this.MakeDoc(templeteFile, saveToPath, saveToFileName, "", false);
}
/// <summary>
/// 生成实体
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public GEEntity GenerGEEntityByDataSet(DataSet ds)
{
// New 它的实例.
GEEntity en = this.HisGEEn;
// 它的table.
DataTable dt = ds.Tables[this.No];
//装载数据.
en.Row.LoadDataTable(dt, dt.Rows[0]);
// dtls.
MapDtls dtls = this.MapDtls;
foreach (MapDtl item in dtls)
{
DataTable dtDtls = ds.Tables[item.No];
GEDtls dtlsEn = new GEDtls(item.No);
foreach (DataRow dr in dtDtls.Rows)
{
// 产生它的Entity data.
GEDtl dtl = (GEDtl)dtlsEn.GetNewEntity;
dtl.Row.LoadDataTable(dtDtls, dr);
//加入这个集合.
dtlsEn.AddEntity(dtl);
}
//加入到他的集合里.
en.Dtls.Add(dtDtls);
}
return(en);
}
public string GenerSum(MapAttr mattr, GEDtls dtls)
{
return("");
//string left = "\n document.forms[0]." + this.ucsys1.GetTBByID("TB_" + mattr.Key).ClientID + ".value = ";
//string right = "";
//int i = 0;
//foreach (GEDtl dtl in dtls)
//{
// string tbID = "TB_" + mattr.Key + "_" + dtl.PKVal;
// TB tb = this.ucsys1.GetTBByID(tbID);
// if (i == 0)
// right += " parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
// else
// right += " +parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
// i++;
//}
//string s = left + right + " ;";
//switch (mattr.MyDataType)
//{
// case BP.DA.DataType.AppMoney:
// case BP.DA.DataType.AppRate:
// return s += "\t\n document.forms[0]." + this.ucsys1.GetTBByID("TB_" + mattr.Key).ClientID + ".value= VirtyMoney(document.forms[0]." + this.ucsys1.GetTBByID("TB_" + mattr.Key).ClientID + ".value ) ;";
// default:
// return s;
//}
}
void btn_Exp_Click(object sender, EventArgs e)
{
Button btn = sender as Button;
string id = btn.ID.Replace("Btn_Exp", "");
MapDtl dtl = new MapDtl(id);
GEDtls dtls = new GEDtls(id);
this.ExportDGToExcelV2(dtls, dtl.Name + ".xls");
return;
}
public string GenerSum(MapAttr mattr, GEDtls dtls)
{
if (dtls.Count <= 1)
{
return("");
}
string ClientID = "";
try
{
ClientID = this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID;
}
catch
{
return("");
}
string left = "\n document.forms[0]." + ClientID + ".value = ";
string right = "";
int i = 0;
foreach (GEDtl dtl in dtls)
{
string tbID = "TB_" + mattr.KeyOfEn + "_" + dtl.OID;
TextBox tb = this.Pub1.GetTextBoxByID(tbID);
if (tb == null)
{
continue;
}
if (i == 0)
{
right += " parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
}
else
{
right += " +parseFloat( document.forms[0]." + tb.ClientID + ".value.replace( ',' , '' ) ) ";
}
i++;
}
string s = left + right + " ;";
switch (mattr.MyDataType)
{
case BP.DA.DataType.AppMoney:
case BP.DA.DataType.AppRate:
return(s += "\t\n document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID + ".value= VirtyMoney(document.forms[0]." + this.Pub1.GetTextBoxByID("TB_" + mattr.KeyOfEn).ClientID + ".value ) ;");
default:
return(s);
}
}
void btn_Imp_Click(object sender, EventArgs e)
{
MapDtl dtl = new MapDtl(this.FK_MapDtl);
Button btn = sender as Button;
if (btn.ID.Contains("ImpClear"))
{
/*如果是清空方式导入。*/
BP.DA.DBAccess.RunSQL("DELETE FROM " + dtl.PTable + " WHERE RefPK='" + this.WorkID + "'");
}
Node nd = new Node(dtl.FK_MapData);
MapData md = new MapData(dtl.FK_MapData);
string starter = "SELECT Rec FROM " + md.PTable + " WHERE OID=" + this.WorkID;
starter = BP.DA.DBAccess.RunSQLReturnString(starter);
GEDtls geDtls = new GEDtls(this.FK_MapDtl);
geDtls.Retrieve(GEDtlAttr.Rec, starter, "IsPass", "0");
string strs = "";
foreach (GEDtl item in geDtls)
{
if (this.Pub1.GetCBByID("CB_" + item.OID).Checked == false)
{
continue;
}
strs += ",'" + item.OID + "'";
}
if (strs == "")
{
this.Alert("请选择要执行的数据。");
return;
}
strs = strs.Substring(1);
BP.DA.DBAccess.RunSQL("UPDATE " + dtl.PTable + " SET RefPK='" + this.WorkID + "',BatchID=0,Check_Note='',Check_RDT='" + BP.DA.DataType.CurrentDataTime + "', Checker='',IsPass=1 WHERE OID IN (" + strs + ")");
this.WinClose();
}
void btn_DelUnPass_Click(object sender, EventArgs e)
{
MapDtl dtl = new MapDtl(this.FK_MapDtl);
Node nd = new Node(dtl.FK_MapData);
MapData md = new MapData(dtl.FK_MapData);
string starter = "SELECT Rec FROM " + md.PTable + " WHERE OID=" + this.WorkID;
starter = BP.DA.DBAccess.RunSQLReturnString(starter);
GEDtls geDtls = new GEDtls(this.FK_MapDtl);
geDtls.Retrieve(GEDtlAttr.Rec, starter, "IsPass", "0");
foreach (GEDtl item in geDtls)
{
if (this.Pub1.GetCBByID("CB_" + item.OID).Checked == false)
{
continue;
}
item.Delete();
}
this.Response.Redirect(this.Request.RawUrl, true);
}
/// <summary>
/// 生成单据根据
/// </summary>
/// <param name="templeteFile">模板文件</param>
/// <param name="saveToFile"></param>
/// <param name="mainDT"></param>
/// <param name="dtls"></param>
public void MakeDocByDataSet(string templeteFile, string saveToPath,
string saveToFileName, DataTable mainDT, DataSet dtlsDS)
{
this.HisGEEntity = new GEEntity("ND101");
this.HisGEEntity.Row.LoadDataTable(mainDT, mainDT.Rows[0]);
this.AddEn(this.HisGEEntity); //增加一个主表。
if (dtlsDS != null)
{
foreach (DataTable dt in dtlsDS.Tables)
{
GEDtls dtls = new GEDtls("ND101Dtl1");
foreach (DataRow dr in dt.Rows)
{
GEDtl dtl = dtls.GetNewEntity as GEDtl;
dtl.Row.LoadDataTable(dt, dr);
dtls.AddEntity(dtl);
}
this.AddDtlEns(dtls); //增加一个明晰。
}
}
this.MakeDoc(templeteFile, saveToPath, saveToFileName, "", false);
}
protected void Page_Load(object sender, EventArgs e)
{
#region 载入相关文件.
this.Page.RegisterClientScriptBlock("sgu",
"<link href='./Style/Frm/Tab.css' rel='stylesheet' type='text/css' />");
this.Page.RegisterClientScriptBlock("s2g4uh",
"<script language='JavaScript' src='./Style/Frm/jquery.min.js' ></script>");
this.Page.RegisterClientScriptBlock("sdfuy24j",
"<script language='JavaScript' src='./Style/Frm/jquery.idTabs.min.js' ></script>");
#endregion 载入相关文件.
#region 查询出来从表.
MapDtl mdtl = new MapDtl(this.EnsName);
GEDtls dtls = new GEDtls(this.EnsName);
QueryObject qo = null;
try
{
qo = new QueryObject(dtls);
switch (mdtl.DtlOpenType)
{
case DtlOpenType.ForEmp:
qo.AddWhere(GEDtlAttr.RefPK, this.RefPKVal);
break;
case DtlOpenType.ForWorkID:
qo.AddWhere(GEDtlAttr.RefPK, this.RefPKVal);
break;
case DtlOpenType.ForFID:
qo.AddWhere(GEDtlAttr.FID, this.RefPKVal);
break;
}
qo.DoQuery();
}
catch (Exception ex)
{
dtls.GetNewEntity.CheckPhysicsTable();
throw ex;
//#region 解决Access 不刷新的问题。
//string rowUrl = this.Request.RawUrl;
//if (rowUrl.IndexOf("rowUrl") > 1)
//{
// throw ex;
//}
//else
//{
// //this.Response.Redirect(rowUrl + "&rowUrl=1&IsWap=" + this.IsWap, true);
// return;
//}
//#endregion
}
#endregion 查询出来从表.
#region 初始化空白行
if (this.IsReadonly == false)
{
mdtl.RowsOfList = mdtl.RowsOfList + this.addRowNum;
int num = dtls.Count;
if (mdtl.IsInsert)
{
int dtlCount = dtls.Count;
for (int i = 0; i < mdtl.RowsOfList - dtlCount; i++)
{
BP.Sys.GEDtl dt = new GEDtl(this.EnsName);
dt.ResetDefaultVal();
dt.OID = i;
dtls.AddEntity(dt);
}
if (num == mdtl.RowsOfList)
{
BP.Sys.GEDtl dt1 = new GEDtl(this.EnsName);
dt1.ResetDefaultVal();
dt1.OID = mdtl.RowsOfList + 1;
dtls.AddEntity(dt1);
}
}
}
#endregion 初始化空白行
this.UCEn1.Clear();
this.UCEn1.Add("<div style='clear:both' ></div>");
this.UCEn1.Add("\t\n<div id='usual2' class='usual'>"); //begain.
#region 输出标签.
this.UCEn1.Add("\t\n <ul style='background:red;border-color: #800000;border-width: 10px;' >");
int idx = 0;
int dtlsNum = dtls.Count;
foreach (GEDtl dtl in dtls)
{
idx++;
this.UCEn1.Add("\t\n<li><a href=\"#" + dtl.OID + "\">第" + idx + "条</a></li>");
}
if (this.IsReadonly == false && mdtl.IsInsert)
{
int addNum = addRowNum + 1;
int cutNum = addRowNum - 1;
if (cutNum >= 0)
{
this.UCEn1.Add("\t\n<li><a href='DtlCard.aspx?EnsName=" + this.EnsName + "&RefPKVal=" + this.RefPKVal + "&addRowNum=" + cutNum + "' >移除</a>|<a href='DtlCard.aspx?EnsName=" + this.EnsName + "&RefPKVal=" + this.RefPKVal + "&addRowNum=" + addNum + "' >插入</a></li>");
}
else
{
this.UCEn1.Add("\t\n<li><a href='DtlCard.aspx?EnsName=" + this.EnsName + "&RefPKVal=" + this.RefPKVal + "&addRowNum=" + addNum + "' >插入</a></li>");
}
}
this.UCEn1.Add("\t\n </ul>");
#endregion 输出标签.
#region 输出从表单内容.
MapData md = new MapData(mdtl.No);
foreach (GEDtl dtl in dtls)
{
this.UCEn1.Add("\t\n <DIV id='" + dtl.OID + "' style='width:" + md.FrmW + "px; height:" + md.FrmH + "px;text-align: left;' >");
string src = "";
src = "FrmDtl.aspx?FK_MapData=" + this.EnsName + "&WorkID=" + this.RefPKVal + "&OID=" + dtl.OID + "&IsReadonly=" + this.IsReadonly;
this.UCEn1.Add("\t\n <iframe ID='F" + dtl.OID + "' src='" + src + "' frameborder=0 style='position:absolute;width:" + md.FrmW + "px; height:" + md.FrmH + "px;text-align: left;' leftMargin='0' topMargin='0' scrolling=no /></iframe>");
this.UCEn1.Add("\t\n </DIV>");
}
#endregion 输出从表单内容.
this.UCEn1.Add("\t\n</div>"); // end usual2
this.UCEn1.Add("\t\n<script type='text/javascript'>");
if (dtls.Count >= 1)
{
this.UCEn1.Add("\t\n $(\"#usual2 ul\").idTabs(\"" + dtls[0].GetValStrByKey("OID") + "\");");
}
this.UCEn1.Add("\t\n</script>");
if (this.IsReadonly == false)
{
}
#region 处理iFrom SaveDtlData。
//string js = "";
//js = "\t\n<script type='text/javascript' >";
//js += "\t\n function SaveDtl(dtl) { ";
//js += "\t\n document.getElementById('F' + dtl ).contentWindow.SaveDtlData();";
//js += "\t\n } ";
//js += "\t\n</script>";
//this.UCEn1.Add(js);
#endregion 处理iFrom SaveDtlData。
}
private void BindExpImp()
{
MapDtl dtl = new MapDtl(this.FK_MapDtl);
if (this.Request.QueryString["Flag"] == "ExpTemplete")
{
string file = this.Request.PhysicalApplicationPath + @"\DataUser\DtlTemplete\" + this.FK_MapDtl + ".xls";
if (System.IO.File.Exists(file) == false)
{
this.WinCloseWithMsg("设计错误：流程设计人员没有把该导入的从表模版放入" + file);
return;
}
BP.Sys.PubClass.OpenExcel(file, dtl.Name + ".xls");
this.WinClose();
}
if (this.Request.QueryString["Flag"] == "ExpTemplete")
{
string file = this.Request.PhysicalApplicationPath + @"\DataUser\DtlTemplete\" + this.FK_MapDtl + ".xls";
if (System.IO.File.Exists(file) == false)
{
this.WinCloseWithMsg("设计错误：流程设计人员没有把该导入的从表模版放入" + file);
return;
}
BP.Sys.PubClass.OpenExcel(file, dtl.Name + ".xls");
this.WinClose();
return;
}
if (this.Request.QueryString["Flag"] == "ExpData")
{
GEDtls dtls = new GEDtls(this.FK_MapDtl);
dtls.Retrieve(GEDtlAttr.RefPK, this.WorkID);
this.ExportDGToExcelV2(dtls, dtl.No + ".xls");
this.WinClose();
return;
}
if (dtl.IsExp)
{
this.Pub1.AddFieldSet("数据导出");
this.Pub1.Add("点下面的连接进行本从表的导出，您可以根据列的需要增减列。");
string urlExp = "DtlOpt.aspx?DoType=" + this.DoType + "&WorkID=" + this.WorkID + "&FID=" + this.FID + "&FK_MapDtl=" + this.FK_MapDtl + "&Flag=ExpData";
this.Pub1.Add("<a href='" + urlExp + "' target=_blank ><img src='../Img/FileType/xls.gif' border=0 /><b>导出数据</b></a>");
this.Pub1.AddFieldSetEnd();
}
if (dtl.IsImp)
{
this.Pub1.AddFieldSet("通过Excel导入:" + dtl.Name);
this.Pub1.Add("下载数据模版:利用数据模板导出一个数据模板，您可以在此基础上进行数据编辑，把编辑好的信息<br>在通过下面的功能导入进来，以提高工作效率。");
string url = "DtlOpt.aspx?DoType=" + this.DoType + "&WorkID=" + this.WorkID + "&FID=" + this.FID + "&FK_MapDtl=" + this.FK_MapDtl + "&Flag=ExpTemplete";
this.Pub1.Add("<a href='" + url + "' target=_blank ><img src='../Img/FileType/xls.gif' border=0 />数据模版</a>");
this.Pub1.Add("<br>");
this.Pub1.Add("格式数据文件:");
System.Web.UI.WebControls.FileUpload fu = new System.Web.UI.WebControls.FileUpload();
fu.ID = "fup";
this.Pub1.Add(fu);
BP.Web.Controls.DDL ddl = new BP.Web.Controls.DDL();
ddl.Items.Add(new ListItem("选择导入方式", "all"));
ddl.Items.Add(new ListItem("清空方式", "0"));
ddl.Items.Add(new ListItem("追加方式", "1"));
ddl.ID = "DDL_ImpWay";
this.Pub1.Add(ddl);
Button btn = new Button();
btn.Text = "导入";
btn.CssClass = "Btn";
btn.ID = "Btn_" + dtl.No;
btn.Click += new EventHandler(btn_Click);
this.Pub1.Add(btn);
this.Pub1.AddFieldSetEnd();
}
if (dtl.IsEnableSelectImp)
{
this.Pub1.AddFieldSet("从数据源导入:" + dtl.Name);
this.Pub1.Add("进入列表，选择一个或者多个记录，然后点确定按钮，执行导入。");
string url = "DtlOpSelectItems.aspx?DoType=" + this.DoType + "&WorkID=" + this.WorkID + "&FID=" + this.FID + "&FK_MapDtl=" + this.FK_MapDtl + "&Flag=ExpTemplete";
this.Pub1.Add("<a href='" + url + "' target=_self ><img src='../Img/Table.gif' border=0 /><b>进入....</b></a>");
this.Pub1.AddFieldSetEnd();
}
}
private void BindUnPass()
{
MapDtl dtl = new MapDtl(this.FK_MapDtl);
Node nd = new Node(dtl.FK_MapData);
MapData md = new MapData(dtl.FK_MapData);
string starter = "SELECT Rec FROM " + md.PTable + " WHERE OID=" + this.WorkID;
starter = BP.DA.DBAccess.RunSQLReturnString(starter);
GEDtls geDtls = new GEDtls(dtl.No);
geDtls.Retrieve(GEDtlAttr.Rec, starter, "IsPass", "0");
MapAttrs attrs = new MapAttrs(dtl.No);
this.Pub1.AddTable();
this.Pub1.AddTR();
this.Pub1.AddTDTitle("IDX");
if (geDtls.Count > 0)
{
string str1 = "<INPUT id='checkedAll' onclick='selectAll()' type='checkbox' name='checkedAll'>";
this.Pub1.AddTDTitle(str1);
}
else
{
this.Pub1.AddTDTitle();
}
string spField = ",Checker,Check_RDT,Check_Note,";
foreach (MapAttr attr in attrs)
{
if (attr.UIVisible == false &&
spField.Contains("," + attr.KeyOfEn + ",") == false)
{
continue;
}
this.Pub1.AddTDTitle(attr.Name);
}
this.Pub1.AddTREnd();
int idx = 0;
foreach (GEDtl item in geDtls)
{
idx++;
this.Pub1.AddTR();
this.Pub1.AddTDIdx(idx);
CheckBox cb = new CheckBox();
cb.ID = "CB_" + item.OID;
this.Pub1.AddTD(cb);
foreach (MapAttr attr in attrs)
{
if (attr.UIVisible == false &&
spField.Contains("," + attr.KeyOfEn + ",") == false)
{
continue;
}
if (attr.MyDataType == BP.DA.DataType.AppBoolean)
{
this.Pub1.AddTD(item.GetValBoolStrByKey(attr.KeyOfEn));
continue;
}
switch (attr.UIContralType)
{
case UIContralType.DDL:
this.Pub1.AddTD(item.GetValRefTextByKey(attr.KeyOfEn));
continue;
default:
this.Pub1.AddTD(item.GetValStrByKey(attr.KeyOfEn));
continue;
}
}
this.Pub1.AddTREnd();
}
this.Pub1.AddTableEndWithHR();
if (geDtls.Count == 0)
{
return;
}
if (nd.IsStartNode == false)
{
return;
}
Button btn = new Button();
btn.ID = "Btn_Delete";
btn.CssClass = "Btn";
btn.Text = "批量删除";
btn.Attributes["onclick"] = " return confirm('您确定要执行吗？');";
btn.Click += new EventHandler(btn_DelUnPass_Click);
this.Pub1.Add(btn);
btn = new Button();
btn.ID = "Btn_Imp";
btn.CssClass = "Btn";
btn.Text = "导入并重新编辑(追加方式)";
btn.Click += new EventHandler(btn_Imp_Click);
this.Pub1.Add(btn);
btn = new Button();
btn.ID = "Btn_ImpClear";
btn.CssClass = "Btn";
btn.Text = "导入并重新编辑(清空方式)";
btn.Click += new EventHandler(btn_Imp_Click);
this.Pub1.Add(btn);
}
protected void Page_Load(object sender, System.EventArgs e)
{
Response.AddHeader("P3P", "CP=CAO PSA OUR");
Response.AddHeader("Cache-Control", "no-store");
Response.AddHeader("Expires", "0");
Response.AddHeader("Pragma", "no-cache");
string url = this.Request.RawUrl;
if (url.Contains("DTT=") == false)
{
//this.Response.Redirect(url + "&DTT=" + DateTime.Now.ToString("mmDDhhmmss"), true);
//return;
}
try
{
switch (this.ActionType)
{
case "Focus": //把任务放入任务池.
BP.WF.Dev2Interface.Flow_Focus(Int64.Parse(this.Request.QueryString["WorkID"]));
this.WinClose("ss");
break;
case "PutOne": //把任务放入任务池.
Int64 workid42 = Int64.Parse(this.Request.QueryString["WorkID"]);
BP.WF.Dev2Interface.Node_TaskPoolPutOne(workid42);
this.WinClose("ss");
break;
case "DoAppTask": // 申请任务.
Int64 workid2 = Int64.Parse(this.Request.QueryString["WorkID"]);
BP.WF.Dev2Interface.Node_TaskPoolTakebackOne(workid2);
this.WinClose("ss");
return;
case "DoOpenCC":
string fk_flow1 = this.Request.QueryString["FK_Flow"];
string fk_node1 = this.Request.QueryString["FK_Node"];
string workid1 = this.Request.QueryString["WorkID"];
string fid1 = this.Request.QueryString["FID"];
string Sta = this.Request.QueryString["Sta"];
if (Sta == "0")
{
BP.WF.Template.CCList cc1 = new BP.WF.Template.CCList();
cc1.MyPK = this.Request.QueryString["MyPK"];
cc1.Retrieve();
cc1.HisSta = CCSta.Read;
cc1.Update();
}
this.Response.Redirect("./WorkOpt/OneWork/Track.aspx?FK_Flow=" + fk_flow1 + "&FK_Node=" + fk_node1 + "&WorkID=" + workid1 + "&FID=" + fid1, false);
return;
case "DelCC": //删除抄送.
CCList cc = new CCList();
cc.MyPK = this.MyPK;
cc.Retrieve();
cc.HisSta = CCSta.Del;
cc.Update();
this.WinClose();
break;
case "DelSubFlow": //删除进程。
try
{
BP.WF.Dev2Interface.Flow_DeleteSubThread(this.FK_Flow, this.WorkID, "手工删除");
this.WinClose();
}
catch (Exception ex)
{
this.WinCloseWithMsg(ex.Message);
}
break;
case "DownBill":
Bill b = new Bill(this.MyPK);
b.DoOpen();
break;
case "DelDtl":
GEDtls dtls = new GEDtls(this.EnsName);
GEDtl dtl = (GEDtl)dtls.GetNewEntity;
dtl.OID = this.RefOID;
if (dtl.RetrieveFromDBSources() == 0)
{
this.WinClose();
break;
}
FrmEvents fes = new FrmEvents(this.EnsName); //获得事件.
// 处理删除前事件.
try
{
fes.DoEventNode(BP.WF.XML.EventListDtlList.DtlItemDelBefore, dtl);
}
catch (Exception ex)
{
this.WinCloseWithMsg(ex.Message);
break;
}
dtl.Delete();
// 处理删除后事件.
try
{
fes.DoEventNode(BP.WF.XML.EventListDtlList.DtlItemDelAfter, dtl);
}
catch (Exception ex)
{
this.WinCloseWithMsg(ex.Message);
break;
}
this.WinClose();
break;
case "EmpDoUp":
BP.WF.Port.WFEmp ep = new BP.WF.Port.WFEmp(this.RefNo);
ep.DoUp();
BP.WF.Port.WFEmps emps111 = new BP.WF.Port.WFEmps();
// emps111.RemoveCash();
emps111.RetrieveAll();
this.WinClose();
break;
case "EmpDoDown":
BP.WF.Port.WFEmp ep1 = new BP.WF.Port.WFEmp(this.RefNo);
ep1.DoDown();
BP.WF.Port.WFEmps emps11441 = new BP.WF.Port.WFEmps();
// emps11441.RemoveCash();
emps11441.RetrieveAll();
this.WinClose();
break;
case "Track": //通过一个串来打开一个工作.
string mySid = this.Request.QueryString["SID"];
string[] mystrs = mySid.Split('_');
Int64 myWorkID = int.Parse(mystrs[1]);
string fk_emp = mystrs[0];
int fk_node = int.Parse(mystrs[2]);
Node mynd = new Node();
mynd.NodeID = fk_node;
mynd.RetrieveFromDBSources();
string fk_flow = mynd.FK_Flow;
string myurl = "./WorkOpt/OneWork/Track.aspx?FK_Node=" + mynd.NodeID + "&WorkID=" + myWorkID + "&FK_Flow=" + fk_flow;
Web.WebUser.SignInOfGener(new BP.Port.Emp(fk_emp), true);
this.Response.Write("<script> window.location.href='" + myurl + "'</script> *^_^* <br><br>正在进入系统请稍后，如果长时间没有反应，请<a href='" + myurl + "'>点这里进入。</a>");
return;
case "OF": //通过一个串来打开一个工作.
string sid = this.Request.QueryString["SID"];
string[] strs = sid.Split('_');
GenerWorkerList wl = new GenerWorkerList();
int i = wl.Retrieve(GenerWorkerListAttr.FK_Emp, strs[0],
GenerWorkerListAttr.WorkID, strs[1],
GenerWorkerListAttr.FK_Node, strs[2]);
if (i == 0)
{
this.Response.Write("<h2>提示</h2>此工作已经被别人处理或者此流程已删除。");
return;
}
BP.Port.Emp empOF = new BP.Port.Emp(wl.FK_Emp);
Web.WebUser.SignInOfGener(empOF, true);
string u = "MyFlow.aspx?FK_Flow=" + wl.FK_Flow + "&WorkID=" + wl.WorkID + "&FK_Node=" + wl.FK_Node + "&FID=" + wl.FID;
this.Response.Write("<script> window.location.href='" + u + "'</script> *^_^* <br><br>正在进入系统请稍后，如果长时间没有反应，请<a href='" + u + "'>点这里进入。</a>");
return;
case "ExitAuth":
BP.Port.Emp emp = new BP.Port.Emp(this.FK_Emp);
//首先退出，再进行登录
BP.Web.WebUser.Exit();
BP.Web.WebUser.SignInOfGenerLang(emp, WebUser.SysLang);
this.WinClose();
return;
case "LogAs":
BP.WF.Port.WFEmp wfemp = new BP.WF.Port.WFEmp(this.FK_Emp);
if (wfemp.AuthorIsOK == false)
{
this.WinCloseWithMsg("授权失败");
return;
}
BP.Port.Emp emp1 = new BP.Port.Emp(this.FK_Emp);
BP.Web.WebUser.SignInOfGener(emp1, WebUser.SysLang, WebUser.No, true, false);
this.WinClose();
return;
case "TakeBack": // 取消授权。
BP.WF.Port.WFEmp myau = new BP.WF.Port.WFEmp(WebUser.No);
BP.DA.Log.DefaultLogWriteLineInfo("取消授权:" + WebUser.No + "取消了对(" + myau.Author + ")的授权。");
myau.Author = "";
myau.AuthorWay = 0;
myau.Update();
this.WinClose();
return;
case "AutoTo": // 执行授权。
BP.WF.Port.WFEmp au = new BP.WF.Port.WFEmp();
au.No = WebUser.No;
au.RetrieveFromDBSources();
au.AuthorDate = BP.DA.DataType.CurrentData;
au.Author = this.FK_Emp;
au.AuthorWay = 1;
au.Save();
BP.DA.Log.DefaultLogWriteLineInfo("执行授权:" + WebUser.No + "执行了对(" + au.Author + ")的授权。");
this.WinClose();
return;
case "UnSend": //执行撤消发送。
this.Response.Redirect("./WorkOpt/UnSend.aspx?WorkID=" + this.WorkID + "&FK_Flow=" + this.FK_Flow, false);
return;
case "SetBillState":
break;
case "WorkRpt":
Bill bk1 = new Bill(this.Request.QueryString["OID"]);
Node nd = new Node(bk1.FK_Node);
this.Response.Redirect("WFRpt.aspx?WorkID=" + bk1.WorkID + "&FID=" + bk1.FID + "&FK_Flow=" + nd.FK_Flow + "&NodeId=" + bk1.FK_Node, false);
//this.WinOpen();
//this.WinClose();
break;
case "PrintBill":
//Bill bk2 = new Bill(this.Request.QueryString["OID"]);
//Node nd2 = new Node(bk2.FK_Node);
//this.Response.Redirect("NodeRefFunc.aspx?NodeId=" + bk2.FK_Node + "&FlowNo=" + nd2.FK_Flow + "&NodeRefFuncOID=" + bk2.FK_NodeRefFunc + "&WorkFlowID=" + bk2.WorkID);
////this.WinClose();
break;
//删除流程中第一个节点的数据，包括待办工作
case "DeleteFlow":
string fk_flowDel = this.Request.QueryString["FK_Flow"];
Int64 workid = Int64.Parse(this.Request.QueryString["WorkID"]);
//调用DoDeleteWorkFlowByReal方法
WorkFlow wf = new WorkFlow(new Flow(fk_flowDel), workid);
wf.DoDeleteWorkFlowByReal(true);
// Glo.ToMsg("流程删除成功");
BP.WF.Glo.ToMsg("流程删除成功");
//this.ToWFMsgPage("流程删除成功");
break;
default:
throw new Exception("ActionType error" + this.ActionType);
}
}
catch (Exception ex)
{
this.ToErrorPage("执行其间如下异常：<BR>" + ex.Message);
}
}
/// <summary>
/// 创建WorkID
/// </summary>
/// <param name="flowNo">流程编号</param>
/// <param name="ht">表单参数，可以为null。</param>
/// <param name="workDtls">明细表参数，可以为null。</param>
/// <param name="starter">流程的发起人</param>
/// <param name="title">创建工作时的标题，如果为null，就按设置的规则生成。</param>
/// <param name="parentWorkID">父流程的WorkID,如果没有父流程就传入为0.</param>
/// <param name="parentFlowNo">父流程的流程编号,如果没有父流程就传入为null.</param>
/// <returns>为开始节点创建工作后产生的WorkID.</returns>
public static Int64 Node_CreateBlankWork(string flowNo, Hashtable ht, DataSet workDtls,
string guestNo, string title, Int64 parentWorkID, string parentFlowNo, int parentNodeID, string parentEmp)
{
//if (BP.Web.WebUser.No != "Guest")
// throw new Exception("@必须是Guest登陆才能发起.");
string dbstr = SystemConfig.AppCenterDBVarStr;
Flow fl = new Flow(flowNo);
Node nd = new Node(fl.StartNodeID);
//把一些其他的参数也增加里面去,传递给ccflow.
Hashtable htPara = new Hashtable();
if (parentWorkID != 0)
{
htPara.Add(StartFlowParaNameList.PWorkID, parentWorkID);
}
if (parentFlowNo != null)
{
htPara.Add(StartFlowParaNameList.PFlowNo, parentFlowNo);
}
if (parentNodeID != 0)
{
htPara.Add(StartFlowParaNameList.PNodeID, parentNodeID);
}
if (parentEmp != null)
{
htPara.Add(StartFlowParaNameList.PEmp, parentEmp);
}
Emp empStarter = new Emp(BP.Web.WebUser.No);
Work wk = fl.NewWork(empStarter, htPara);
Int64 workID = wk.OID;
#region 给各个属性-赋值
if (ht != null)
{
foreach (string str in ht.Keys)
{
wk.SetValByKey(str, ht[str]);
}
}
wk.OID = workID;
if (workDtls != null)
{
//保存从表
foreach (DataTable dt in workDtls.Tables)
{
foreach (MapDtl dtl in wk.HisMapDtls)
{
if (dt.TableName != dtl.No)
{
continue;
}
//获取dtls
GEDtls daDtls = new GEDtls(dtl.No);
daDtls.Delete(GEDtlAttr.RefPK, wk.OID); // 清除现有的数据.
GEDtl daDtl = daDtls.GetNewEntity as GEDtl;
daDtl.RefPK = wk.OID.ToString();
// 为从表复制数据.
foreach (DataRow dr in dt.Rows)
{
daDtl.ResetDefaultVal();
daDtl.RefPK = wk.OID.ToString();
//明细列.
foreach (DataColumn dc in dt.Columns)
{
//设置属性.
daDtl.SetValByKey(dc.ColumnName, dr[dc.ColumnName]);
}
daDtl.InsertAsOID(DBAccess.GenerOID("Dtl")); //插入数据.
}
}
}
}
#endregion 赋值
Paras ps = new Paras();
// 执行对报表的数据表WFState状态的更新,让它为runing的状态.
if (DataType.IsNullOrEmpty(title) == false)
{
ps = new Paras();
ps.SQL = "UPDATE " + fl.PTable + " SET WFState=" + dbstr + "WFState,Title=" + dbstr + "Title WHERE OID=" + dbstr + "OID";
ps.Add(GERptAttr.WFState, (int)WFState.Blank);
ps.Add(GERptAttr.Title, title);
ps.Add(GERptAttr.OID, wk.OID);
DBAccess.RunSQL(ps);
}
else
{
ps = new Paras();
ps.SQL = "UPDATE " + fl.PTable + " SET WFState=" + dbstr + "WFState,FK_Dept=" + dbstr + "FK_Dept,Title=" + dbstr + "Title WHERE OID=" + dbstr + "OID";
ps.Add(GERptAttr.WFState, (int)WFState.Blank);
ps.Add(GERptAttr.FK_Dept, empStarter.FK_Dept);
ps.Add(GERptAttr.Title, BP.WF.WorkFlowBuessRole.GenerTitle(fl, wk));
ps.Add(GERptAttr.OID, wk.OID);
DBAccess.RunSQL(ps);
}
// 删除有可能产生的垃圾数据,比如上一次没有发送成功，导致数据没有清除.
ps = new Paras();
ps.SQL = "DELETE FROM WF_GenerWorkFlow WHERE WorkID=" + dbstr + "WorkID1 OR FID=" + dbstr + "WorkID2";
ps.Add("WorkID1", wk.OID);
ps.Add("WorkID2", wk.OID);
DBAccess.RunSQL(ps);
ps = new Paras();
ps.SQL = "DELETE FROM WF_GenerWorkerList WHERE WorkID=" + dbstr + "WorkID1 OR FID=" + dbstr + "WorkID2";
ps.Add("WorkID1", wk.OID);
ps.Add("WorkID2", wk.OID);
DBAccess.RunSQL(ps);
// 设置流程信息
if (parentWorkID != 0)
{
BP.WF.Dev2Interface.SetParentInfo(flowNo, workID, parentWorkID);
}
#region 处理generworkid
// 设置父流程信息.
GenerWorkFlow gwf = new GenerWorkFlow();
gwf.WorkID = wk.OID;
int i = gwf.RetrieveFromDBSources();
//将流程信息提前写入wf_GenerWorkFlow,避免查询不到
gwf.FlowName = fl.Name;
gwf.FK_Flow = flowNo;
gwf.FK_FlowSort = fl.FK_FlowSort;
gwf.SysType = fl.SysType;
gwf.FK_Dept = WebUser.FK_Dept;
gwf.DeptName = WebUser.FK_DeptName;
gwf.FK_Node = fl.StartNodeID;
gwf.NodeName = nd.Name;
gwf.WFState = WFState.Runing;
if (DataType.IsNullOrEmpty(title))
{
gwf.Title = BP.WF.WorkFlowBuessRole.GenerTitle(fl, wk);
}
else
{
gwf.Title = title;
}
gwf.Starter = WebUser.No;
gwf.StarterName = WebUser.Name;
gwf.RDT = DataType.CurrentDataTimess;
gwf.PWorkID = parentWorkID;
// gwf.PFID = parentFID;
gwf.PFlowNo = parentFlowNo;
gwf.PNodeID = parentNodeID;
if (i == 0)
{
gwf.Insert();
}
else
{
gwf.Update();
}
//插入待办.
GenerWorkerList gwl = new GenerWorkerList();
gwl.WorkID = wk.OID;
gwl.FK_Node = nd.NodeID;
gwl.FK_Emp = WebUser.No;
i = gwl.RetrieveFromDBSources();
gwl.FK_EmpText = WebUser.Name;
gwl.FK_NodeText = nd.Name;
gwl.FID = 0;
gwl.FK_Flow = fl.No;
gwl.FK_Dept = WebUser.FK_Dept;
gwl.FK_DeptT = WebUser.FK_DeptName;
gwl.SDT = "无";
gwl.DTOfWarning = DataType.CurrentDataTime;
gwl.IsEnable = true;
gwl.IsPass = false;
gwl.PRI = gwf.PRI;
if (i == 0)
{
gwl.Insert();
}
else
{
gwl.Update();
}
#endregion
return(wk.OID);
}
/// <summary>
/// 创建WorkID
/// </summary>
/// <param name="flowNo">流程编号</param>
/// <param name="ht">表单参数，可以为null。</param>
/// <param name="workDtls">明细表参数，可以为null。</param>
/// <param name="starter">流程的发起人</param>
/// <param name="title">创建工作时的标题，如果为null，就按设置的规则生成。</param>
/// <param name="parentWorkID">父流程的WorkID,如果没有父流程就传入为0.</param>
/// <param name="parentFlowNo">父流程的流程编号,如果没有父流程就传入为null.</param>
/// <returns>为开始节点创建工作后产生的WorkID.</returns>
public static Int64 Node_CreateBlankWork(string flowNo, Hashtable ht, DataSet workDtls,
string guestNo, string title, Int64 parentWorkID, string parentFlowNo, int parentNodeID, string parentEmp)
{
//转化成编号.
flowNo = TurnFlowMarkToFlowNo(flowNo);
//转化成编号
parentFlowNo = TurnFlowMarkToFlowNo(parentFlowNo);
string dbstr = SystemConfig.AppCenterDBVarStr;
Flow fl = new Flow(flowNo);
Node nd = new Node(fl.StartNodeID);
Emp empStarter = new Emp(BP.Web.WebUser.No);
//把一些其他的参数也增加里面去,传递给ccflow.
Hashtable htPara = new Hashtable();
if (parentWorkID != 0)
{
htPara.Add(StartFlowParaNameList.PWorkID, parentWorkID);
}
if (parentFlowNo != null)
{
htPara.Add(StartFlowParaNameList.PFlowNo, parentFlowNo);
}
if (parentNodeID != 0)
{
htPara.Add(StartFlowParaNameList.PNodeID, parentNodeID);
}
if (parentEmp != null)
{
htPara.Add(StartFlowParaNameList.PEmp, parentEmp);
}
Work wk = fl.NewWork(empStarter, htPara);
Int64 workID = wk.OID;
#region 给各个属性-赋值
if (ht != null)
{
foreach (string str in ht.Keys)
{
wk.SetValByKey(str, ht[str]);
}
}
wk.OID = workID;
if (workDtls != null)
{
//保存从表
foreach (DataTable dt in workDtls.Tables)
{
foreach (MapDtl dtl in wk.HisMapDtls)
{
if (dt.TableName != dtl.No)
{
continue;
}
//获取dtls
GEDtls daDtls = new GEDtls(dtl.No);
daDtls.Delete(GEDtlAttr.RefPK, wk.OID); // 清除现有的数据.
GEDtl daDtl = daDtls.GetNewEntity as GEDtl;
daDtl.RefPK = wk.OID.ToString();
// 为从表复制数据.
foreach (DataRow dr in dt.Rows)
{
daDtl.ResetDefaultVal();
daDtl.RefPK = wk.OID.ToString();
//明细列.
foreach (DataColumn dc in dt.Columns)
{
//设置属性.
daDtl.SetValByKey(dc.ColumnName, dr[dc.ColumnName]);
}
daDtl.InsertAsOID(DBAccess.GenerOID("Dtl")); //插入数据.
}
}
}
}
#endregion 赋值
Paras ps = new Paras();
// 执行对报表的数据表WFState状态的更新,让它为runing的状态.
if (string.IsNullOrEmpty(title) == false)
{
if (fl.TitleRole != "@OutPara")
{
fl.TitleRole = "@OutPara";
fl.Update();
}
ps = new Paras();
ps.SQL = "UPDATE " + fl.PTable + " SET WFState=" + dbstr + "WFState,Title=" + dbstr + "Title WHERE OID=" + dbstr + "OID";
ps.Add(GERptAttr.WFState, (int)WFState.Blank);
ps.Add(GERptAttr.Title, title);
ps.Add(GERptAttr.OID, wk.OID);
DBAccess.RunSQL(ps);
}
else
{
ps = new Paras();
ps.SQL = "UPDATE " + fl.PTable + " SET WFState=" + dbstr + "WFState,FK_Dept=" + dbstr + "FK_Dept,Title=" + dbstr + "Title WHERE OID=" + dbstr + "OID";
ps.Add(GERptAttr.WFState, (int)WFState.Blank);
ps.Add(GERptAttr.FK_Dept, empStarter.FK_Dept);
ps.Add(GERptAttr.Title, WorkNode.GenerTitle(fl, wk));
ps.Add(GERptAttr.OID, wk.OID);
DBAccess.RunSQL(ps);
}
// 删除有可能产生的垃圾数据,比如上一次没有发送成功，导致数据没有清除.
ps = new Paras();
ps.SQL = "DELETE FROM WF_GenerWorkFlow WHERE WorkID=" + dbstr + "WorkID1 OR FID=" + dbstr + "WorkID2";
ps.Add("WorkID1", wk.OID);
ps.Add("WorkID2", wk.OID);
DBAccess.RunSQL(ps);
ps = new Paras();
ps.SQL = "DELETE FROM WF_GenerWorkerList WHERE WorkID=" + dbstr + "WorkID1 OR FID=" + dbstr + "WorkID2";
ps.Add("WorkID1", wk.OID);
ps.Add("WorkID2", wk.OID);
DBAccess.RunSQL(ps);
// 设置流程信息
if (parentWorkID != 0)
{
BP.WF.Dev2Interface.SetParentInfo(flowNo, workID, parentFlowNo, parentWorkID, parentNodeID, parentEmp);
}
return(wk.OID);
}
public void PrintBill()
{
BP.WF.Node nd = new BP.WF.Node(this.FK_Node);
string path = ApplicationPath + "\\DataUser\\CyclostyleFile\\FlowFrm\\" + nd.FK_Flow + "\\" + nd.NodeID + "\\";
if (System.IO.Directory.Exists(path) == false)
{
}
string[] fls = System.IO.Directory.GetFiles(path);
string file = fls[int.Parse(this.BillIdx)];
file = file.Replace(ApplicationPath + @"DataUser\CyclostyleFile", "");
FileInfo finfo = new FileInfo(file);
string tempName = finfo.Name.Split('.')[0];
string tempNameChinese = finfo.Name.Split('.')[1];
string toPath = ApplicationPath + @"DataUser\Bill\FlowFrm\" + DateTime.Now.ToString("yyyyMMdd") + "\\";
if (System.IO.Directory.Exists(toPath) == false)
{
System.IO.Directory.CreateDirectory(toPath);
}
string billFile = toPath + "\\" + tempName + "." + this.FID + ".doc";
BP.Rpt.RTF.RTFEngine engine = new BP.Rpt.RTF.RTFEngine();
if (tempName.ToLower() == "all")
{
FrmNodes fns = new FrmNodes(this.FK_Node);
foreach (FrmNode fn in fns)
{
GEEntity ge = new GEEntity(fn.FK_Frm, this.WorkID);
engine.AddEn(ge);
MapDtls mdtls = new MapDtls(tempName);
foreach (MapDtl dtl in mdtls)
{
GEDtls enDtls = dtl.HisGEDtl.GetNewEntities as GEDtls;
enDtls.Retrieve(GEDtlAttr.RefPK, this.WorkID);
engine.EnsDataDtls.Add(enDtls);
}
}
// 增加主表.
GEEntity myge = new GEEntity("ND" + nd.NodeID, this.WorkID);
engine.AddEn(myge);
MapDtls mymdtls = new MapDtls("ND" + nd.NodeID);
foreach (MapDtl dtl in mymdtls)
{
GEDtls enDtls = dtl.HisGEDtl.GetNewEntities as GEDtls;
enDtls.Retrieve(GEDtlAttr.RefPK, this.WorkID);
engine.EnsDataDtls.Add(enDtls);
}
engine.MakeDoc(file, toPath, tempName + "." + this.WorkID + ".doc", null, false);
}
else
{
// 增加主表.
GEEntity myge = new GEEntity(tempName, this.FID);
engine.HisGEEntity = myge;
engine.AddEn(myge);
MapDtls mymdtls = new MapDtls(tempName);
foreach (MapDtl dtl in mymdtls)
{
GEDtls enDtls = dtl.HisGEDtl.GetNewEntities as GEDtls;
enDtls.Retrieve(GEDtlAttr.RefPK, this.WorkID);
engine.EnsDataDtls.Add(enDtls);
}
engine.MakeDoc(file, toPath, tempName + "." + this.FID + ".doc", null, false);
}
BP.PubClass.OpenWordDocV2(billFile, tempNameChinese + ".doc");
}
/// <summary>
/// 产生一个WorkNode
/// </summary>
/// <param name="fk_flow">流程编号</param>
/// <param name="fk_node">节点ID</param>
/// <param name="workID">工作ID</param>
/// <param name="fid">FID</param>
/// <param name="userNo">用户编号</param>
/// <returns>返回dataset</returns>
public static DataSet GenerWorkNodeForAndroid(string fk_flow, int fk_node, Int64 workID, Int64 fid, string userNo)
{
if (fk_node == 0)
{
fk_node = int.Parse(fk_flow + "01");
}
if (workID == 0)
{
workID = BP.WF.Dev2Interface.Node_CreateBlankWork(fk_flow, null, null, userNo, null);
}
try
{
Emp emp = new Emp(userNo);
BP.Web.WebUser.SignInOfGener(emp);
MapData md = new MapData();
md.No = "ND" + fk_node;
if (md.RetrieveFromDBSources() == 0)
{
throw new Exception("装载错误，该表单ID=" + md.No + "丢失，请修复一次流程重新加载一次.");
}
//表单模版.
DataSet myds = BP.Sys.CCFormAPI.GenerHisDataSet(md.No);
return(myds);
#region 流程设置信息.
Node nd = new Node(fk_node);
if (nd.IsStartNode == false)
{
BP.WF.Dev2Interface.Node_SetWorkRead(fk_node, workID);
}
// 节点数据.
string sql = "SELECT * FROM WF_Node WHERE NodeID=" + fk_node;
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "WF_NodeBar";
myds.Tables.Add(dt);
// 流程数据.
Flow fl = new Flow(fk_flow);
myds.Tables.Add(fl.ToDataTableField("WF_Flow"));
#endregion 流程设置信息.
#region 把主从表数据放入里面.
//.工作数据放里面去, 放进去前执行一次装载前填充事件.
BP.WF.Work wk = nd.HisWork;
wk.OID = workID;
wk.RetrieveFromDBSources();
// 处理传递过来的参数。
foreach (string k in System.Web.HttpContext.Current.Request.QueryString.AllKeys)
{
wk.SetValByKey(k, System.Web.HttpContext.Current.Request.QueryString[k]);
}
// 执行一次装载前填充.
string msg = md.DoEvent(FrmEventList.FrmLoadBefore, wk);
if (DataType.IsNullOrEmpty(msg) == false)
{
throw new Exception("错误:" + msg);
}
wk.ResetDefaultVal();
myds.Tables.Add(wk.ToDataTableField(md.No));
//把附件的数据放入.
if (md.FrmAttachments.Count > 0)
{
sql = "SELECT * FROM Sys_FrmAttachmentDB where RefPKVal=" + workID + " AND FK_MapData='ND" + fk_node + "'";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_FrmAttachmentDB";
myds.Tables.Add(dt);
}
// 图片附件数据放入
if (md.FrmImgAths.Count > 0)
{
sql = "SELECT * FROM Sys_FrmImgAthDB where RefPKVal=" + workID + " AND FK_MapData='ND" + fk_node + "'";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_FrmImgAthDB";
myds.Tables.Add(dt);
}
//把从表的数据放入.
if (md.MapDtls.Count > 0)
{
foreach (MapDtl dtl in md.MapDtls)
{
GEDtls dtls = new GEDtls(dtl.No);
QueryObject qo = null;
try
{
qo = new QueryObject(dtls);
switch (dtl.DtlOpenType)
{
case DtlOpenType.ForEmp: // 按人员来控制.
qo.AddWhere(GEDtlAttr.RefPK, workID);
qo.addAnd();
qo.AddWhere(GEDtlAttr.Rec, WebUser.No);
break;
case DtlOpenType.ForWorkID: // 按工作ID来控制
qo.AddWhere(GEDtlAttr.RefPK, workID);
break;
case DtlOpenType.ForFID: // 按流程ID来控制.
qo.AddWhere(GEDtlAttr.FID, workID);
break;
}
}
catch
{
dtls.GetNewEntity.CheckPhysicsTable();
}
DataTable dtDtl = qo.DoQueryToTable();
// 为明细表设置默认值.
MapAttrs dtlAttrs = new MapAttrs(dtl.No);
foreach (MapAttr attr in dtlAttrs)
{
//处理它的默认值.
if (attr.DefValReal.Contains("@") == false)
{
continue;
}
foreach (DataRow dr in dtDtl.Rows)
{
dr[attr.KeyOfEn] = attr.DefVal;
}
}
dtDtl.TableName = dtl.No; //修改明细表的名称.
myds.Tables.Add(dtDtl); //加入这个明细表, 如果没有数据，xml体现为空.
}
}
#endregion
#region 把外键表加入DataSet
DataTable dtMapAttr = myds.Tables["Sys_MapAttr"];
foreach (DataRow dr in dtMapAttr.Rows)
{
string lgType = dr["LGType"].ToString();
if (lgType.Equals("2") == false)
{
continue;
}
string UIIsEnable = dr["UIIsEnable"].ToString();
if (UIIsEnable.Equals("0") == true)
{
continue;
}
string uiBindKey = dr["UIBindKey"].ToString();
if (DataType.IsNullOrEmpty(uiBindKey) == true)
{
string myPK = dr["MyPK"].ToString();
/*如果是空的*/
throw new Exception("@属性字段数据不完整，流程:" + fl.No + fl.Name + ",节点:" + nd.NodeID + nd.Name + ",属性:" + myPK + ",的UIBindKey IsNull ");
}
// 判断是否存在.
if (myds.Tables.Contains(uiBindKey) == true)
{
continue;
}
myds.Tables.Add(BP.Sys.PubClass.GetDataTableByUIBineKey(uiBindKey));
}
#endregion End把外键表加入DataSet
#region 把流程信息放入里面.
//把流程信息表发送过去.
GenerWorkFlow gwf = new GenerWorkFlow();
gwf.WorkID = workID;
gwf.RetrieveFromDBSources();
myds.Tables.Add(gwf.ToDataTableField("WF_GenerWorkFlow"));
if (gwf.WFState == WFState.Shift)
{
//如果是转发.
BP.WF.ShiftWorks fws = new ShiftWorks();
fws.Retrieve(ShiftWorkAttr.WorkID, workID, ShiftWorkAttr.FK_Node, fk_node);
myds.Tables.Add(fws.ToDataTableField("WF_ShiftWork"));
}
if (gwf.WFState == WFState.ReturnSta)
{
//如果是退回.
ReturnWorks rts = new ReturnWorks();
rts.Retrieve(ReturnWorkAttr.WorkID, workID,
ReturnWorkAttr.ReturnToNode, fk_node,
ReturnWorkAttr.RDT);
myds.Tables.Add(rts.ToDataTableField("WF_ReturnWork"));
}
if (gwf.WFState == WFState.HungUp)
{
//如果是挂起.
HungUps hups = new HungUps();
hups.Retrieve(HungUpAttr.WorkID, workID, HungUpAttr.FK_Node, fk_node);
myds.Tables.Add(hups.ToDataTableField("WF_HungUp"));
}
//if (gwf.WFState == WFState.Askfor)
//{
// //如果是加签.
// BP.WF.ShiftWorks fws = new ShiftWorks();
// fws.Retrieve(ShiftWorkAttr.WorkID, workID, ShiftWorkAttr.FK_Node, fk_node);
// myds.Tables.Add(fws.ToDataTableField("WF_ShiftWork"));
//}
Int64 wfid = workID;
if (fid != 0)
{
wfid = fid;
}
//放入track信息.
Paras ps = new Paras();
ps.SQL = "SELECT * FROM ND" + int.Parse(fk_flow) + "Track WHERE WorkID=" + BP.Sys.SystemConfig.AppCenterDBVarStr + "WorkID";
ps.Add("WorkID", wfid);
DataTable dtNode = DBAccess.RunSQLReturnTable(ps);
dtNode.TableName = "Track";
myds.Tables.Add(dtNode);
//工作人员列表，用于审核组件.
ps = new Paras();
ps.SQL = "SELECT * FROM WF_GenerWorkerlist WHERE WorkID=" + BP.Sys.SystemConfig.AppCenterDBVarStr + "WorkID";
ps.Add("WorkID", wfid);
DataTable dtGenerWorkerlist = DBAccess.RunSQLReturnTable(ps);
dtGenerWorkerlist.TableName = "WF_GenerWorkerlist";
myds.Tables.Add(dtGenerWorkerlist);
//放入CCList信息. 用于审核组件.
ps = new Paras();
ps.SQL = "SELECT * FROM WF_CCList WHERE WorkID=" + BP.Sys.SystemConfig.AppCenterDBVarStr + "WorkID";
ps.Add("WorkID", wfid);
DataTable dtCCList = DBAccess.RunSQLReturnTable(ps);
dtCCList.TableName = "WF_CCList";
myds.Tables.Add(dtCCList);
//放入WF_SelectAccper信息. 用于审核组件.
ps = new Paras();
ps.SQL = "SELECT * FROM WF_SelectAccper WHERE WorkID=" + BP.Sys.SystemConfig.AppCenterDBVarStr + "WorkID";
ps.Add("WorkID", wfid);
DataTable dtSelectAccper = DBAccess.RunSQLReturnTable(ps);
dtSelectAccper.TableName = "WF_SelectAccper";
myds.Tables.Add(dtSelectAccper);
//放入所有的节点信息. 用于审核组件.
ps = new Paras();
ps.SQL = "SELECT * FROM WF_Node WHERE FK_Flow=" + BP.Sys.SystemConfig.AppCenterDBVarStr + "FK_Flow ORDER BY " + NodeAttr.Step;
ps.Add("FK_Flow", fk_flow);
DataTable dtNodes = DBAccess.RunSQLReturnTable(ps);
dtNodes.TableName = "Nodes";
myds.Tables.Add(dtNodes);
#endregion 把流程信息放入里面.
return(myds);
}
catch (Exception ex)
{
Log.DebugWriteError(ex.StackTrace);
throw new Exception(ex.Message);
}
}
/// <summary>
/// 获取从表数据，用于显示dtl.htm
/// </summary>
/// <param name="frmID">表单ID</param>
/// <param name="pkval">主键</param>
/// <param name="atParas">参数</param>
/// <param name="specDtlFrmID">指定明细表的参数，如果为空就标识主表数据，否则就是从表数据.</param>
/// <returns>数据</returns>
public static DataSet GenerDBForCCFormDtl(string frmID, MapDtl dtl, int pkval, string atParas)
{
//数据容器,就是要返回的对象.
DataSet myds = new DataSet();
//映射实体.
MapData md = new MapData(frmID);
//实体.
GEEntity wk = new GEEntity(frmID);
wk.OID = pkval;
if (wk.RetrieveFromDBSources() == 0)
{
wk.Insert();
}
//把参数放入到 En 的 Row 里面。
if (DataType.IsNullOrEmpty(atParas) == false)
{
AtPara ap = new AtPara(atParas);
foreach (string key in ap.HisHT.Keys)
{
try
{
if (wk.Row.ContainsKey(key) == true) //有就该变.
{
wk.Row[key] = ap.GetValStrByKey(key);
}
else
{
wk.Row.Add(key, ap.GetValStrByKey(key)); //增加他.
}
}
catch (Exception ex)
{
throw new Exception(key);
}
}
}
#region 加载从表表单模版信息.
DataTable Sys_MapDtl = dtl.ToDataTableField("Sys_MapDtl");
myds.Tables.Add(Sys_MapDtl);
//明细表的表单描述
DataTable Sys_MapAttr = dtl.MapAttrs.ToDataTableField("Sys_MapAttr");
myds.Tables.Add(Sys_MapAttr);
//明细表的配置信息.
DataTable Sys_MapExt = dtl.MapExts.ToDataTableField("Sys_MapExt");
myds.Tables.Add(Sys_MapExt);
#region 把从表的- 外键表/枚举 加入 DataSet.
MapExts mes = dtl.MapExts;
MapExt me = null;
foreach (DataRow dr in Sys_MapAttr.Rows)
{
string lgType = dr["LGType"].ToString();
//不是枚举/外键字段
if (lgType.Equals("0"))
{
continue;
}
string uiBindKey = dr["UIBindKey"].ToString();
var mypk = dr["MyPK"].ToString();
#region 枚举字段
if (lgType.Equals("1"))
{
// 如果是枚举值, 判断是否存在.
if (myds.Tables.Contains(uiBindKey) == true)
{
continue;
}
string mysql = "SELECT IntKey AS No, Lab as Name FROM Sys_Enum WHERE EnumKey='" + uiBindKey + "' ORDER BY IntKey ";
DataTable dtEnum = DBAccess.RunSQLReturnTable(mysql);
dtEnum.TableName = uiBindKey;
dtEnum.Columns[0].ColumnName = "No";
dtEnum.Columns[1].ColumnName = "Name";
myds.Tables.Add(dtEnum);
continue;
}
#endregion
#region 外键字段
string UIIsEnable = dr["UIIsEnable"].ToString();
if (UIIsEnable.Equals("0")) //字段未启用
{
continue;
}
// 检查是否有下拉框自动填充。
string keyOfEn = dr["KeyOfEn"].ToString();
#region 处理下拉框数据范围. for 小杨.
me = mes.GetEntityByKey(MapExtAttr.ExtType, MapExtXmlList.AutoFullDLL, MapExtAttr.AttrOfOper, keyOfEn) as MapExt;
if (me != null) //有范围限制时
{
string fullSQL = me.Doc.Clone() as string;
fullSQL = fullSQL.Replace("~", ",");
fullSQL = BP.WF.Glo.DealExp(fullSQL, wk, null);
DataTable dt = DBAccess.RunSQLReturnTable(fullSQL);
dt.TableName = uiBindKey;
dt.Columns[0].ColumnName = "No";
dt.Columns[1].ColumnName = "Name";
myds.Tables.Add(dt);
continue;
}
#endregion 处理下拉框数据范围.
// 判断是否存在.
if (myds.Tables.Contains(uiBindKey) == true)
{
continue;
}
myds.Tables.Add(BP.Sys.PubClass.GetDataTableByUIBineKey(uiBindKey));
#endregion 外键字段
}
#endregion 把从表的- 外键表/枚举 加入 DataSet.
#endregion 加载从表表单模版信息.
#region 把主表数据放入.
if (BP.Sys.SystemConfig.IsBSsystem == true)
{
// 处理传递过来的参数。
foreach (string k in System.Web.HttpContext.Current.Request.QueryString.AllKeys)
{
wk.SetValByKey(k, System.Web.HttpContext.Current.Request.QueryString[k]);
}
}
//重设默认值.
wk.ResetDefaultVal();
//增加主表数据.
DataTable mainTable = wk.ToDataTableField(md.No);
mainTable.TableName = "MainTable";
myds.Tables.Add(mainTable);
#endregion 把主表数据放入.
#region 把从表的数据放入.
GEDtls dtls = new GEDtls(dtl.No);
QueryObject qo = null;
try
{
qo = new QueryObject(dtls);
switch (dtl.DtlOpenType)
{
case DtlOpenType.ForEmp: // 按人员来控制.
qo.AddWhere(GEDtlAttr.RefPK, pkval);
qo.addAnd();
qo.AddWhere(GEDtlAttr.Rec, WebUser.No);
break;
case DtlOpenType.ForWorkID: // 按工作ID来控制
qo.AddWhere(GEDtlAttr.RefPK, pkval);
break;
case DtlOpenType.ForFID: // 按流程ID来控制.
qo.AddWhere(GEDtlAttr.FID, pkval);
break;
}
}
catch (Exception ex)
{
dtls.GetNewEntity.CheckPhysicsTable();
throw ex;
}
//条件过滤.
if (dtl.FilterSQLExp != "")
{
string[] strs = dtl.FilterSQLExp.Split('=');
qo.addAnd();
qo.AddWhere(strs[0], strs[1]);
}
//增加排序.
// qo.addOrderByDesc( dtls.GetNewEntity.PKField );
//从表
DataTable dtDtl = qo.DoQueryToTable();
//查询所有动态SQL查询类型的字典表记录
SFTable sftable = null;
DataTable dtsftable = null;
DataRow[] drs = null;
SFTables sftables = new SFTables();
sftables.Retrieve(SFTableAttr.SrcType, (int)SrcType.SQL);
// 为明细表设置默认值.
MapAttrs dtlAttrs = new MapAttrs(dtl.No);
foreach (MapAttr attr in dtlAttrs)
{
#region 修改区分大小写.
if (BP.DA.DBType.Oracle == SystemConfig.AppCenterDBType)
{
foreach (DataColumn dr in dtDtl.Columns)
{
var a = attr.KeyOfEn;
var b = dr.ColumnName;
if (attr.KeyOfEn.ToUpper().Equals(dr.ColumnName))
{
dr.ColumnName = attr.KeyOfEn;
continue;
}
if (attr.LGType == FieldTypeS.Enum || attr.LGType == FieldTypeS.FK)
{
if (dr.ColumnName.Equals(attr.KeyOfEn.ToUpper() + "TEXT"))
{
dr.ColumnName = attr.KeyOfEn + "Text";
}
}
}
foreach (DataRow dr in dtDtl.Rows)
{
//本身是大写的不进行修改
if (DataType.IsNullOrEmpty(dr[attr.KeyOfEn] + ""))
{
dr[attr.KeyOfEn] = dr[attr.KeyOfEn.ToUpper()];
dr[attr.KeyOfEn.ToUpper()] = null;
}
}
}
#endregion 修改区分大小写.
//处理增加动态SQL查询类型的下拉框选中值Text值，added by liuxc,2017-9-22
if (attr.LGType == FieldTypeS.FK && attr.UIIsEnable == false)
{
sftable = sftables.GetEntityByKey(attr.UIBindKey) as SFTable;
if (sftable != null)
{
dtsftable = sftable.GenerHisDataTable;
//为Text赋值
foreach (DataRow dr in dtDtl.Rows)
{
drs = dtsftable.Select("No='" + dr[attr.KeyOfEn] + "'");
if (drs.Length == 0)
{
continue;
}
dr[attr.KeyOfEn + "Text"] = drs[0]["Name"];
}
}
}
//处理它的默认值.
if (attr.DefValReal.Contains("@") == false)
{
continue;
}
foreach (DataRow dr in dtDtl.Rows)
{
dr[attr.KeyOfEn] = attr.DefVal;
}
}
dtDtl.TableName = "DBDtl"; //修改明细表的名称.
myds.Tables.Add(dtDtl); //加入这个明细表, 如果没有数据，xml体现为空.
#endregion 把从表的数据放入.
//放入一个空白的实体，用与获取默认值.
GEDtl dtlBlank = dtls.GetNewEntity as GEDtl;
dtlBlank.ResetDefaultVal();
myds.Tables.Add(dtlBlank.ToDataTableField("Blank"));
return(myds);
}
/// <summary>
/// 仅获取表单数据
/// </summary>
/// <param name="frmID">表单ID</param>
/// <param name="pkval">主键</param>
/// <param name="atParas">参数</param>
/// <param name="specDtlFrmID">指定明细表的参数，如果为空就标识主表数据，否则就是从表数据.</param>
/// <returns>数据</returns>
public static DataSet GenerDBForVSTOExcelFrmModel(string frmID, object pkval, string atParas, string specDtlFrmID = null)
{
//如果是一个实体类.
if (frmID.Contains("BP."))
{
// 执行map同步.
Entities ens = BP.En.ClassFactory.GetEns(frmID + "s");
Entity en = ens.GetNewEntity;
en.DTSMapToSys_MapData();
return(GenerDBForVSTOExcelFrmModelOfEntity(frmID, pkval, atParas, specDtlFrmID = null));
//上面这行代码的解释（2017-04-25）：
//若不加上这行，代码执行到“ MapData md = new MapData(frmID); ”会报错：
//@没有找到记录[表单注册表 Sys_MapData, [ 主键=No 值=BP.LI.BZQX ]记录不存在,请与管理员联系, 或者确认输入错误.@在Entity(BP.Sys.MapData)查询期间出现错误@ 在 BP.En.Entity.Retrieve() 位置 D:\ccflow\Components\BP.En30\En\Entity.cs:行号 1051
//即使加上：
//frmID = frmID.Substring(0, frmID.Length - 1);
//也会出现该问题
//2017-04-25 15:26:34：new MapData(frmID)应传入“BZQX”，但考虑到 GenerDBForVSTOExcelFrmModelOfEntity()运行稳定，暂不采用『统一执行下方代码』的方案。
}
//数据容器,就是要返回的对象.
DataSet myds = new DataSet();
//映射实体.
MapData md = new MapData(frmID);
//实体.
GEEntity wk = new GEEntity(frmID);
wk.OID = int.Parse(pkval.ToString());
if (wk.RetrieveFromDBSources() == 0)
{
wk.Insert();
}
//加载事件.
md.DoEvent(FrmEventList.FrmLoadBefore, wk, null);
//把参数放入到 En 的 Row 里面。
if (DataType.IsNullOrEmpty(atParas) == false)
{
AtPara ap = new AtPara(atParas);
foreach (string key in ap.HisHT.Keys)
{
if (wk.Row.ContainsKey(key) == true) //有就该变.
{
wk.Row[key] = ap.GetValStrByKey(key);
}
else
{
wk.Row.Add(key, ap.GetValStrByKey(key)); //增加他.
}
}
}
//属性.
MapExt me = null;
DataTable dtMapAttr = null;
MapExts mes = null;
#region 表单模版信息.（含主、从表的，以及从表的枚举/外键相关数据）.
//增加表单字段描述.
string sql = "SELECT * FROM Sys_MapData WHERE No='" + frmID + "' ";
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_MapData";
myds.Tables.Add(dt);
//增加表单字段描述.
sql = "SELECT * FROM Sys_MapAttr WHERE FK_MapData='" + frmID + "' ";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_MapAttr";
myds.Tables.Add(dt);
//增加从表信息.
sql = "SELECT * FROM Sys_MapDtl WHERE FK_MapData='" + frmID + "' ";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_MapDtl";
myds.Tables.Add(dt);
//主表的配置信息.
sql = "SELECT * FROM Sys_MapExt WHERE FK_MapData='" + frmID + "'";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_MapExt";
myds.Tables.Add(dt);
#region 加载 从表表单模版信息.（含 从表的枚举/外键相关数据）
foreach (MapDtl item in md.MapDtls)
{
#region 返回指定的明细表的数据.
if (DataType.IsNullOrEmpty(specDtlFrmID) == true)
{
}
else
{
if (item.No != specDtlFrmID)
{
continue;
}
}
#endregion 返回指定的明细表的数据.
//明细表的主表描述
sql = "SELECT * FROM Sys_MapDtl WHERE No='" + item.No + "'";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_MapDtl_For_" + (string.IsNullOrWhiteSpace(item.Alias) ? item.No : item.Alias);
myds.Tables.Add(dt);
//明细表的表单描述
sql = "SELECT * FROM Sys_MapAttr WHERE FK_MapData='" + item.No + "'";
dtMapAttr = BP.DA.DBAccess.RunSQLReturnTable(sql);
dtMapAttr.TableName = "Sys_MapAttr_For_" + (string.IsNullOrWhiteSpace(item.Alias) ? item.No : item.Alias);
myds.Tables.Add(dtMapAttr);
//明细表的配置信息.
sql = "SELECT * FROM Sys_MapExt WHERE FK_MapData='" + item.No + "'";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_MapExt_For_" + (string.IsNullOrWhiteSpace(item.Alias) ? item.No : item.Alias);
myds.Tables.Add(dt);
#region 从表的 外键表/枚举
mes = new MapExts(item.No);
foreach (DataRow dr in dtMapAttr.Rows)
{
string lgType = dr["LGType"].ToString();
//不是枚举/外键字段
if (lgType.Equals("0"))
{
continue;
}
string uiBindKey = dr["UIBindKey"].ToString();
var mypk = dr["MyPK"].ToString();
#region 枚举字段
if (lgType.Equals("1"))
{
// 如果是枚举值, 判断是否存在.
if (myds.Tables.Contains(uiBindKey) == true)
{
continue;
}
string mysql = "SELECT IntKey AS No, Lab as Name FROM Sys_Enum WHERE EnumKey='" + uiBindKey + "' ORDER BY IntKey ";
DataTable dtEnum = DBAccess.RunSQLReturnTable(mysql);
dtEnum.TableName = uiBindKey;
myds.Tables.Add(dtEnum);
continue;
}
#endregion
string UIIsEnable = dr["UIIsEnable"].ToString();
if (UIIsEnable.Equals("0")) //字段未启用
{
continue;
}
#region 外键字段
// 检查是否有下拉框自动填充。
string keyOfEn = dr["KeyOfEn"].ToString();
#region 处理下拉框数据范围. for 小杨.
me = mes.GetEntityByKey(MapExtAttr.ExtType, MapExtXmlList.AutoFullDLL, MapExtAttr.AttrOfOper, keyOfEn) as MapExt;
if (me != null) //有范围限制时
{
string fullSQL = me.Doc.Clone() as string;
fullSQL = fullSQL.Replace("~", ",");
fullSQL = BP.WF.Glo.DealExp(fullSQL, wk, null);
dt = DBAccess.RunSQLReturnTable(fullSQL);
dt.TableName = mypk;
myds.Tables.Add(dt);
continue;
}
#endregion 处理下拉框数据范围.
else //无范围限制时
{
// 判断是否存在.
if (myds.Tables.Contains(uiBindKey) == true)
{
continue;
}
myds.Tables.Add(BP.Sys.PubClass.GetDataTableByUIBineKey(uiBindKey));
}
#endregion 外键字段
}
#endregion 从表的 外键表/枚举
}
#endregion 加载 从表表单模版信息.（含 从表的枚举/外键相关数据）
#endregion 表单模版信息.（含主、从表的，以及从表的枚举/外键相关数据）.
#region 主表数据
if (BP.Sys.SystemConfig.IsBSsystem == true)
{
// 处理传递过来的参数。
foreach (string k in System.Web.HttpContext.Current.Request.QueryString.AllKeys)
{
wk.SetValByKey(k, System.Web.HttpContext.Current.Request.QueryString[k]);
}
}
// 执行表单事件..
string msg = md.DoEvent(FrmEventList.FrmLoadBefore, wk);
if (DataType.IsNullOrEmpty(msg) == false)
{
throw new Exception("err@错误:" + msg);
}
//重设默认值.
wk.ResetDefaultVal();
//执行装载填充.
me = new MapExt();
if (me.Retrieve(MapExtAttr.ExtType, MapExtXmlList.PageLoadFull, MapExtAttr.FK_MapData, frmID) == 1)
{
//执行通用的装载方法.
MapAttrs attrs = new MapAttrs(frmID);
MapDtls dtls = new MapDtls(frmID);
wk = BP.WF.Glo.DealPageLoadFull(wk, me, attrs, dtls) as GEEntity;
}
//增加主表数据.
DataTable mainTable = wk.ToDataTableField(md.No);
mainTable.TableName = "MainTable";
myds.Tables.Add(mainTable);
#endregion 主表数据
#region 从表数据
foreach (MapDtl dtl in md.MapDtls)
{
#region 返回指定的明细表的数据.
if (DataType.IsNullOrEmpty(specDtlFrmID) == true)
{
}
else
{
if (dtl.No != specDtlFrmID)
{
continue;
}
}
#endregion 返回指定的明细表的数据.
GEDtls dtls = new GEDtls(dtl.No);
QueryObject qo = null;
try
{
qo = new QueryObject(dtls);
switch (dtl.DtlOpenType)
{
case DtlOpenType.ForEmp: // 按人员来控制.
qo.AddWhere(GEDtlAttr.RefPK, pkval);
qo.addAnd();
qo.AddWhere(GEDtlAttr.Rec, WebUser.No);
break;
case DtlOpenType.ForWorkID: // 按工作ID来控制
qo.AddWhere(GEDtlAttr.RefPK, pkval);
break;
case DtlOpenType.ForFID: // 按流程ID来控制.
qo.AddWhere(GEDtlAttr.FID, pkval);
break;
}
}
catch
{
dtls.GetNewEntity.CheckPhysicsTable();
}
//条件过滤.
if (dtl.FilterSQLExp != "")
{
string[] strs = dtl.FilterSQLExp.Split('=');
qo.addAnd();
qo.AddWhere(strs[0], strs[1]);
}
//从表
DataTable dtDtl = qo.DoQueryToTable();
// 为明细表设置默认值.
MapAttrs dtlAttrs = new MapAttrs(dtl.No);
foreach (MapAttr attr in dtlAttrs)
{
//处理它的默认值.
if (attr.DefValReal.Contains("@") == false)
{
continue;
}
foreach (DataRow dr in dtDtl.Rows)
{
dr[attr.KeyOfEn] = attr.DefVal;
}
}
dtDtl.TableName = string.IsNullOrWhiteSpace(dtl.Alias) ? dtl.No : dtl.Alias; //edited by liuxc,2017-10-10.如果有别名，则使用别名，没有则使用No
myds.Tables.Add(dtDtl); //加入这个明细表, 如果没有数据，xml体现为空.
}
#endregion 从表数据
#region 主表的 外键表/枚举
dtMapAttr = myds.Tables["Sys_MapAttr"];
mes = md.MapExts;
foreach (DataRow dr in dtMapAttr.Rows)
{
string uiBindKey = dr["UIBindKey"].ToString();
string myPK = dr["MyPK"].ToString();
string lgType = dr["LGType"].ToString();
if (lgType.Equals("1"))
{
// 如果是枚举值, 判断是否存在.,
if (myds.Tables.Contains(uiBindKey) == true)
{
continue;
}
string mysql = "SELECT IntKey AS No, Lab as Name FROM Sys_Enum WHERE EnumKey='" + uiBindKey + "' ORDER BY IntKey ";
DataTable dtEnum = DBAccess.RunSQLReturnTable(mysql);
dtEnum.TableName = uiBindKey;
myds.Tables.Add(dtEnum);
continue;
}
if (lgType.Equals("2") == false)
{
continue;
}
string UIIsEnable = dr["UIIsEnable"].ToString();
if (UIIsEnable.Equals("0"))
{
continue;
}
// 检查是否有下拉框自动填充。
string keyOfEn = dr["KeyOfEn"].ToString();
string fk_mapData = dr["FK_MapData"].ToString();
#region 处理下拉框数据范围. for 小杨.
me = mes.GetEntityByKey(MapExtAttr.ExtType, MapExtXmlList.AutoFullDLL, MapExtAttr.AttrOfOper, keyOfEn) as MapExt;
if (me != null)
{
string fullSQL = me.Doc.Clone() as string;
fullSQL = fullSQL.Replace("~", ",");
fullSQL = BP.WF.Glo.DealExp(fullSQL, wk, null);
dt = DBAccess.RunSQLReturnTable(fullSQL);
dt.TableName = myPK; //可能存在隐患，如果多个字段，绑定同一个表，就存在这样的问题.
myds.Tables.Add(dt);
continue;
}
#endregion 处理下拉框数据范围.
dt = BP.Sys.PubClass.GetDataTableByUIBineKey(uiBindKey);
dt.TableName = uiBindKey;
myds.Tables.Add(dt);
}
#endregion 主表的 外键表/枚举
//返回生成的dataset.
return(myds);
}
/// <summary>
/// 保存从word中提取的数据
/// <param name="fk_mds">excel表单的编号</param>
/// </summary>
private void SaveFieldInfos(string[] fk_mds)
{
foreach (var fk_md in fk_mds)
{
var mes = new MapExts(fk_md);
if (mes.Count == 0)
{
return;
}
var item = mes.GetEntityByKey(MapExtAttr.ExtType, MapExtXmlList.PageLoadFull) as MapExt;
if (item == null)
{
return;
}
var fieldCount = 0;
var prefix = "field_" + fk_md;
foreach (var key in Request.Form.AllKeys)
{
var idx = 0;
if (key.StartsWith(prefix) && key.Length > prefix.Length && int.TryParse(key.Substring(prefix.Length), out idx))
{
fieldCount++;
}
}
var fieldsJson = string.Empty;
for (var i = 0; i < fieldCount; i++)
{
fieldsJson += Request[prefix + i];
}
//var fieldsJson = Request["field"];
var fields = LitJson.JsonMapper.ToObject <List <ReplaceField> >(HttpUtility.UrlDecode(fieldsJson));
//更新主表数据
var en = new GEEntityExcelFrm(fk_md);
var pk = en.OID = GetPK(fk_md);
if (en.RetrieveFromDBSources() == 0)
{
throw new Exception("OID=" + pk + "的数据在" + fk_md + "中不存在，请检查！");
}
//此处因为weboffice在上传的接口中，只有上传成功与失败的返回值，没有具体的返回信息参数，所以未做异常处理
foreach (var field in fields)
{
en.SetValByKey(field.key, field.value);
}
en.LastEditer = WebUser.Name;
en.RDT = DataType.CurrentDataTime;
en.Update();
//todo:更新明细表数据，此处逻辑可能还有待商榷
var mdtls = new MapDtls(fk_md);
if (mdtls.Count == 0)
{
return;
}
var dtlsCount = 0;
prefix = "dtls_" + fk_md;
foreach (var key in Request.Form.AllKeys)
{
var idx = 0;
if (key.StartsWith(prefix) && key.Length > prefix.Length && int.TryParse(key.Substring(prefix.Length), out idx))
{
dtlsCount++;
}
}
var dtlsJson = string.Empty;
for (var i = 0; i < dtlsCount; i++)
{
dtlsJson += Request[prefix + i];
}
//var dtlsJson = Request["dtls"];
var dtls = LitJson.JsonMapper.ToObject <List <ReplaceDtlTable> >(HttpUtility.UrlDecode(dtlsJson));
GEDtls gedtls = null;
GEDtl gedtl = null;
ReplaceDtlTable wdtl = null;
foreach (MapDtl mdtl in mdtls)
{
wdtl = dtls.FirstOrDefault(o => o.dtlno == mdtl.No);
if (wdtl == null || wdtl.dtl.Count == 0)
{
continue;
}
//此处不是真正意义上的更新，因为不知道明细表的主键，只能将原明细表中的数据删除掉，然后再重新插入新的数据
gedtls = new GEDtls(mdtl.No);
gedtls.Delete(GEDtlAttr.RefPK, en.PKVal);
foreach (var d in wdtl.dtl)
{
gedtl = gedtls.GetNewEntity as GEDtl;
foreach (var cell in d.cells)
{
gedtl.SetValByKey(cell.key, cell.value);
}
gedtl.RefPK = en.PKVal.ToString();
gedtl.RDT = DataType.CurrentDataTime;
gedtl.Rec = WebUser.No;
gedtl.Insert();
}
}
}
}
void btn_Click(object sender, EventArgs e)
{
Button btn = sender as Button;
try
{
BP.Web.Controls.DDL DDL_ImpWay = (BP.Web.Controls.DDL) this.Pub1.FindControl("DDL_ImpWay");
System.Web.UI.WebControls.FileUpload fuit = (System.Web.UI.WebControls.FileUpload) this.Pub1.FindControl("fup");
if (DDL_ImpWay.SelectedIndex == 0)
{
this.Alert("请选择导入方式.");
return;
}
MapDtl dtl = new MapDtl(this.FK_MapDtl);
string file = this.Request.PhysicalApplicationPath + "\\Temp\\" + WebUser.No + ".xls";
fuit.SaveAs(file);
GEDtls dtls = new GEDtls(this.FK_MapDtl);
System.Data.DataTable dt = BP.DBLoad.GetTableByExt(file);
file = this.Request.PhysicalApplicationPath + "\\DataUser\\DtlTemplete\\" + this.FK_MapDtl + ".xls";
System.Data.DataTable dtTemplete = BP.DBLoad.GetTableByExt(file);
#region 检查两个文件是否一致。
foreach (DataColumn dc in dtTemplete.Columns)
{
bool isHave = false;
foreach (DataColumn mydc in dt.Columns)
{
if (dc.ColumnName == mydc.ColumnName)
{
isHave = true;
break;
}
}
if (isHave == false)
{
throw new Exception("@您导入的excel文件不符合系统要求的格式，请下载模版文件重新填入。");
}
}
#endregion 检查两个文件是否一致。
#region 生成要导入的属性.
BP.En.Attrs attrs = dtls.GetNewEntity.EnMap.Attrs;
BP.En.Attrs attrsExp = new BP.En.Attrs();
foreach (DataColumn dc in dtTemplete.Columns)
{
foreach (Attr attr in attrs)
{
if (attr.UIVisible == false)
{
continue;
}
if (attr.IsRefAttr)
{
continue;
}
if (attr.Desc == dc.ColumnName.Trim())
{
attrsExp.Add(attr);
break;
}
}
}
#endregion 生成要导入的属性.
#region 执行导入数据.
if (DDL_ImpWay.SelectedIndex == 1)
{
BP.DA.DBAccess.RunSQL("DELETE " + dtl.PTable + " WHERE RefPK='" + this.WorkID + "'");
}
int i = 0;
Int64 oid = BP.DA.DBAccess.GenerOID(this.FK_MapDtl, dt.Rows.Count);
string rdt = BP.DA.DataType.CurrentData;
foreach (DataRow dr in dt.Rows)
{
GEDtl dtlEn = dtls.GetNewEntity as GEDtl;
dtlEn.ResetDefaultVal();
foreach (BP.En.Attr attr in attrsExp)
{
if (attr.UIVisible == false || dr[attr.Desc] == DBNull.Value)
{
continue;
}
string val = dr[attr.Desc].ToString();
if (val == null)
{
continue;
}
val = val.Trim();
switch (attr.MyFieldType)
{
case FieldType.Enum:
case FieldType.PKEnum:
SysEnums ses = new SysEnums(attr.UIBindKey);
foreach (SysEnum se in ses)
{
if (val == se.Lab)
{
val = se.IntKey.ToString();
break;
}
}
break;
case FieldType.FK:
case FieldType.PKFK:
break;
default:
break;
}
dtlEn.SetValByKey(attr.Key, val);
}
dtlEn.RefPKInt = (int)this.WorkID;
dtlEn.SetValByKey("RDT", rdt);
dtlEn.SetValByKey("Rec", WebUser.No);
i++;
dtlEn.InsertAsOID(oid);
oid++;
}
#endregion 执行导入数据.
this.Alert("共有(" + i + ")条数据导入成功。");
}
catch (Exception ex)
{
string msg = ex.Message.Replace("'", "‘");
this.Alert(msg);
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region 载入相关文件.
this.Page.RegisterClientScriptBlock("sguw",
"<link href='./Style/Frm/Tab.css' rel='stylesheet' type='text/css' />");
this.Page.RegisterClientScriptBlock("s2g4uh",
"<script language='JavaScript' src='./Style/Frm/jquery.min.js' ></script>");
this.Page.RegisterClientScriptBlock("sdfuy24j",
"<script language='JavaScript' src='./Style/Frm/jquery.idTabs.min.js' ></script>");
#endregion 载入相关文件.
#region 查询出来从表.
MapDtl mdtl = new MapDtl(this.EnsName);
GEDtls dtls = new GEDtls(this.EnsName);
QueryObject qo = null;
try
{
qo = new QueryObject(dtls);
switch (mdtl.DtlOpenType)
{
case DtlOpenType.ForEmp:
qo.AddWhere(GEDtlAttr.RefPK, this.RefPKVal);
break;
case DtlOpenType.ForWorkID:
qo.AddWhere(GEDtlAttr.RefPK, this.RefPKVal);
break;
case DtlOpenType.ForFID:
qo.AddWhere(GEDtlAttr.FID, this.RefPKVal);
break;
}
qo.DoQuery();
}
catch (Exception ex)
{
dtls.GetNewEntity.CheckPhysicsTable();
throw ex;
//#region 解决Access 不刷新的问题。
//string rowUrl = this.Request.RawUrl;
//if (rowUrl.IndexOf("rowUrl") > 1)
//{
// throw ex;
//}
//else
//{
// //this.Response.Redirect(rowUrl + "&rowUrl=1&IsWap=" + this.IsWap, true);
// return;
//}
//#endregion
}
#endregion 查询出来从表.
#region 初始化空白行
if (this.IsReadonly == false)
{
mdtl.RowsOfList = mdtl.RowsOfList + this.addRowNum;
int num = dtls.Count;
if (mdtl.IsInsert)
{
int dtlCount = dtls.Count;
for (int i = 0; i < mdtl.RowsOfList - dtlCount; i++)
{
BP.Sys.GEDtl dt = new GEDtl(this.EnsName);
dt.ResetDefaultVal();
dt.OID = i;
dtls.AddEntity(dt);
}
if (num == mdtl.RowsOfList)
{
BP.Sys.GEDtl dt1 = new GEDtl(this.EnsName);
dt1.ResetDefaultVal();
dt1.OID = mdtl.RowsOfList + 1;
dtls.AddEntity(dt1);
}
}
}
#endregion 初始化空白行
MapData md = new MapData(mdtl.No);
this.UCEn1.Clear();
this.UCEn1.Add("\t\n<div class=\"easyui-tabs\" fit=\"true\" border=\"false\" style='width:" + md.FrmW + "px;height:" + md.FrmH + "px;' data-options=\"tools:'#tab-tools'\">"); //begain.
#region 输出标签.
int idx = 0;
int dtlsNum = dtls.Count;
foreach (GEDtl dtl in dtls)
{
idx++;
this.UCEn1.Add("\t\n<div id=" + idx + " title='第" + idx + "条' style='overflow: auto;'>");
string src = "";
src = "FrmDtl.aspx?FK_MapData=" + this.EnsName + "&WorkID=" + this.RefPKVal + "&OID=" + dtl.OID + "&IsReadonly=" + this.IsReadonly;
this.UCEn1.Add("\t\n<iframe id='IF" + idx + "' Onblur=\"SaveDtlData('" + idx + "');\" frameborder='0' style='width:" + md.FrmW + "px;height:" + md.FrmH + "px;' src=\"" + src + "\"></iframe>");
this.UCEn1.Add("\t\n</div>");
}
this.UCEn1.Add("\t\n </div>");
if (this.IsReadonly == false && mdtl.IsInsert)
{
int addNum = addRowNum + 1;
int cutNum = addRowNum - 1;
this.UCEn1.Add("\t\n<div id=\"tab-tools\">");
if (cutNum >= 0)
{
this.UCEn1.Add("\t\n<a href='DtlCard.aspx?EnsName=" + this.EnsName + "&RefPKVal=" + this.RefPKVal + "&addRowNum=" + cutNum + "' class=\"easyui-linkbutton\" data-options=\"plain:true,iconCls:'icon-reload'\">移除</a>");
this.UCEn1.Add("\t\n<a href='DtlCard.aspx?EnsName=" + this.EnsName + "&RefPKVal=" + this.RefPKVal + "&addRowNum=" + addNum + "' class=\"easyui-linkbutton\" data-options=\"plain:true,iconCls:'icon-reload'\">插入</a>");
}
else
{
this.UCEn1.Add("\t\n<a href='DtlCard.aspx?EnsName=" + this.EnsName + "&RefPKVal=" + this.RefPKVal + "&addRowNum=" + addNum + "' >插入</a>");
}
this.UCEn1.Add("\t\n</div>");
}
#endregion 输出标签.
if (this.IsReadonly == false)
{
}
#region 处理iFrom SaveDtlData。
//string js = "";
//js = "\t\n<script type='text/javascript' >";
//js += "\t\n function SaveDtl(dtl) { ";
//js += "\t\n document.getElementById('F' + dtl ).contentWindow.SaveDtlData();";
//js += "\t\n } ";
//js += "\t\n</script>";
//this.UCEn1.Add(js);
#endregion 处理iFrom SaveDtlData。
}
public void LoadFrmData(MapAttrs mattrs, Entity en)
{
var mes = new MapExts(this.FK_MapData);
var dictParams = new ReplaceFieldList();
var fields = new List <string>();
dictParams.Add("No", WebUser.No, "string");
dictParams.Add("Name", WebUser.Name, "string");
dictParams.Add("FK_Dept", WebUser.FK_Dept, "string");
dictParams.Add("FK_DeptName", WebUser.FK_DeptName, "string");
if (mes.Count == 0)
{
ReplaceParams = GenerateParamsJsonString(dictParams);
ReplaceFields = "[]";
ReplaceDtlNos = "[]";
ReplaceDtls = "[]";
return;
}
MapExt item = mes.GetEntityByKey(MapExtAttr.ExtType, MapExtXmlList.PageLoadFull) as MapExt;
if (item == null)
{
ReplaceParams = GenerateParamsJsonString(dictParams);
ReplaceFields = "[]";
ReplaceDtlNos = "[]";
ReplaceDtls = "[]";
return;
}
DataTable dt = null;
MapAttr mattr = null;
string sql = item.Tag;
if (string.IsNullOrEmpty(sql) == false)
{
/* 如果有填充主表的sql */
#region 处理sql变量
sql = sql.Replace("@WebUser.No", WebUser.No);
sql = sql.Replace("@WebUser.Name", WebUser.Name);
sql = sql.Replace("@WebUser.FK_Dept", WebUser.FK_Dept);
sql = sql.Replace("@WebUser.FK_DeptName", WebUser.FK_DeptName);
foreach (MapAttr attr in mattrs)
{
if (sql.Contains("@"))
{
sql = sql.Replace("@" + attr.KeyOfEn, en.GetValStrByKey(attr.KeyOfEn));
}
else
{
break;
}
}
#endregion 处理sql变量
if (string.IsNullOrEmpty(sql) == false)
{
if (sql.Contains("@"))
{
throw new Exception("设置的sql有错误可能有没有替换的变量:" + sql);
}
dt = DBAccess.RunSQLReturnTable(sql);
if (dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
foreach (DataColumn dc in dt.Columns)
{
en.SetValByKey(dc.ColumnName, dr[dc.ColumnName].ToString());
mattr = mattrs.GetEntityByKey(MapAttrAttr.KeyOfEn, dc.ColumnName) as MapAttr;
dictParams.Add(dc.ColumnName, dr[dc.ColumnName].ToString(), mattr != null && mattr.IsSigan ? "sign" : "string");
fields.Add(dc.ColumnName);
}
}
}
}
if (IsFirst)
{
ReplaceParams = GenerateParamsJsonString(dictParams);
}
else
{
ReplaceParams = "[]";
}
ReplaceFields = GenerateFieldsJsonString(fields);
if (string.IsNullOrEmpty(item.Tag1) ||
item.Tag1.Length < 15)
{
ReplaceDtls = "[]";
ReplaceDtlNos = "[]";
return;
}
ReplaceDtls = "[";
ReplaceDtlNos = "[";
MapDtls dtls = new MapDtls(this.FK_MapData);
// 填充从表.
foreach (MapDtl dtl in dtls)
{
ReplaceDtlNos += "\"" + dtl.No + "\",";
if (!IsFirst)
{
continue;
}
string[] sqls = item.Tag1.Split('*');
foreach (string mysql in sqls)
{
if (string.IsNullOrEmpty(mysql))
{
continue;
}
if (mysql.Contains(dtl.No + "=") == false)
{
continue;
}
#region 处理sql.
sql = mysql;
sql = sql.Replace(dtl.No + "=", "");
sql = sql.Replace("@WebUser.No", WebUser.No);
sql = sql.Replace("@WebUser.Name", WebUser.Name);
sql = sql.Replace("@WebUser.FK_Dept", WebUser.FK_Dept);
sql = sql.Replace("@WebUser.FK_DeptName", WebUser.FK_DeptName);
foreach (MapAttr attr in mattrs)
{
if (sql.Contains("@"))
{
sql = sql.Replace("@" + attr.KeyOfEn, en.GetValStrByKey(attr.KeyOfEn));
}
else
{
break;
}
}
#endregion 处理sql.
if (string.IsNullOrEmpty(sql))
{
continue;
}
if (sql.Contains("@"))
{
throw new Exception("设置的sql有错误可能有没有替换的变量:" + sql);
}
GEDtls gedtls = new GEDtls(dtl.No);
try
{
gedtls.Delete(GEDtlAttr.RefPK, en.PKVal);
}
catch
{
gedtls.GetNewEntity.CheckPhysicsTable();
}
dt = DBAccess.RunSQLReturnTable(sql);
//dictDtls.Add(dtl.No, dt);
ReplaceDtls += "{\"dtlno\":\"" + dtl.No + "\",\"dtl\":[";
var idx = 1;
foreach (DataRow dr in dt.Rows)
{
ReplaceDtls += "{\"rowid\":" + (idx++) + ",\"cells\":[";
GEDtl gedtl = gedtls.GetNewEntity as GEDtl;
foreach (DataColumn dc in dt.Columns)
{
gedtl.SetValByKey(dc.ColumnName, dr[dc.ColumnName].ToString());
mattr = dtl.MapAttrs.GetEntityByKey(MapAttrAttr.KeyOfEn, dc.ColumnName) as MapAttr;
ReplaceDtls += "{\"key\":\"" + dc.ColumnName + "\",\"value\":\"" + dr[dc.ColumnName] + "\",\"type\":\"" + (mattr != null && mattr.IsSigan ? "sign" : "string") + "\"},";
}
ReplaceDtls = ReplaceDtls.TrimEnd(',') + "]},";
gedtl.RefPK = en.PKVal.ToString();
gedtl.RDT = DataType.CurrentDataTime;
gedtl.Rec = WebUser.No;
gedtl.Insert();
}
ReplaceDtls = ReplaceDtls.TrimEnd(',') + "]}";
}
}
ReplaceDtls = ReplaceDtls.TrimEnd(',') + "]";
ReplaceDtlNos = ReplaceDtlNos.TrimEnd(',') + "]";
}
public void PrintBill()
{
BP.WF.Node nd = new BP.WF.Node(this.FK_Node);
string path = ApplicationPath + "\\DataUser\\CyclostyleFile\\FlowFrm\\" + nd.FK_Flow + "\\" + nd.NodeID + "\\";
if (System.IO.Directory.Exists(path) == false)
{
this.Pub1.AddMsgOfWarning("获取模版错误", "模版文件没有找到。" + path);
return;
}
string[] fls = System.IO.Directory.GetFiles(path);
string file = fls[int.Parse(this.BillIdx)];
file = file.Replace(ApplicationPath + @"DataUser\CyclostyleFile", "");
FileInfo finfo = new FileInfo(file);
string tempName = finfo.Name.Split('.')[0];
string tempNameChinese = finfo.Name.Split('.')[1];
string toPath = ApplicationPath + @"DataUser\Bill\FlowFrm\" + DateTime.Now.ToString("yyyyMMdd") + "\\";
if (System.IO.Directory.Exists(toPath) == false)
{
System.IO.Directory.CreateDirectory(toPath);
}
// string billFile = toPath + "\\" + tempName + "." + this.FID + ".doc";
string billFile = toPath + "\\" + Server.UrlDecode(tempNameChinese) + "." + this.WorkID + ".doc";
BP.Pub.RTFEngine engine = new BP.Pub.RTFEngine();
if (tempName.ToLower() == "all")
{
/* 说明要从所有的流程表单上取数据.*/
FrmNodes fns = new FrmNodes(this.FK_Flow, this.FK_Node);
foreach (FrmNode fn in fns)
{
GEEntity ge = new GEEntity(fn.FK_Frm, this.WorkID);
engine.AddEn(ge);
MapDtls mdtls = new MapDtls(fn.FK_Frm);
foreach (MapDtl dtl in mdtls)
{
GEDtls enDtls = dtl.HisGEDtl.GetNewEntities as GEDtls;
enDtls.Retrieve(GEDtlAttr.RefPK, this.WorkID);
engine.EnsDataDtls.Add(enDtls);
}
}
// 增加主表.
GEEntity myge = new GEEntity("ND" + nd.NodeID, this.WorkID);
engine.AddEn(myge);
MapDtls mymdtls = new MapDtls("ND" + nd.NodeID);
foreach (MapDtl dtl in mymdtls)
{
GEDtls enDtls = dtl.HisGEDtl.GetNewEntities as GEDtls;
enDtls.Retrieve(GEDtlAttr.RefPK, this.WorkID);
engine.EnsDataDtls.Add(enDtls);
}
// engine.MakeDoc(file, toPath, tempName + "." + this.WorkID + ".doc", null, false);
engine.MakeDoc(file, toPath, Server.UrlDecode(tempNameChinese) + "." + this.WorkID + ".doc", null, false);
}
else
{
// 增加主表.
GEEntity myge = new GEEntity(tempName, this.WorkID);
engine.HisGEEntity = myge;
engine.AddEn(myge);
MapDtls mymdtls = new MapDtls(tempName);
foreach (MapDtl dtl in mymdtls)
{
GEDtls enDtls = dtl.HisGEDtl.GetNewEntities as GEDtls;
enDtls.Retrieve(GEDtlAttr.RefPK, this.WorkID);
engine.EnsDataDtls.Add(enDtls);
}
//engine.MakeDoc(file, toPath, tempName + "." + this.FID + ".doc", null, false);
engine.MakeDoc(file, toPath, Server.UrlDecode(tempNameChinese) + "." + this.WorkID + ".doc", null, false);
}
#region 保存单据，以方便查询.
Bill bill = new Bill();
bill.MyPK = this.FID + "_" + this.WorkID + "_" + this.FK_Node + "_" + this.BillIdx;
bill.WorkID = this.WorkID;
bill.FK_Node = this.FK_Node;
bill.FK_Dept = WebUser.FK_Dept;
bill.FK_Emp = WebUser.No;
bill.Url = "/DataUser/Bill/FlowFrm/" + DateTime.Now.ToString("yyyyMMdd") + "/" + Server.UrlDecode(tempNameChinese) + "." + this.WorkID + ".doc";
bill.FullPath = toPath + file;
bill.RDT = DataType.CurrentDataTime;
bill.FK_NY = DataType.CurrentYearMonth;
bill.FK_Flow = this.FK_Flow;
if (this.WorkID != 0)
{
GenerWorkFlow gwf = new GenerWorkFlow();
gwf.WorkID = this.WorkID;
if (gwf.RetrieveFromDBSources() == 1)
{
bill.Emps = gwf.Emps;
bill.FK_Starter = gwf.Starter;
bill.StartDT = gwf.RDT;
bill.Title = gwf.Title;
bill.FK_Dept = gwf.FK_Dept;
}
}
try
{
bill.Insert();
}
catch
{
bill.Update();
}
#endregion
BP.Sys.PubClass.OpenWordDocV2(billFile, tempNameChinese + ".doc");
}
private string GetDataByType(string fk_flow, string fk_node, string workID, string getType)
{
FrmNodes fns = new FrmNodes(fk_flow, int.Parse(fk_node));
string result = "{";
if (getType != "MainPage")
{
foreach (FrmNode fn in fns)
{
MapDtls mdtls = new MapDtls(fn.FK_Frm);
foreach (MapDtl dtl in mdtls)
{
if (dtl.PTable.Equals(getType))
{
GEDtls ens = new GEDtls(dtl.No);
ens.Retrieve(GEDtlAttr.RefPK, workID);
result += "\"" + dtl.PTable + "\":" +
JsonConvert.SerializeObject(ens.ToDataTableField()) + "}";
break;
}
}
}
}
else
{
foreach (FrmNode fn in fns)
{
GEEntity ge = new GEEntity(fn.FK_Frm, workID);
string tempJson = JsonConvert.SerializeObject(ge.Row);
tempJson = tempJson.TrimStart('{');
tempJson = tempJson.TrimEnd('}');
result += tempJson + ",";
}
result = result.TrimEnd(',') + "}";
}
//foreach (FrmNode fn in fns)
//{
// if (fn.FK_Frm == name)
// {
// GEEntity ge = new GEEntity(fn.FK_Frm, workID);
// if (getType == "MainPage")
// {
// result = JsonConvert.SerializeObject(ge.Row);
// }
// else
// {
// result = JsonConvert.SerializeObject(ge.Row);
// result = result.Substring(0, result.Length - 1);
// MapDtls mdtls = new MapDtls(fn.FK_Frm);
// foreach (MapDtl dtl in mdtls)
// {
// if (dtl.PTable.Equals(getType))
// {
// GEDtls ens = new GEDtls(dtl.No);
// ens.Retrieve(GEDtlAttr.RefPK, workID);
// result += ",\"" + dtl.PTable + "\":" +
// JsonConvert.SerializeObject(ens.ToDataTableField()) + "}";
// break;
// }
// }
// }
// break;
// }
//}
return(result);
}
public string GenerSum(MapAttr mattr, GEDtls dtls)
{
return("");
}
void btn_Click(object sender, EventArgs e)
{
Button btn = sender as Button;
try
{
BP.Web.Controls.DDL DDL_ImpWay = (BP.Web.Controls.DDL) this.Pub1.FindControl("DDL_ImpWay");
System.Web.UI.WebControls.FileUpload fuit = (System.Web.UI.WebControls.FileUpload) this.Pub1.FindControl("fup");
if (DDL_ImpWay.SelectedIndex == 0)
{
this.Alert("请选择导入方式.");
return;
}
string tempPath = this.Request.PhysicalApplicationPath + "\\Temp\\";
if (System.IO.Directory.Exists(tempPath) == false)
{
System.IO.Directory.CreateDirectory(tempPath);
}
MapDtl dtl = new MapDtl(this.FK_MapDtl);
//求出扩展名.
string fileName = fuit.FileName.ToLower();
if (fileName.Contains(".xls") == false)
{
this.Alert("上传的文件必须是excel文件.");
return;
}
string ext = ".xls";
if (fileName.Contains(".xlsx"))
{
ext = ".xlsx";
}
//保存临时文件.
string file = tempPath + WebUser.No + ext;
fuit.SaveAs(file);
GEDtls dtls = new GEDtls(this.FK_MapDtl);
System.Data.DataTable dt = BP.DA.DBLoad.GetTableByExt(file);
file = this.Request.PhysicalApplicationPath + "\\DataUser\\DtlTemplete\\" + this.FK_MapDtl + ext;
if (System.IO.File.Exists(file) == false)
{
if (ext == ".xlsx")
{
file = this.Request.PhysicalApplicationPath + "\\DataUser\\DtlTemplete\\" + this.FK_MapDtl + ".xls";
}
else
{
file = this.Request.PhysicalApplicationPath + "\\DataUser\\DtlTemplete\\" + this.FK_MapDtl + ".xls";
}
}
System.Data.DataTable dtTemplete = BP.DA.DBLoad.GetTableByExt(file);
#region 检查两个文件是否一致。
foreach (DataColumn dc in dtTemplete.Columns)
{
bool isHave = false;
foreach (DataColumn mydc in dt.Columns)
{
if (dc.ColumnName == mydc.ColumnName)
{
isHave = true;
break;
}
}
if (isHave == false)
{
throw new Exception("@您导入的excel文件不符合系统要求的格式，请下载模版文件重新填入。");
}
}
#endregion 检查两个文件是否一致。
#region 生成要导入的属性.
BP.En.Attrs attrs = dtls.GetNewEntity.EnMap.Attrs;
BP.En.Attrs attrsExp = new BP.En.Attrs();
foreach (DataColumn dc in dtTemplete.Columns)
{
foreach (Attr attr in attrs)
{
if (attr.UIVisible == false)
{
continue;
}
if (attr.IsRefAttr)
{
continue;
}
if (attr.Desc == dc.ColumnName.Trim())
{
attrsExp.Add(attr);
break;
}
}
}
#endregion 生成要导入的属性.
#region 执行导入数据.
if (DDL_ImpWay.SelectedIndex == 1)
{
BP.DA.DBAccess.RunSQL("DELETE FROM " + dtl.PTable + " WHERE RefPK='" + this.WorkID + "'");
}
int i = 0;
Int64 oid = BP.DA.DBAccess.GenerOID("Dtl", dt.Rows.Count);
string rdt = BP.DA.DataType.CurrentData;
string errMsg = "";
foreach (DataRow dr in dt.Rows)
{
GEDtl dtlEn = dtls.GetNewEntity as GEDtl;
dtlEn.ResetDefaultVal();
foreach (BP.En.Attr attr in attrsExp)
{
if (attr.UIVisible == false || dr[attr.Desc] == DBNull.Value)
{
continue;
}
string val = dr[attr.Desc].ToString();
if (val == null)
{
continue;
}
val = val.Trim();
switch (attr.MyFieldType)
{
case FieldType.Enum:
case FieldType.PKEnum:
SysEnums ses = new SysEnums(attr.UIBindKey);
bool isHavel = false;
foreach (SysEnum se in ses)
{
if (val == se.Lab)
{
val = se.IntKey.ToString();
isHavel = true;
break;
}
}
if (isHavel == false)
{
errMsg += "@数据格式不规范,第(" + i + ")行，列(" + attr.Desc + ")，数据(" + val + ")不符合格式,改值没有在枚举列表里.";
val = attr.DefaultVal.ToString();
}
break;
case FieldType.FK:
case FieldType.PKFK:
Entities ens = null;
if (attr.UIBindKey.Contains("."))
{
ens = BP.En.ClassFactory.GetEns(attr.UIBindKey);
}
else
{
ens = new GENoNames(attr.UIBindKey, "desc");
}
ens.RetrieveAll();
bool isHavelIt = false;
foreach (Entity en in ens)
{
if (val == en.GetValStrByKey("Name"))
{
val = en.GetValStrByKey("No");
isHavelIt = true;
break;
}
}
if (isHavelIt == false)
{
errMsg += "@数据格式不规范,第(" + i + ")行，列(" + attr.Desc + ")，数据(" + val + ")不符合格式,改值没有在外键数据列表里.";
}
break;
default:
break;
}
if (attr.MyDataType == BP.DA.DataType.AppBoolean)
{
if (val.Trim() == "是" || val.Trim().ToLower() == "yes")
{
val = "1";
}
if (val.Trim() == "否" || val.Trim().ToLower() == "no")
{
val = "0";
}
}
dtlEn.SetValByKey(attr.Key, val);
}
dtlEn.RefPKInt = (int)this.WorkID;
dtlEn.SetValByKey("RDT", rdt);
dtlEn.SetValByKey("Rec", WebUser.No);
i++;
dtlEn.InsertAsOID(oid);
oid++;
}
#endregion 执行导入数据.
if (string.IsNullOrEmpty(errMsg) == true)
{
this.Alert("共有(" + i + ")条数据导入成功。");
}
else
{
this.Alert("共有(" + i + ")条数据导入成功，但是出现如下错误:" + errMsg);
}
}
catch (Exception ex)
{
string msg = ex.Message.Replace("'", "‘");
this.Alert(msg);
}
}
public string GenerWorkNode(string fk_flow, int fk_node, Int64 workID, Int64 fid, string userNo)
{
try
{
Emp emp = new Emp(userNo);
BP.Web.WebUser.SignInOfGener(emp);
MapData md = new MapData();
md.No = "ND" + fk_node;
if (md.RetrieveFromDBSources() == 0)
{
throw new Exception("装载错误，该表单ID=" + md.No + "丢失，请修复一次流程重新加载一次.");
}
DataSet myds = md.GenerHisDataSet();
// 节点数据.
Node nd = new Node(fk_node);
myds.Tables.Add(nd.ToDataTableField("WF_Node"));
//节点标签数据.
BtnLab btnLab = new BtnLab(fk_node);
myds.Tables.Add(btnLab.ToDataTableField("WF_BtnLab"));
// 流程数据.
Flow fl = new Flow(fk_flow);
myds.Tables.Add(fl.ToDataTableField("WF_Flow"));
//.工作数据放里面去, 放进去前执行一次装载前填充事件.
BP.WF.Work wk = nd.HisWork;
wk.OID = workID;
wk.RetrieveFromDBSources();
wk.ResetDefaultVal();
// 执行一次装载前填充.
string msg = md.FrmEvents.DoEventNode(FrmEventList.FrmLoadBefore, wk);
if (string.IsNullOrEmpty(msg) == false)
{
return(msg);
}
myds.Tables.Add(wk.ToDataTableField("Main"));
#region 获取明细表数据，并把它加入dataset里.
if (md.MapDtls.Count > 0)
{
foreach (MapDtl dtl in md.MapDtls)
{
GEDtls dtls = new GEDtls(dtl.No);
QueryObject qo = null;
try
{
qo = new QueryObject(dtl);
switch (dtl.DtlOpenType)
{
case DtlOpenType.ForEmp: // 按人员来控制.
qo.AddWhere(GEDtlAttr.RefPK, workID);
qo.addAnd();
qo.AddWhere(GEDtlAttr.Rec, WebUser.No);
break;
case DtlOpenType.ForWorkID: // 按工作ID来控制
qo.AddWhere(GEDtlAttr.RefPK, workID);
break;
case DtlOpenType.ForFID: // 按流程ID来控制.
qo.AddWhere(GEDtlAttr.FID, workID);
break;
}
}
catch
{
dtls.GetNewEntity.CheckPhysicsTable();
}
DataTable dtDtl = qo.DoQueryToTable();
dtDtl.TableName = dtl.No; //修改明细表的名称.
myds.Tables.Add(dtDtl); //加入这个明细表.
}
}
#endregion
//把流程信息表发送过去.
GenerWorkFlow gwf = new GenerWorkFlow();
gwf.WorkID = workID;
myds.Tables.Add(gwf.ToDataTableField("WF_GenerWorkFlow"));
if (gwf.WFState == WFState.Forward)
{
//如果是转发.
BP.WF.ForwardWorks fws = new ForwardWorks();
fws.Retrieve(ForwardWorkAttr.WorkID, workID, ForwardWorkAttr.FK_Node, fk_node);
myds.Tables.Add(fws.ToDataTableField("WF_ForwardWork"));
}
if (gwf.WFState == WFState.ReturnSta)
{
//如果是退回.
ReturnWorks rts = new ReturnWorks();
rts.Retrieve(ReturnWorkAttr.WorkID, workID, ReturnWorkAttr.ReturnToNode, fk_node);
myds.Tables.Add(rts.ToDataTableField("WF_ForwardWork"));
}
if (gwf.WFState == WFState.HungUp)
{
//如果是挂起.
HungUps hups = new HungUps();
hups.Retrieve(HungUpAttr.WorkID, workID, HungUpAttr.FK_Node, fk_node);
myds.Tables.Add(hups.ToDataTableField("WF_HungUp"));
}
//放入track信息.
Paras ps = new Paras();
ps.SQL = "SELECT * FROM ND" + int.Parse(fk_flow) + "Track WHERE WorkID=" + BP.SystemConfig.AppCenterDBVarStr + "WorkID";
ps.Add("WorkID", workID);
DataTable dt = DBAccess.RunSQLReturnTable(ps);
dt.TableName = "Track";
myds.Tables.Add(dt);
//写入数据.
myds.WriteXml("c:\\sss.xml");
//转化成它所能识别的格式.
return(Silverlight.DataSetConnector.Connector.ToXml(myds));
}
catch (Exception ex)
{
Log.DebugWriteError(ex.StackTrace);
return("@生成工作FK_Flow=" + fk_flow + ",FK_Node=" + fk_node + ",WorkID=" + workID + ",FID=" + fid + "错误,错误信息:" + ex.Message);
}
}
//保存从表数据
public string Dtl_SaveRow()
{
#region 查询出来从表数据.
GEDtls dtls = new GEDtls(this.EnsName);
GEDtl dtl = dtls.GetNewEntity as GEDtl;
dtls.Retrieve("RefPK", this.GetRequestVal("RefPKVal"));
Map map = dtl.EnMap;
foreach (Entity item in dtls)
{
string pkval = item.GetValStringByKey(dtl.PK);
foreach (Attr attr in map.Attrs)
{
if (attr.IsRefAttr == true)
{
continue;
}
if (attr.MyDataType == DataType.AppDateTime || attr.MyDataType == DataType.AppDate)
{
if (attr.UIIsReadonly == true)
{
continue;
}
string val = this.GetValFromFrmByKey("TB_" + attr.Key + "_" + pkval, null);
item.SetValByKey(attr.Key, val);
continue;
}
if (attr.UIContralType == UIContralType.TB && attr.UIIsReadonly == false)
{
string val = this.GetValFromFrmByKey("TB_" + attr.Key + "_" + pkval, null);
item.SetValByKey(attr.Key, val);
continue;
}
if (attr.UIContralType == UIContralType.DDL && attr.UIIsReadonly == true)
{
string val = this.GetValFromFrmByKey("DDL_" + attr.Key + "_" + pkval);
item.SetValByKey(attr.Key, val);
continue;
}
if (attr.UIContralType == UIContralType.CheckBok && attr.UIIsReadonly == true)
{
string val = this.GetValFromFrmByKey("CB_" + attr.Key + "_" + pkval, "-1");
if (val == "-1")
{
item.SetValByKey(attr.Key, 0);
}
else
{
item.SetValByKey(attr.Key, 1);
}
continue;
}
}
item.Update(); //执行更新.
}
#endregion 查询出来从表数据.
#region 保存新加行.
string keyVal = "";
foreach (Attr attr in map.Attrs)
{
if (attr.MyDataType == DataType.AppDateTime || attr.MyDataType == DataType.AppDate)
{
if (attr.UIIsReadonly == true)
{
continue;
}
keyVal = this.GetValFromFrmByKey("TB_" + attr.Key + "_0", null);
dtl.SetValByKey(attr.Key, keyVal);
continue;
}
if (attr.UIContralType == UIContralType.TB && attr.UIIsReadonly == false)
{
keyVal = this.GetValFromFrmByKey("TB_" + attr.Key + "_0");
if (attr.IsNum && keyVal == "")
{
keyVal = "0";
}
dtl.SetValByKey(attr.Key, keyVal);
continue;
}
if (attr.UIContralType == UIContralType.DDL && attr.UIIsReadonly == true)
{
keyVal = this.GetValFromFrmByKey("DDL_" + attr.Key + "_0");
dtl.SetValByKey(attr.Key, keyVal);
continue;
}
if (attr.UIContralType == UIContralType.CheckBok && attr.UIIsReadonly == true)
{
keyVal = this.GetValFromFrmByKey("CB_" + attr.Key + "_0", "-1");
if (keyVal == "-1")
{
dtl.SetValByKey(attr.Key, 0);
}
else
{
dtl.SetValByKey(attr.Key, 1);
}
continue;
}
}
dtl.SetValByKey("RefPK", this.GetRequestVal("RefPKVal"));
dtl.PKVal = "0";
dtl.Insert();
#endregion 保存新加行.
return("保存成功.");
}
