protected override bool beforeUpdate()
{
MapDtl dtl = new MapDtl(this.No);
//启用审核
dtl.IsEnablePass = this.IsEnablePass;
//超链接
dtl.IsEnableLink = this.IsEnableLink;
dtl.LinkLabel = this.LinkLabel;
dtl.LinkUrl = this.LinkUrl;
dtl.LinkTarget = this.LinkTarget;
dtl.Update();
//获得事件实体.
var febd = BP.Sys.Glo.GetFormDtlEventBaseByEnName(this.No);
if (febd == null)
{
this.FEBD = "";
}
else
{
this.FEBD = febd.ToString();
}
#region 检查填充的SQL是否符合要求.
#endregion
//更新分组标签. @fanleiwei. 代码有变化.
BP.Sys.GroupField gf = new GroupField();
int i = gf.Retrieve(GroupFieldAttr.CtrlType, "Dtl", GroupFieldAttr.CtrlID, this.No);
if (i == 0)
{
gf.CtrlID = this.No;
gf.CtrlType = "Dtl";
gf.FrmID = this.FK_MapData;
gf.Insert();
}
if (i > 1)
{
gf.Delete();
i = gf.Retrieve(GroupFieldAttr.CtrlType, "Dtl", GroupFieldAttr.CtrlID, this.No);
}
if (i == 1 && gf.Lab.Equals(this.Name) == false)
{
gf.Lab = this.Name;
gf.Update();
}
return(base.beforeUpdate());
}
protected override bool beforeUpdateInsertAction()
{
if (this.FK_Node == 0)
{
//适应设计器新的规则 by dgq
if (!DataType.IsNullOrEmpty(this.NoOfObj) && this.NoOfObj.Contains(this.FK_MapData))
{
this.MyPK = this.NoOfObj;
}
else
{
this.MyPK = this.FK_MapData + "_" + this.NoOfObj;
}
}
else
{
this.MyPK = this.FK_MapData + "_" + this.NoOfObj + "_" + this.FK_Node;
}
#region 处理分组.
//更新相关的分组信息.
if (this.IsVisable == true)
{
GroupField gf = new GroupField();
int i = gf.Retrieve(GroupFieldAttr.FrmID, this.FK_MapData, GroupFieldAttr.CtrlID, this.MyPK);
if (i == 0)
{
gf.Lab = this.Name;
gf.FrmID = this.FK_MapData;
gf.CtrlType = "Ath";
//gf.CtrlID = this.MyPK;
gf.Insert();
}
else
{
gf.Lab = this.Name;
gf.FrmID = this.FK_MapData;
gf.CtrlType = "Ath";
//gf.CtrlID = this.MyPK;
gf.Update();
}
}
if (this.IsVisable == false)
{
GroupField gf = new GroupField();
gf.Delete(GroupFieldAttr.FrmID, this.FK_MapData, GroupFieldAttr.CtrlID, this.MyPK);
}
#endregion 处理分组.
return(base.beforeUpdateInsertAction());
}
protected override bool beforeUpdateInsertAction()
{
int val = this.GetValIntByKey(MapFrameAttr.UrlSrcType, 0);
if (val == 1)
{
string sql = "SELECT Url FROM Sys_MapData WHERE No='" + this.GetValStrByKey(MapFrameAttr.FrmID) + "'";
string url = DBAccess.RunSQLReturnStringIsNull(sql, "");
this.SetValByKey(MapFrameAttr.URL, url);
}
//更新group.
GroupField gf = new GroupField();
int i = gf.Retrieve(GroupFieldAttr.FrmID, this.FK_MapData, GroupFieldAttr.CtrlID, this.MyPK);
if (i == 1)
{
gf.Lab = this.Name;
gf.Update();
}
return(base.beforeUpdateInsertAction());
}
/// <summary>
/// 执行旧版本的兼容性检查.
/// </summary>
public string DoCheckFixFrmForUpdateVer()
{
// 更新状态.
DBAccess.RunSQL("UPDATE Sys_GroupField SET CtrlType='' WHERE CtrlType IS NULL");
DBAccess.RunSQL("UPDATE Sys_GroupField SET CtrlID='' WHERE CtrlID IS NULL");
DBAccess.RunSQL("UPDATE Sys_GroupField SET CtrlID='' WHERE CtrlID IS NULL");
//删除重影数据.
DBAccess.RunSQL("DELETE FROM Sys_GroupField WHERE CtrlType='FWC' and CTRLID is null");
//一直遇到遇到自动变长的问题, 强制其修复过来.
DBAccess.RunSQL("UPDATE Sys_Mapattr SET colspan=3 WHERE UIHeight<=38 AND colspan=4");
string str = "";
//处理失去分组的字段.
string sql = "SELECT MyPK FROM Sys_MapAttr WHERE FK_MapData='" + this.No + "' AND GroupID NOT IN (SELECT OID FROM Sys_GroupField WHERE FrmID='" + this.No + "' AND ( CtrlType='' OR CtrlType IS NULL) ) OR GroupID IS NULL ";
MapAttrs attrs = new MapAttrs();
attrs.RetrieveInSQL(sql);
if (attrs.Count != 0)
{
GroupField gf = null;
GroupFields gfs = new GroupFields(this.No);
foreach (GroupField mygf in gfs)
{
if (mygf.CtrlID == "")
{
gf = mygf;
}
}
if (gf == null)
{
gf = new GroupField();
gf.Lab = "基本信息";
gf.FrmID = this.No;
gf.Insert();
}
//设置GID.
foreach (MapAttr attr in attrs)
{
attr.Update(MapAttrAttr.GroupID, gf.OID);
}
}
//从表.
MapDtls dtls = new MapDtls(this.No);
foreach (MapDtl dtl in dtls)
{
GroupField gf = new GroupField();
int i = gf.Retrieve(GroupFieldAttr.CtrlID, dtl.No, GroupFieldAttr.FrmID, this.No);
if (i == 1)
{
continue;
}
//GroupField gf = new GroupField();
//if (gf.IsExit(GroupFieldAttr.CtrlID, dtl.No) == true && !DataType.IsNullOrEmpty(gf.CtrlType))
// continue;
gf.Lab = dtl.Name;
gf.CtrlID = dtl.No;
gf.CtrlType = "Dtl";
gf.FrmID = dtl.FK_MapData;
gf.DirectSave();
str += "@为从表" + dtl.Name + " 增加了分组.";
}
// 框架.
MapFrames frams = new MapFrames(this.No);
foreach (MapFrame fram in frams)
{
GroupField gf = new GroupField();
int i = gf.Retrieve(GroupFieldAttr.CtrlID, fram.MyPK, GroupFieldAttr.FrmID, this.No);
if (i == 1)
{
continue;
}
gf.Lab = fram.Name;
gf.CtrlID = fram.MyPK;
gf.CtrlType = "Frame";
gf.EnName = fram.FK_MapData;
gf.Insert();
str += "@为框架 " + fram.Name + " 增加了分组.";
}
// 附件.
FrmAttachments aths = new FrmAttachments(this.No);
foreach (FrmAttachment ath in aths)
{
if (ath.IsVisable == false)
{
continue;
}
GroupField gf = new GroupField();
int i = gf.Retrieve(GroupFieldAttr.CtrlID, ath.MyPK, GroupFieldAttr.FrmID, this.No);
if (i == 1)
{
continue;
}
gf.Lab = ath.Name;
gf.CtrlID = ath.MyPK;
gf.CtrlType = "Ath";
gf.FrmID = ath.FK_MapData;
gf.Insert();
str += "@为附件 " + ath.Name + " 增加了分组.";
}
if (this.IsNodeFrm == true)
{
FrmNodeComponent conn = new FrmNodeComponent(this.NodeID);
conn.Update();
}
//删除重复的数据, 比如一个从表显示了多个分组里. 增加此部分.
if (SystemConfig.AppCenterDBType == DBType.Oracle)
{
sql = "SELECT * FROM (SELECT FrmID,CtrlID,CtrlType, count(*) as Num FROM sys_groupfield WHERE CtrlID!='' GROUP BY FrmID,CtrlID,CtrlType ) WHERE Num > 1";
}
else
{
sql = "SELECT * FROM (SELECT FrmID,CtrlID,CtrlType, count(*) as Num FROM sys_groupfield WHERE CtrlID!='' GROUP BY FrmID,CtrlID,CtrlType ) AS A WHERE A.Num > 1";
}
DataTable dt = DBAccess.RunSQLReturnTable(sql);
foreach (DataRow dr in dt.Rows)
{
string enName = dr[0].ToString();
string ctrlID = dr[1].ToString();
string ctrlType = dr[2].ToString();
GroupFields gfs = new GroupFields();
gfs.Retrieve(GroupFieldAttr.FrmID, enName, GroupFieldAttr.CtrlID, ctrlID, GroupFieldAttr.CtrlType, ctrlType);
if (gfs.Count <= 1)
{
continue;
}
foreach (GroupField gf in gfs)
{
gf.Delete(); //删除其中的一个.
break;
}
}
if (str == "")
{
return("检查成功.");
}
return(str + ", @@@ 检查成功。");
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
switch (this.DoType)
{
case "DownTempFrm":
MapData md = new MapData(this.FK_MapData);
DataSet ds = md.GenerHisDataSet();
string name = "ccflow表单模板." + md.Name + "." + md.No + ".xml";
string file = this.Request.PhysicalApplicationPath + "\\Temp\\" + this.FK_MapData + ".xml";
ds.WriteXml(file);
this.Response.Redirect("../../Temp/" + this.FK_MapData + ".xml", true);
this.WinClose();
break;
case "CCForm":
this.Application.Clear();
if (WebUser.NoOfRel != "admin")
{
BP.Port.Emp emp = new BP.Port.Emp("admin");
BP.Web.WebUser.SignInOfGener(emp);
}
MapAttr mattr = new MapAttr();
mattr.MyPK = this.Request.QueryString["MyPK"];
int i = mattr.RetrieveFromDBSources();
mattr.KeyOfEn = this.Request.QueryString["KeyOfEn"];
mattr.FK_MapData = this.Request.QueryString["FK_MapData"];
mattr.MyDataType = int.Parse(this.Request.QueryString["DataType"]);
if (!string.IsNullOrEmpty(this.Request.QueryString["UIBindKey"] + ""))
{
mattr.UIBindKey = this.Request.QueryString["UIBindKey"];
}
mattr.UIContralType = (UIContralType)int.Parse(this.Request.QueryString["UIContralType"]);
mattr.LGType = (BP.En.FieldTypeS) int.Parse(this.Request.QueryString["LGType"]);
if (i == 0)
{
mattr.Name = System.Web.HttpUtility.UrlDecode(this.Request.QueryString["KeyName"], System.Text.Encoding.GetEncoding("GB2312"));
mattr.UIIsEnable = true;
mattr.UIVisible = true;
if (mattr.LGType == FieldTypeS.Enum)
{
mattr.DefVal = "0";
}
mattr.Insert();
}
else
{
mattr.Update();
}
switch (mattr.LGType)
{
case BP.En.FieldTypeS.Enum:
this.Response.Redirect("EditEnum.aspx?MyPK=" + mattr.FK_MapData + "&RefNo=" + mattr.MyPK, true);
return;
case BP.En.FieldTypeS.Normal:
this.Response.Redirect("EditF.aspx?DoType=Edit&MyPK=" + mattr.FK_MapData + "&RefNo=" + mattr.MyPK + "&FType=" + mattr.MyDataType + "&GroupField=0", true);
return;
case BP.En.FieldTypeS.FK:
this.Response.Redirect("EditTable.aspx?DoType=Edit&MyPK=" + mattr.FK_MapData + "&RefNo=" + mattr.MyPK + "&FType=" + mattr.MyDataType + "&GroupField=0", true);
return;
default:
break;
}
break;
case "DobackToF":
MapAttr ma = new MapAttr(this.RefNo);
switch (ma.LGType)
{
case FieldTypeS.Normal:
this.Response.Redirect("EditF.aspx?RefNo=" + this.RefNo, true);
return;
case FieldTypeS.FK:
this.Response.Redirect("EditTable.aspx?RefNo=" + this.RefNo, true);
return;
case FieldTypeS.Enum:
this.Response.Redirect("EditEnum.aspx?RefNo=" + this.RefNo, true);
return;
default:
return;
}
break;
case "AddEnum":
SysEnumMain sem1 = new SysEnumMain(this.Request.QueryString["EnumKey"]);
MapAttr attrAdd = new MapAttr();
attrAdd.KeyOfEn = sem1.No;
if (attrAdd.IsExit(MapAttrAttr.FK_MapData, this.MyPK, MapAttrAttr.KeyOfEn, sem1.No))
{
BP.Sys.PubClass.Alert("字段已经存在 [" + sem1.No + "]。");
BP.Sys.PubClass.WinClose();
return;
}
attrAdd.FK_MapData = this.MyPK;
attrAdd.Name = sem1.Name;
attrAdd.UIContralType = UIContralType.DDL;
attrAdd.UIBindKey = sem1.No;
attrAdd.MyDataType = BP.DA.DataType.AppInt;
attrAdd.LGType = FieldTypeS.Enum;
attrAdd.DefVal = "0";
attrAdd.UIIsEnable = true;
if (this.Idx == null || this.Idx == "")
{
MapAttrs attrs1 = new MapAttrs(this.MyPK);
attrAdd.Idx = 0;
}
else
{
attrAdd.Idx = int.Parse(this.Idx);
}
attrAdd.Insert();
this.Response.Redirect("EditEnum.aspx?MyPK=" + this.MyPK + "&RefNo=" + attrAdd.MyPK, true);
this.WinClose();
return;
case "DelEnum":
string eKey = this.Request.QueryString["EnumKey"];
SysEnumMain sem = new SysEnumMain();
sem.No = eKey;
sem.Delete();
this.WinClose();
return;
case "AddSysEnum":
this.AddFEnum();
break;
case "AddSFTable":
this.AddSFTable();
break;
case "AddSFTableAttr":
SFTable sf = new SFTable(this.Request.QueryString["RefNo"]);
this.Response.Redirect("EditTable.aspx?MyPK=" + this.MyPK + "&SFKey=" + sf.No, true);
this.WinClose();
return;
case "AddFG": /*执行一个插入列组的命令.*/
switch (this.RefNo)
{
case "IsPass":
MapDtl dtl = new MapDtl(this.FK_MapData);
dtl.IsEnablePass = true; /*更新是否启动审核分组字段.*/
MapAttr attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "Check_Note";
attr.Name = "审核意见";
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.DefVal = "同意";
attr.UIIsEnable = true;
attr.UIIsLine = true;
attr.MaxLen = 4000;
attr.ColSpan = 4; // 默认为4列。
attr.Idx = 1;
attr.Insert();
attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "Checker";
attr.Name = "审核人";// "审核人";
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.MaxLen = 50;
attr.MinLen = 0;
attr.UIIsEnable = true;
attr.UIIsLine = false;
attr.DefVal = "@WebUser.Name";
attr.UIIsEnable = false;
attr.IsSigan = true;
attr.Idx = 2;
attr.Insert();
attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "IsPass";
attr.Name = "通过否?";// "审核人";
attr.MyDataType = DataType.AppBoolean;
attr.UIContralType = UIContralType.CheckBok;
attr.UIIsEnable = true;
attr.UIIsLine = false;
attr.UIIsEnable = false;
attr.IsSigan = true;
attr.DefVal = "1";
attr.Idx = 2;
attr.DefVal = "0";
attr.Insert();
attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "Check_RDT";
attr.Name = "审核日期"; // "审核日期";
attr.MyDataType = DataType.AppDateTime;
attr.UIContralType = UIContralType.TB;
attr.UIIsEnable = true;
attr.UIIsLine = false;
attr.DefVal = "@RDT";
attr.UIIsEnable = false;
attr.Idx = 3;
attr.Insert();
/* 处理批次ID*/
attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "BatchID";
attr.Name = "BatchID"; // this.ToE("IsPass", "是否通过");// "审核人";
attr.MyDataType = DataType.AppInt;
attr.UIIsEnable = false;
attr.UIIsLine = false;
attr.UIIsEnable = false;
attr.UIVisible = false;
attr.Idx = 2;
attr.DefVal = "0";
attr.Insert();
dtl.Update();
this.WinClose();
return;
case "Eval": /* 质量评价 */
attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "EvalEmpNo";
attr.Name = "被评价人员编号";
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.MaxLen = 50;
attr.MinLen = 0;
attr.UIIsEnable = true;
attr.UIIsLine = false;
attr.UIIsEnable = false;
attr.IsSigan = true;
attr.Idx = 1;
attr.Insert();
attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "EvalEmpName";
attr.Name = "被评价人员名称";
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.MaxLen = 50;
attr.MinLen = 0;
attr.UIIsEnable = true;
attr.UIIsLine = false;
attr.UIIsEnable = false;
attr.IsSigan = true;
attr.Idx = 2;
attr.Insert();
attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "EvalCent";
attr.Name = "工作得分";
attr.MyDataType = DataType.AppFloat;
attr.UIContralType = UIContralType.TB;
attr.MaxLen = 50;
attr.MinLen = 0;
attr.UIIsEnable = true;
attr.UIIsLine = false;
attr.UIIsEnable = true;
attr.Idx = 3;
attr.Insert();
attr = new MapAttr();
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = "EvalNote";
attr.Name = "评价信息";
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.MaxLen = 50;
attr.MinLen = 0;
attr.UIIsEnable = true;
attr.UIIsEnable = true;
attr.Idx = 4;
attr.Insert();
this.WinClose();
return;
default:
break;
}
break;
case "AddFGroup":
this.AddFGroup();
return;
case "AddF":
case "ChoseFType":
this.AddF();
break;
case "Up":
MapAttr attrU = new MapAttr(this.RefNo);
if (this.Request.QueryString["IsDtl"] != null)
{
attrU.DoDtlUp();
}
else
{
attrU.DoUp();
}
this.WinClose();
break;
case "Down": //让一个字段下移动.
MapAttr attrD = new MapAttr(this.RefNo);
attrD.DoDown();
this.WinClose();
break;
case "DownAttr": //让一个字段下移动.
MapAttr attrAttr = new MapAttr(this.RefNo);
attrAttr.DoDtlDown();
this.WinClose();
break;
case "Jump":
MapAttr attrFrom = new MapAttr(this.Request.QueryString["FromID"]);
MapAttr attrTo = new MapAttr(this.Request.QueryString["ToID"]);
attrFrom.DoJump(attrTo);
this.WinClose();
break;
case "MoveTo":
string toID = this.Request.QueryString["ToID"];
int toGFID = int.Parse(this.Request.QueryString["ToGID"]);
int fromGID = int.Parse(this.Request.QueryString["FromGID"]);
string fromID = this.Request.QueryString["FromID"];
MapAttr fromAttr = new MapAttr();
fromAttr.MyPK = fromID;
fromAttr.Retrieve();
if (toGFID == fromAttr.GroupID && fromAttr.MyPK == toID)
{
/* 如果没有移动. */
this.WinClose();
return;
}
if (toGFID != fromAttr.GroupID && fromAttr.MyPK == toID)
{
MapAttr toAttr = new MapAttr(toID);
fromAttr.Update(MapAttrAttr.GroupID, toAttr.GroupID, MapAttrAttr.Idx, toAttr.Idx);
this.WinClose();
return;
}
this.Response.Redirect(this.Request.RawUrl.Replace("MoveTo", "Jump"), true);
return;
case "Edit":
Edit();
break;
case "Del":
MapAttr attrDel = new MapAttr();
attrDel.MyPK = this.RefNo;
attrDel.Delete();
this.WinClose();
break;
case "GFDoUp":
GroupField gf = new GroupField(this.RefOID);
gf.DoUp();
gf.Retrieve();
if (gf.Idx == 0)
{
this.WinClose();
return;
}
int oidIdx = gf.Idx;
gf.Idx = gf.Idx - 1;
GroupField gfUp = new GroupField();
if (gfUp.Retrieve(GroupFieldAttr.EnName, gf.EnName, GroupFieldAttr.Idx, gf.Idx) == 1)
{
gfUp.Idx = oidIdx;
gfUp.Update();
}
gf.Update();
this.WinClose();
break;
case "GFDoDown":
GroupField mygf = new GroupField(this.RefOID);
mygf.DoDown();
mygf.Retrieve();
int oidIdx1 = mygf.Idx;
mygf.Idx = mygf.Idx + 1;
GroupField gfDown = new GroupField();
if (gfDown.Retrieve(GroupFieldAttr.EnName, mygf.EnName, GroupFieldAttr.Idx, mygf.Idx) == 1)
{
gfDown.Idx = oidIdx1;
gfDown.Update();
}
mygf.Update();
this.WinClose();
break;
case "AthDoUp":
FrmAttachment frmAth = new FrmAttachment(this.MyPK);
if (frmAth.RowIdx > 0)
{
frmAth.RowIdx = frmAth.RowIdx - 1;
frmAth.Update();
}
this.WinClose();
break;
case "AthDoDown":
FrmAttachment frmAthD = new FrmAttachment(this.MyPK);
if (frmAthD.RowIdx < 10)
{
frmAthD.RowIdx = frmAthD.RowIdx + 1;
frmAthD.Update();
}
this.WinClose();
break;
case "DtlDoUp":
MapDtl dtl1 = new MapDtl(this.MyPK);
if (dtl1.RowIdx > 0)
{
dtl1.RowIdx = dtl1.RowIdx - 1;
dtl1.Update();
}
this.WinClose();
break;
case "DtlDoDown":
MapDtl dtl2 = new MapDtl(this.MyPK);
if (dtl2.RowIdx < 10)
{
dtl2.RowIdx = dtl2.RowIdx + 1;
dtl2.Update();
}
this.WinClose();
break;
case "M2MDoUp":
MapM2M ddtl1 = new MapM2M(this.MyPK);
if (ddtl1.RowIdx > 0)
{
ddtl1.RowIdx = ddtl1.RowIdx - 1;
ddtl1.Update();
}
this.WinClose();
break;
case "M2MDoDown":
MapM2M ddtl2 = new MapM2M(this.MyPK);
if (ddtl2.RowIdx < 10)
{
ddtl2.RowIdx = ddtl2.RowIdx + 1;
ddtl2.Update();
}
this.WinClose();
break;
case "FrameDoUp":
MapFrame frame1 = new MapFrame(this.MyPK);
if (frame1.RowIdx > 0)
{
frame1.RowIdx = frame1.RowIdx - 1;
frame1.Update();
}
this.WinClose();
break;
case "FrameDoDown":
MapFrame frame2 = new MapFrame(this.MyPK);
if (frame2.RowIdx < 10)
{
frame2.RowIdx = frame2.RowIdx + 1;
frame2.Update();
}
this.WinClose();
break;
default:
break;
}
}
catch (Exception ex)
{
this.Pub1.AddMsgOfWarning("错误:", ex.Message + " <br>" + this.Request.RawUrl);
}
}
