protected void Btn_Save_Click(object sender, EventArgs e)
{
MapExt myme = new MapExt(this.MyPK);
MapDtls dtls = new MapDtls(myme.FK_MapData);
string info = "";
string error = "";
foreach (MapDtl dtl in dtls)
{
if (this.TB_SQL.Text.Trim() == "")
{
continue;
}
info += "$" + dtl.No + ":" + this.TB_SQL.Text;
}
if (error != "")
{
throw new Exception("设置错误，请更正:<br/>" + error + "");
}
myme.Tag1 = info;
myme.Update();
}
public string TBFullCtrlDtl_Save()
{
MapDtls dtls = new MapDtls(this.FK_MapData);
MapExt me = new MapExt(this.MyPK);
string str = "";
foreach (MapDtl dtl in dtls)
{
string sql = this.GetRequestVal("TB_" + dtl.No);
sql = sql.Trim();
if (sql == "" || sql == null)
{
continue;
}
if (sql.Contains("@Key") == false)
{
return("err@在配置从表:" + dtl.No + " sql填写错误, 必须包含@Key列, @Key就是当前文本框输入的值. ");
}
str += "$" + dtl.No + ":" + sql;
}
me.Tag1 = str;
me.Update();
return("保存成功.");
}
public string TBFullCtrlDDL_Save()
{
MapExt myme = new MapExt(this.MyPK);
MapAttrs attrs = new MapAttrs(myme.FK_MapData);
attrs.Retrieve(MapAttrAttr.FK_MapData, myme.FK_MapData,
MapAttrAttr.UIIsEnable, 1, MapAttrAttr.UIContralType, (int)UIContralType.DDL);
MapExt me = new MapExt(this.MyPK);
string str = "";
foreach (MapAttr attr in attrs)
{
string sql = this.GetRequestVal("TB_" + attr.KeyOfEn);
sql = sql.Trim();
if (sql == "" || sql == null)
{
continue;
}
if (sql.Contains("@Key") == false)
{
return("err@在配置从表:" + attr.KeyOfEn + " sql填写错误, 必须包含@Key列, @Key就是当前文本框输入的值. ");
}
str += "$" + attr.KeyOfEn + ":" + sql;
}
me.Tag = str;
me.Update();
return("保存成功.");
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
BP.Sys.MapExt me = new MapExt();
if (this.MyPK != null)
{
me.MyPK = this.MyPK;
me.RetrieveFromDBSources();
me.FK_MapData = this.FK_MapData;
me.Doc = this.Fields;
me.ExtType = "Sepc" + this.DoType + "SepcUsers";
me.Tag = this.FK_Node;
me.Tag1 = this.TB_Emps.Text;
me.Update();
}
else
{
me.MyPK = BP.DA.DBAccess.GenerGUID();
me.FK_MapData = this.FK_MapData;
me.Doc = this.Fields;
me.Tag = this.FK_Node;
me.Tag1 = this.TB_Emps.Text;
me.ExtType = "Sepc" + this.DoType + "SepcUsers";
me.Insert();
}
this.WinClose("设置成功.");
}
/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
public string TBFullCtrl_Save()
{
try
{
MapExt me = new MapExt();
int i = me.Retrieve(MapExtAttr.ExtType, MapExtXmlList.TBFullCtrl,
MapExtAttr.FK_MapData, this.FK_MapData,
MapExtAttr.AttrOfOper, this.KeyOfEn);
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = this.KeyOfEn;
me.FK_DBSrc = this.GetValFromFrmByKey("FK_DBSrc");
me.Doc = this.GetValFromFrmByKey("TB_Doc"); //要执行的SQL.
me.ExtType = MapExtXmlList.TBFullCtrl;
//执行保存.
me.InitPK();
if (me.Update() == 0)
{
me.Insert();
}
return("保存成功.");
}
catch (Exception ex)
{
return("err@" + ex.Message);
}
}
void mybtn_SaveAutoFullJilian_Click(object sender, EventArgs e)
{
var btn = sender as LinkBtn;
if (btn != null && btn.ID == NamesOfBtn.Cancel)
{
this.Response.Redirect("TBFullCtrl.aspx?FK_MapData=" + this.FK_MapData + "&ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&RefNo=" + this.RefNo, true);
return;
}
string mypk = this.ExtType + "_" + this.FK_MapData + "_" + this.RefNo;
MapExt myme = new MapExt(mypk);
MapAttrs attrs = new MapAttrs(myme.FK_MapData);
string info = "";
foreach (MapAttr attr in attrs)
{
if (attr.LGType == FieldTypeS.Normal)
{
continue;
}
if (attr.UIIsEnable == false)
{
continue;
}
TextBox tb = this.Pub1.GetTextBoxByID("TB_" + attr.KeyOfEn);
if (tb.Text.Trim() == "")
{
continue;
}
try
{
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(tb.Text);
if (tb.Text.Contains("@Key") == false)
{
throw new Exception("缺少@Key参数。");
}
if (dt.Columns.Contains("No") == false || dt.Columns.Contains("Name") == false)
{
throw new Exception("在您的sql表单公式中必须有No,Name两个列，来绑定下拉框。");
}
}
catch (Exception ex)
{
this.Alert("SQL ERROR: " + ex.Message);
return;
}
info += "$" + attr.KeyOfEn + ":" + tb.Text;
}
myme.Tag = info;
myme.Update();
this.Alert("保存成功.");
}
void mybtn_SaveAutoFullM2M_Click(object sender, EventArgs e)
{
//Button btn = sender as Button;
var btn = sender as LinkBtn;
if (btn.ID == NamesOfBtn.Cancel)
{
this.Response.Redirect("TBFullCtrl.aspx?FK_MapData=" + this.FK_MapData + "&ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&RefNo=" + this.RefNo, true);
return;
}
MapExt myme = new MapExt(this.MyPK);
MapM2Ms m2ms = new MapM2Ms(myme.FK_MapData);
string info = "";
string error = "";
foreach (MapM2M m2m in m2ms)
{
TextBox tb = this.Pub1.GetTextBoxByID("TB_" + m2m.NoOfObj);
if (tb.Text.Trim() == "")
{
continue;
}
try
{
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(tb.Text);
string err = "";
if (dt.Columns[0].ColumnName != "No")
{
err += "第1列不是No.";
}
if (dt.Columns[1].ColumnName != "Name")
{
err += "第2列不是Name.";
}
if (err != "")
{
error += "在为(" + m2m.Name + ")检查sql设置时出现错误：请确认列的顺序是否正确为大小写是否匹配。" + err;
}
}
catch (Exception ex)
{
this.Alert("SQL ERROR: " + ex.Message);
return;
}
info += "$" + m2m.NoOfObj + ":" + tb.Text;
}
if (error != "")
{
this.Pub1.AddEasyUiPanelInfo("错误", "设置错误,请更正:<br />" + error, "icon-no");
//this.Pub1.AddMsgOfWarning("设置错误,请更正:", error);
return;
}
myme.Tag2 = info;
myme.Update();
this.Response.Redirect("TBFullCtrl.aspx?FK_MapData=" + this.FK_MapData + "&ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&RefNo=" + this.RefNo, true);
}
void mybtn_SaveAutoFullDtl_Click(object sender, EventArgs e)
{
var btn = sender as LinkBtn;
if (btn.ID == NamesOfBtn.Cancel)
{
this.Response.Redirect("TBFullCtrl.aspx?FK_MapData=" + this.FK_MapData + "&ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&RefNo=" + this.RefNo, true);
return;
}
MapExt myme = new MapExt(this.MyPK);
MapDtls dtls = new MapDtls(myme.FK_MapData);
string info = "";
string error = "";
foreach (MapDtl dtl in dtls)
{
TextBox tb = this.Pub1.GetTextBoxByID("TB_" + dtl.No);
if (tb.Text.Trim() == "")
{
continue;
}
try
{
//DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(tb.Text);
//MapAttrs attrs = new MapAttrs(dtl.No);
//string err = "";
//foreach (DataColumn dc in dt.Columns)
//{
// if (attrs.IsExits(MapAttrAttr.KeyOfEn, dc.ColumnName) == false)
// {
// err += "<br>列" + dc.ColumnName + "不能与从表 属性匹配.";
// }
//}
//if (err != "")
//{
// error += "在为("+dtl.Name+")检查sql设置时出现错误:"+err;
//}
}
catch (Exception ex)
{
this.Alert("SQL ERROR: " + ex.Message);
return;
}
info += "$" + dtl.No + ":" + tb.Text;
}
if (error != "")
{
this.Pub1.AddEasyUiPanelInfo("错误", "设置错误,请更正:<br />" + error, "icon-no");
//this.Pub1.AddMsgOfWarning("设置错误,请更正:", error);
return;
}
myme.Tag1 = info;
myme.Update();
this.Response.Redirect("TBFullCtrl.aspx?FK_MapData=" + this.FK_MapData + "&ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&RefNo=" + this.RefNo, true);
}
protected void Btn_Delete_Click(object sender, EventArgs e)
{
MapExt me = new MapExt();
me.Retrieve(MapExtAttr.FK_MapData, this.FK_MapData, this.ExtType, this.ExtType, MapExtAttr.AttrOfOper, this.RefNo);
me.Doc = "";
me.Update();
BP.Sys.PubClass.WinClose();
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
MapExt myme = new MapExt(this.MyPK);
MapAttrs attrs = new MapAttrs(myme.FK_MapData);
string info = "";
foreach (MapAttr attr in attrs)
{
if (attr.LGType == FieldTypeS.Normal)
{
continue;
}
if (attr.UIIsEnable == false)
{
continue;
}
if (this.TB_SQL.Text.Trim() == "")
{
continue;
}
try
{
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(this.TB_SQL.Text);
if (this.TB_SQL.Text.Contains("@Key") == false)
{
throw new Exception("缺少@Key参数。");
}
if (dt.Columns.Contains("No") == false || dt.Columns.Contains("Name") == false)
{
throw new Exception("在您的sql表单公式中必须有No,Name两个列，来绑定下拉框。");
}
}
catch (Exception ex)
{
this.Alert("SQL ERROR: " + ex.Message);
return;
}
info += "$" + attr.KeyOfEn + ":" + this.TB_SQL.Text;
}
myme.Tag = info;
myme.Update();
this.Alert("保存成功.");
}
/// <summary>
/// 保存(自动计算: @单价*@数量 模式.)
/// </summary>
/// <returns></returns>
public string AutoFullDtlField_Save()
{
MapExt me = new MapExt();
int i = me.Retrieve(MapExtAttr.ExtType, MapExtXmlList.AutoFullDtlField,
MapExtAttr.FK_MapData, this.FK_MapData,
MapExtAttr.AttrOfOper, this.KeyOfEn);
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = this.KeyOfEn;
me.Doc = this.GetValFromFrmByKey("DDL_Dtl") + "." + this.GetValFromFrmByKey("DDL_Field") + "." + this.GetValFromFrmByKey("DDL_JSFS"); //要执行的表达式.
me.ExtType = MapExtXmlList.AutoFullDtlField;
//执行保存.
me.MyPK = MapExtXmlList.AutoFullDtlField + "_" + me.FK_MapData + "_" + me.AttrOfOper;
if (me.Update() == 0)
{
me.Insert();
}
return("保存成功.");
}
/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
public string AutoFullDLL_Save()
{
MapExt me = new MapExt();
int i = me.Retrieve(MapExtAttr.ExtType, MapExtXmlList.AutoFullDLL,
MapExtAttr.FK_MapData, this.FK_MapData,
MapExtAttr.AttrOfOper, this.KeyOfEn);
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = this.KeyOfEn;
me.FK_DBSrc = this.GetValFromFrmByKey("FK_DBSrc");
me.Doc = this.GetValFromFrmByKey("TB_Doc"); //要执行的SQL.
me.ExtType = MapExtXmlList.AutoFullDLL;
//执行保存.
me.InitPK();
if (me.Update() == 0)
{
me.Insert();
}
return("保存成功.");
}
public string Fields_Save()
{
Node currND = new Node(this.FK_Node);
string FieldsAttrsObj = this.GetRequestVal("FieldsAttrsObj");
var jsonSetting = new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
};
List <FieldsAttrs> fieldsAttrsList = JsonConvert.DeserializeObject <List <FieldsAttrs> >(FieldsAttrsObj, jsonSetting);
if (fieldsAttrsList == null)
{
return("0");
}
MapAttrs attrs = new MapAttrs();
//增加排序
QueryObject obj = new QueryObject(attrs);
obj.AddWhere(MapAttrAttr.FK_MapData, this.FK_MapData);
obj.DoQuery();
foreach (MapAttr attr in attrs)
{
foreach (FieldsAttrs fieldsAttrs in fieldsAttrsList)
{
if (!attr.KeyOfEn.Equals(fieldsAttrs.KeyOfEn))
{
continue;
}
if (currND.HisFormType == NodeFormType.RefOneFrmTree)
{
attr.UIVisible = fieldsAttrs.UIVisible;
attr.UIIsEnable = fieldsAttrs.UIIsEnable;
attr.IsSigan = fieldsAttrs.IsSigan;
attr.DefVal = fieldsAttrs.DefVal;
attr.UIIsInput = fieldsAttrs.IsNotNull;
attr.FK_MapData = this.FK_MapData;
attr.KeyOfEn = attr.KeyOfEn;
attr.Name = attr.Name;
attr.Update();
//如果是表单库表单，需要写入MapAttr
if (DataType.IsNullOrEmpty(fieldsAttrs.RegularExp) == false)
{
MapExt ext = new MapExt();
bool extisExit = ext.IsExit("MyPK", "RegularExpression_" + this.FK_MapData + "_" + fieldsAttrs.KeyOfEn + "_onchange");
ext.FK_MapData = this.FK_MapData;
ext.ExtType = MapExtXmlList.RegularExpression;
ext.DoWay = 0;
ext.AttrOfOper = fieldsAttrs.KeyOfEn;
ext.Doc = fieldsAttrs.RegularExp;
ext.Tag = "onchange";
ext.Tag1 = "格式不正确！";
if (extisExit)
{
ext.Update();
}
else
{
ext.MyPK = "RegularExpression_" + this.FK_MapData + "_" + fieldsAttrs.KeyOfEn + "_onchange";
ext.Insert();
}
}
}
FrmField frmField = new FrmField();
bool isExit = frmField.IsExit("MyPK",
this.FK_MapData + "_" + this.FK_Flow + "_" + this.FK_Node + "_" + fieldsAttrs.KeyOfEn + "_" + FrmEleType.Field);
frmField.UIVisible = fieldsAttrs.UIVisible;
frmField.UIIsEnable = fieldsAttrs.UIIsEnable;
frmField.IsSigan = fieldsAttrs.IsSigan;
frmField.DefVal = fieldsAttrs.DefVal;
frmField.IsNotNull = fieldsAttrs.IsNotNull;
frmField.RegularExp = fieldsAttrs.RegularExp;
frmField.IsWriteToFlowTable = fieldsAttrs.IsWriteToFlowTable;
//frmField.IsWriteToGenerWorkFlow = fieldsAttrs.IsWriteToGenerWorkFlow; //sln无此属性
frmField.FK_Node = this.FK_Node;
frmField.FK_Flow = this.FK_Flow;
frmField.FK_MapData = this.FK_MapData;
frmField.KeyOfEn = attr.KeyOfEn;
frmField.Name = attr.Name;
if (isExit)
{
frmField.Update();
}
else
{
frmField.Insert();
}
}
}
return(fieldsAttrsList.Count.ToString());
}
/// <summary>
/// 保存(自动计算: @单价*@数量 模式.)
/// </summary>
/// <returns></returns>
public string AutoFullDtlField_Save()
{
MapExt me = new MapExt();
int i = me.Retrieve(MapExtAttr.ExtType, MapExtXmlList.AutoFullDtlField,
MapExtAttr.FK_MapData, this.FK_MapData,
MapExtAttr.AttrOfOper, this.KeyOfEn);
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = this.KeyOfEn;
me.Doc = this.GetValFromFrmByKey("DDL_Dtl") + "." + this.GetValFromFrmByKey("DDL_Field") + "." + this.GetValFromFrmByKey("DDL_JSFS"); //要执行的表达式.
me.ExtType = MapExtXmlList.AutoFullDtlField;
me.Tag1 = this.GetValFromFrmByKey("TB_Tag1");
me.Tag2 = this.GetValFromFrmByKey("TB_Tag2");
string Tag = "0";
try
{
Tag = this.GetValFromFrmByKey("CB_Tag");
if (Tag == "on")
{
Tag = "1";
}
}
catch (Exception e)
{
Tag = "0";
}
me.Tag = Tag;
string Tag3 = "0";
try
{
Tag3 = this.GetValFromFrmByKey("CB_Tag3");
if (Tag3 == "on")
{
Tag3 = "1";
}
}
catch (Exception e)
{
Tag3 = "0";
}
me.Tag3 = Tag3;
me.Tag4 = this.GetValFromFrmByKey("DDL_Fileds");
//执行保存.
me.MyPK = MapExtXmlList.AutoFullDtlField + "_" + me.FK_MapData + "_" + me.AttrOfOper;
if (me.Update() == 0)
{
me.Insert();
}
return("保存成功.");
}
void btn_SaveInputCheck_Click(object sender, EventArgs e)
{
ListBox lb = this.Pub1.FindControl("LB1") as ListBox;
// 检查路径. 没有就创建它。
string pathDir = BP.Sys.SystemConfig.PathOfDataUser + "\\JSLibData\\";
if (Directory.Exists(pathDir) == false)
{
Directory.CreateDirectory(pathDir);
}
// 删除已经存在的数据.
MapExt me = new MapExt();
me.Retrieve(MapExtAttr.FK_MapData, this.FK_MapData,
MapExtAttr.ExtType, this.ExtType,
MapExtAttr.AttrOfOper, this.OperAttrKey);
foreach (ListItem li in lb.Items)
{
if (li.Selected == false)
{
continue;
}
me = (MapExt)this.Pub1.Copy(me);
me.ExtType = this.ExtType;
// 操作的属性.
me.AttrOfOper = this.OperAttrKey;
int doWay = 0;
if (this.Pub1.GetRadioButtonByID("RB_0").Checked == false)
{
doWay = 1;
}
me.DoWay = doWay;
me.Doc = BP.DA.DataType.ReadTextFile(li.Value);
FileInfo info = new FileInfo(li.Value);
me.Tag2 = info.Directory.Name;
//获取函数的名称.
string func = me.Doc;
func = me.Doc.Substring(func.IndexOf("function") + 8);
func = func.Substring(0, func.IndexOf("("));
me.Tag1 = func.Trim();
// 检查路径,没有就创建它.
FileInfo fi = new FileInfo(li.Value);
me.Tag = li.Value;
me.FK_MapData = this.FK_MapData;
me.ExtType = this.ExtType;
me.MyPK = this.FK_MapData + "_" + me.ExtType + "_" + me.AttrOfOper + "_" + me.Tag1;
try
{
me.Insert();
}
catch
{
me.Update();
}
}
#region 把所有的js 文件放在一个文件里面。
MapExts mes = new MapExts();
mes.Retrieve(MapExtAttr.FK_MapData, this.FK_MapData,
MapExtAttr.ExtType, this.ExtType);
string js = "";
foreach (MapExt me1 in mes)
{
js += "\r\n" + BP.DA.DataType.ReadTextFile(me1.Tag);
}
if (File.Exists(pathDir + "\\" + this.FK_MapData + ".js"))
{
File.Delete(pathDir + "\\" + this.FK_MapData + ".js");
}
BP.DA.DataType.WriteFile(pathDir + "\\" + this.FK_MapData + ".js", js);
#endregion 把所有的js 文件放在一个文件里面。
this.Response.Redirect("InputCheck.aspx?FK_MapData=" + this.FK_MapData + "&ExtType=" + this.ExtType + "&RefNo=" + this.RefNo, true);
}