/// <summary>
/// 保存它
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btn_SavePageLoadFull_Click(object sender, EventArgs e)
{
MapExt me = new MapExt();
me.MyPK = this.FK_MapData + "_" + MapExtXmlList.PageLoadFull;
me.FK_MapData = this.FK_MapData;
me.ExtType = MapExtXmlList.PageLoadFull;
me.RetrieveFromDBSources();
me.Tag = this.Pub1.GetTextBoxByID("TB_" + MapExtAttr.Tag).Text;
string sql = "";
MapDtls dtls = new MapDtls(this.FK_MapData);
foreach (MapDtl dtl in dtls)
{
sql += "*" + dtl.No + "=" + this.Pub1.GetTextBoxByID("TB_" + dtl.No).Text;
}
me.Tag1 = sql;
me.MyPK = this.FK_MapData + "_" + MapExtXmlList.PageLoadFull;
string info = me.Tag1 + me.Tag;
if (string.IsNullOrEmpty(info))
{
me.Delete();
}
else
{
me.Save();
}
}
void btn_SaveAutoFull_Click(object sender, EventArgs e)
{
MapExt me = new MapExt();
//删除指定的数据,避免插入重复.
me.Delete(MapExtAttr.FK_MapData, this.FK_MapData, MapExtAttr.ExtType, this.ExtType, MapExtAttr.AttrOfOper, this.RefNo);
me.MyPK = this.MyPK;
if (me.MyPK.Length > 2)
{
me.RetrieveFromDBSources();
}
me = (MapExt)this.Pub1.Copy(me);
me.ExtType = this.ExtType;
me.Doc = this.Pub1.GetTextBoxByID("TB_Doc").Text;
me.AttrOfOper = this.RefNo;
me.FK_MapData = this.FK_MapData;
me.MyPK = this.FK_MapData + "_" + me.ExtType + "_" + me.AttrOfOper;
try
{
//DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(me.Doc);
//if (string.IsNullOrEmpty(me.Tag) == false)
//{
// dt = BP.DA.DBAccess.RunSQLReturnTable(me.Tag);
// if (dt.Columns.Contains("Name") == false || dt.Columns.Contains("No") == false)
// throw new Exception("在您的sql表达式里，必须有No,Name 还两个列。");
//}
//if (this.ExtType == MapExtXmlList.TBFullCtrl)
//{
// if (dt.Columns.Contains("Name") == false || dt.Columns.Contains("No") == false)
// throw new Exception("在您的sql表达式里，必须有No,Name 还两个列。");
//}
//MapAttrs attrs = new MapAttrs(this.FK_MapData);
//foreach (DataColumn dc in dt.Columns)
//{
// if (dc.ColumnName.ToLower() == "no" || dc.ColumnName.ToLower() == "name")
// continue;
// if (attrs.Contains(MapAttrAttr.KeyOfEn, dc.ColumnName) == false)
// throw new Exception("@系统没有找到您要匹配的列(" + dc.ColumnName + ")，注意:您要指定的列名区分大小写。");
//}
me.Save();
}
catch (Exception ex)
{
this.Pub1.AlertMsg_Warning("SQL错误", ex.Message);
return;
}
this.Response.Redirect("TBFullCtrl.aspx?FK_MapData=" + this.FK_MapData + "&RefNo=" + this.RefNo + "&MyPK=" + this.MyPK + "", true);
}
void btn_SaveJiLian_Click(object sender, EventArgs e)
{
MapExt me = new MapExt();
me.MyPK = this.MyPK;
if (me.MyPK.Length > 2)
{
me.RetrieveFromDBSources();
}
me = (MapExt)this.Pub1.Copy(me);
me.ExtType = this.ExtType;
me.Doc = this.Pub1.GetTextBoxByID("TB_Doc").Text;
me.AttrOfOper = this.RefNo;
me.AttrsOfActive = this.Pub1.GetDDLByID("DDL_Attr").SelectedItemStringVal;
if (me.AttrsOfActive == me.AttrOfOper)
{
this.Alert("两个项目不能相同.");
return;
}
try
{
if (this.Pub1.GetRadioButtonByID("RB_1").Checked)
{
me.DoWay = 1;
}
else
{
me.DoWay = 0;
}
}
catch
{
me.DoWay = 0;
}
me.FK_MapData = this.FK_MapData;
try
{
me.MyPK = this.FK_MapData + "_" + me.ExtType + "_" + me.AttrOfOper + "_" + me.AttrsOfActive;
if (me.Doc.Contains("No") == false || me.Doc.Contains("Name") == false)
{
throw new Exception("在您的SQL表达式里，必须有No,Name 还两个列，分别标识编码与名称。");
}
me.Save();
}
catch (Exception ex)
{
this.Alert(ex.Message);
return;
}
this.Response.Redirect("ActiveDDL.aspx?FK_MapData=" + this.FK_MapData + "&ExtType=" + this.ExtType + "&RefNo=" + this.RefNo + "&MyPK=" + me.MyPK, true);
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
MapExt me = new MapExt();
me.MyPK = this.FK_MapData + "_" + me.ExtType + "_" + me.AttrOfOper;
me.RetrieveFromDBSources();
me.ExtType = this.ExtType;
me.Doc = this.TB_SQL.Text;
me.AttrOfOper = this.RefNo;
me.FK_MapData = this.FK_MapData;
me.FK_DBSrc = this.DDL_DBSrc.SelectedValue;
me.Save();
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
MapAttr mattrNew = new MapAttr(this.RefNo);
MapExt me = new MapExt();
me.MyPK = this.RefNo + "_AutoFull";
me.RetrieveFromDBSources();
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = mattrNew.KeyOfEn;
me.ExtType = MapExtXmlList.AutoFull;
if (this.RB_0.Checked)
{
me.Tag = "0";
this.TB_Exp.Text = "";
me.Doc = "";
}
if (this.RB_1.Checked)
{
me.Tag = "1";
me.Doc = this.TB_Exp.Text;
/*检查字段是否填写正确.*/
MapAttrs attrsofCheck = new MapAttrs(this.FK_MapData);
string docC = me.Doc;
foreach (MapAttr attrC in attrsofCheck)
{
if (attrC.IsNum == false)
{
continue;
}
docC = docC.Replace("@" + attrC.KeyOfEn, "");
docC = docC.Replace("@" + attrC.Name, "");
}
if (docC.Contains("@"))
{
this.Alert("您填写的表达公式不正确，导致一些数值类型的字段没有被正确的替换。" + docC);
return;
}
}
me.Save();
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
MapExt me = new MapExt();
me.Retrieve(MapExtAttr.FK_MapData, this.FK_MapData, MapExtAttr.ExtType, this.ExtType, MapExtAttr.AttrOfOper, this.RefNo);
me.ExtType = this.ExtType;
me.Doc = this.TB_SQL.Text;
me.AttrOfOper = this.RefNo;
me.FK_MapData = this.FK_MapData;
me.MyPK = this.FK_MapData + "_" + me.ExtType + "_" + me.AttrOfOper;
switch (this.DDL_DBSrc.Text)
{
case "应用系统主数据库(默认)":
me.FK_DBSrc = "0";
break;
case "SQLServer数据库":
me.FK_DBSrc = "1";
break;
case "WebService数据源":
me.FK_DBSrc = "100";
break;
case "Oracle数据库":
me.FK_DBSrc = "2";
break;
case "MySQL数据库":
me.FK_DBSrc = "3";
break;
case "Informix数据库":
me.FK_DBSrc = "4";
break;
default:
break;
}
me.Save();
}
private void RegularExpression_Save_Tag(string tagID)
{
string val = this.GetValFromFrmByKey("TB_Doc_" + tagID);
if (DataType.IsNullOrEmpty(val))
{
return;
}
MapExt me = new MapExt();
me.MyPK = MapExtXmlList.TBFullCtrl + "_" + this.FK_MapData + "_" + this.KeyOfEn + "_" + tagID;
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = this.KeyOfEn;
me.ExtType = "RegularExpression";
me.Tag = tagID;
me.Doc = val;
me.Tag1 = this.GetValFromFrmByKey("TB_Tag1_" + tagID);
me.Save();
}
/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
public string ActiveDDL_Save()
{
MapExt me = new MapExt();
me.Delete(MapExtAttr.ExtType, MapExtXmlList.ActiveDDL,
MapExtAttr.FK_MapData, this.FK_MapData,
MapExtAttr.AttrOfOper, this.KeyOfEn);
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = this.KeyOfEn;
me.AttrsOfActive = this.GetValFromFrmByKey("DDL_AttrsOfActive");
me.FK_DBSrc = this.GetValFromFrmByKey("FK_DBSrc");
me.Doc = this.GetValFromFrmByKey("TB_Doc"); //要执行的SQL.
me.ExtType = MapExtXmlList.ActiveDDL;
//执行保存.
me.MyPK = MapExtXmlList.ActiveDDL + "_" + me.FK_MapData + "_" + me.AttrOfOper + "_" + me.AttrOfOper;
me.Save();
return("保存成功.");
}
/// <summary>
/// 保存设置.
/// </summary>
/// <returns></returns>
public string PopVal_Save()
{
try
{
MapExt me = new MapExt();
me.MyPK = this.FK_MapExt;
me.FK_MapData = this.FK_MapData;
me.ExtType = "PopVal";
me.AttrOfOper = this.KeyOfEn;
me.RetrieveFromDBSources();
string valWorkModel = this.GetValFromFrmByKey("Model");
switch (valWorkModel)
{
case "None":
me.PopValWorkModel = PopValWorkModel.None;
break;
case "SelfUrl": //URL模式.
me.PopValWorkModel = PopValWorkModel.SelfUrl;
me.PopValUrl = this.GetValFromFrmByKey("TB_Url");
break;
case "TableOnly": //表格模式.
me.PopValWorkModel = PopValWorkModel.TableOnly;
me.PopValEntitySQL = this.GetValFromFrmByKey("TB_Table_SQL");
break;
case "TablePage": //分页模式.
me.PopValWorkModel = PopValWorkModel.TablePage;
me.PopValTablePageSQL = this.GetValFromFrmByKey("TB_TablePage_SQL");
me.PopValTablePageSQLCount = this.GetValFromFrmByKey("TB_TablePage_SQLCount");
break;
case "Group": //分组模式.
me.PopValWorkModel = PopValWorkModel.Group;
me.PopValGroupSQL = this.GetValFromFrmByKey("TB_GroupModel_Group");
me.PopValEntitySQL = this.GetValFromFrmByKey("TB_GroupModel_Entity");
//me.PopValUrl = this.GetValFromFrmByKey("TB_Url");
break;
case "Tree": //单实体树.
me.PopValWorkModel = PopValWorkModel.Tree;
me.PopValTreeSQL = this.GetValFromFrmByKey("TB_TreeSQL");
me.PopValTreeParentNo = this.GetValFromFrmByKey("TB_TreeParentNo");
break;
case "TreeDouble": //双实体树.
me.PopValWorkModel = PopValWorkModel.TreeDouble;
me.PopValTreeSQL = this.GetValFromFrmByKey("TB_DoubleTreeSQL"); // 树SQL
me.PopValTreeParentNo = this.GetValFromFrmByKey("TB_DoubleTreeParentNo");
me.PopValDoubleTreeEntitySQL = this.GetValFromFrmByKey("TB_DoubleTreeEntitySQL"); //实体SQL
break;
default:
break;
}
//高级属性.
me.W = int.Parse(this.GetValFromFrmByKey("TB_Width"));
me.H = int.Parse(this.GetValFromFrmByKey("TB_Height"));
me.PopValColNames = this.GetValFromFrmByKey("TB_ColNames"); //中文列名的对应.
me.PopValTitle = this.GetValFromFrmByKey("TB_Title"); //标题.
me.PopValSearchTip = this.GetValFromFrmByKey("TB_PopValSearchTip"); //关键字提示.
me.PopValSearchCond = this.GetValFromFrmByKey("TB_PopValSearchCond"); //查询条件.
//数据返回格式.
string popValFormat = this.GetValFromFrmByKey("PopValFormat");
switch (popValFormat)
{
case "OnlyNo":
me.PopValFormat = PopValFormat.OnlyNo;
break;
case "OnlyName":
me.PopValFormat = PopValFormat.OnlyName;
break;
case "NoName":
me.PopValFormat = PopValFormat.NoName;
break;
default:
break;
}
//选择模式.
string seleModel = this.GetValFromFrmByKey("PopValSelectModel");
if (seleModel == "One")
{
me.PopValSelectModel = PopValSelectModel.One;
}
else
{
me.PopValSelectModel = PopValSelectModel.More;
}
me.Save();
return("保存成功.");
}
catch (Exception ex)
{
return("@保存失败:" + ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btn_Click(object sender, EventArgs e)
{
MapAttr mattrNew = new MapAttr(this.RefNo);
MapExt me = new MapExt();
me.MyPK = this.RefNo + "_AutoFull";
me.RetrieveFromDBSources();
me.FK_MapData = this.FK_MapData;
me.AttrOfOper = mattrNew.KeyOfEn;
me.ExtType = MapExtXmlList.AutoFull;
if (this.Pub1.GetRadioButtonByID("RB_Way_0").Checked)
{
me.Tag = "0";
}
// JS 方式。
if (this.Pub1.GetRadioButtonByID("RB_Way_1").Checked)
{
me.Tag = "1";
me.Doc = this.Pub1.GetTextBoxByID("TB_JS").Text;
/*检查字段是否填写正确.*/
MapAttrs attrsofCheck = new MapAttrs(this.FK_MapData);
string docC = me.Doc;
foreach (MapAttr attrC in attrsofCheck)
{
if (attrC.IsNum == false)
{
continue;
}
docC = docC.Replace("@" + attrC.KeyOfEn, "");
docC = docC.Replace("@" + attrC.Name, "");
}
if (docC.Contains("@"))
{
this.Alert("您填写的表达公式不正确，导致一些数值类型的字段没有被正确的替换。" + docC);
return;
}
}
// 外键方式。
if (this.Pub1.GetRadioButtonByID("RB_Way_2").Checked)
{
me.Tag = "2";
me.Doc = this.Pub1.GetTextBoxByID("TB_SQL").Text;
//mattr.HisAutoFull = AutoFullWay.Way2_SQL;
//mattr.AutoFullDoc = this.Pub1.GetTextBoxByID("TB_SQL").Text;
}
// 本表单中外键列。
string doc = "";
if (this.Pub1.GetRadioButtonByID("RB_Way_3").Checked)
{
me.Tag = "3";
// mattr.HisAutoFull = AutoFullWay.Way3_FK;
MapData md = new MapData(this.FK_MapData);
Attrs attrs = md.GenerHisMap().HisFKAttrs;
foreach (Attr attr in attrs)
{
if (attr.IsRefAttr)
{
continue;
}
if (this.Pub1.GetRadioButtonByID("RB_FK_" + attr.Key).Checked == false)
{
continue;
}
// doc = " SELECT " + this.Pub1.GetDDLByID("DDL_" + attr.Key).SelectedValue + " FROM " + attr.HisFKEn.EnMap.PhysicsTable + " WHERE NO=@" + attr.Key;
doc = "@AttrKey=" + attr.Key + "@Field=" + this.Pub1.GetDDLByID("DDL_" + attr.Key).SelectedValue + "@Table=" + attr.HisFKEn.EnMap.PhysicsTable;
}
me.Doc = doc;
}
// 本表单中从表列。
if (this.Pub1.GetRadioButtonByID("RB_Way_4").Checked)
{
me.Tag = "4";
MapDtls dtls = new MapDtls(this.FK_MapData);
// mattr.HisAutoFull = AutoFullWay.Way4_Dtl;
foreach (MapDtl dtl in dtls)
{
try
{
if (this.Pub1.GetRadioButtonByID("RB_" + dtl.No).Checked == false)
{
continue;
}
}
catch
{
continue;
}
// doc = "SELECT " + this.Pub1.GetDDLByID( "DDL_"+dtl.No + "_Way").SelectedValue + "(" + this.Pub1.GetDDLByID("DDL_"+dtl.No+"_F").SelectedValue + ") FROM " + dtl.No + " WHERE REFOID=@OID";
doc = "@Table=" + dtl.No + "@Field=" + this.Pub1.GetDDLByID("DDL_" + dtl.No + "_F").SelectedValue + "@Way=" + this.Pub1.GetDDLByID("DDL_" + dtl.No + "_Way").SelectedValue;
}
me.Doc = doc;
}
try
{
me.Save();
}
catch (Exception ex)
{
this.ResponseWriteRedMsg(ex);
return;
}
this.Alert("保存成功");
this.Pub1.Clear();
//Button btn = sender as Button;
var btn = sender as LinkBtn;
if (btn.ID.Contains("Close"))
{
this.WinClose();
return;
}
else
{
this.Response.Redirect(this.Request.RawUrl, true);
}
}
