protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_TABLE valObj = new TF_TABLE();
if (string.IsNullOrEmpty(keyid))
{
if (txtTB_NAME.Value != "")
{
valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value;
}
if (ViewState["OLDNAME"].ToString() != valObj.TB_NAME)
{
if (BLLTable <TF_TABLE> .Exists(valObj))
{
litWarn.Text = "该表已经存在，请重新输入！";
return;
}
}
if (txtTB_ID.Value != "")
{
valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
}
//if (txtM_TB_ID.Value != "")
valObj.M_TB_ID = pid;
if (txtTB_TYPE.Value != "")
{
valObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
}
}
else
{
valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value;
}
if (txtSORT_NO.Value != "")
{
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
}
//ADD START 插入条件缺少 jin-shenjian 2013/10/12
if (txtCH_NAME.Value != "")
{
valObj.CH_NAME = Convert.ToString(txtCH_NAME.Value);
}
//ADD END 插入条件缺少 jin-shenjian 2013/10/12
if (txtNOTE.Value != "")
{
valObj.NOTE = Convert.ToString(txtNOTE.Value);
}
if (keyid != "")
{
valObj.TB_ID = Convert.ToInt32(keyid);
count = BLLTable <TF_TABLE> .Factory(conn).Update(valObj, TF_TABLE.Attribute.TB_ID);
if (count > 0)
{
TF_TABLEHelper.Factory(conn).EditTable(ViewState["OLDNAME"].ToString(), valObj, ref errMsg);
}
}
else
{
int ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddTableWithDefaultCols(valObj, txtTB_NAME_Save.Value, GetConnByDevKey(txtDB_NAME_Save.Value), ref errMsg);
if (ret1 == 0)
{
litWarn.Text = errMsg;
Response.End(); return;
}
valObj.SOURCE_TABLE = txtTB_NAME_Save.Value;
valObj.SOURCE_DB = txtDB_NAME_Save.Value;
count = BLLTable <TF_TABLE> .Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
TF_TB_FIELD valField = new TF_TB_FIELD();
DataBaseTable tbsource = null;
string strRetMessage = "";
if (!string.IsNullOrEmpty(valObj.TB_NAME) && DataBase.Factory(conn).TryGetValue(valObj.TB_NAME, out tbsource))
{
int count1 = new TF_TABLEHelper(conn).SaveToTF_TB_FIELD(valObj.TB_NAME, valObj.TB_ID, ref strRetMessage);
if (count1 < 1)
{
}
}
}
if (count > 0)
{
string gotoUrl = WebHelper.GetAppPath() + @"ok.aspx";
if (Request["tree"] != null)
{
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.SORT_NO).Append(",sc:1,name:'");
if (valObj.M_TB_ID > 0)
{
sb.Append(valObj.CH_NAME).Append("',ntype:'TF_TABLE-mx'}");
}
else
{
sb.Append(valObj.CH_NAME).Append("',ntype:'TF_TABLE'}");
}
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK") != -1)
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtTB_NAME.Value = "";
txtCH_NAME.Value = "";
txtNOTE.Value = "";
}
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_TABLE valObj = new TF_TABLE();
//if(txtTB_ID.Value !="" )
// valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
if (keyid != "")
{
valObj.TB_ID = Convert.ToInt32(keyid);
count = BLLTable<TF_TABLE>.Factory(conn).Update(valObj, TF_TABLE.Attribute.TB_ID);
}
else
{
count = BLLTable<TF_TABLE>.Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("{valObj:''");
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("}");
if (ViewState["sbData"] == null)
{
ViewState["sbData"] = sbData.ToString();
}
else {
ViewState["sbData"] += ","+sbData.ToString();
}
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK")!=-1)
{
if (ViewState["sbData"] == null)
{
string dataStr = "[" + ViewState["sbData"] .ToString()+ "]";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
//txtTB_ID.Value ="";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_TABLE valObj = new TF_TABLE();
if (txtTB_NAME.Value != "")
{
valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value;
}
if (ViewState["OLDNAME"].ToString() != txtTB_NAME.Value)
{
if (BLLTable <TF_TABLE> .Exists(valObj))
{
litWarn.Text = "该表已经存在，请重新输入！";
return;
}
}
if (txtTB_ID.Value != "")
{
valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
}
if (txtCH_NAME.Value != "")
{
valObj.CH_NAME = Convert.ToString(txtCH_NAME.Value);
}
//if (txtM_TB_ID.Value != "")
valObj.M_TB_ID = pid;
if (txtSORT_NO.Value != "")
{
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
}
if (txtTB_TYPE.Value != "")
{
valObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
}
if (txtNOTE.Value != "")
{
valObj.NOTE = Convert.ToString(txtNOTE.Value);
}
if (keyid != "")
{
valObj.TB_ID = Convert.ToInt32(keyid);
count = BLLTable <TF_TABLE> .Factory(conn).Update(valObj, TF_TABLE.Attribute.TB_ID);
if (count > 0)
{
AgileFrame.Common.TF_TABLEHelper.Factory(conn).EditTable(ViewState["OLDNAME"].ToString(), valObj, ref errMsg);
}
}
else
{
valObj.CREATED = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddTableWithDefaultCols(valObj, "", "", ref errMsg);
count = BLLTable <TF_TABLE> .Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
}
if (count > 0)
{
if (Request["tree"] != null)
{
string gotoUrl = "../../../ok.aspx";
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.SORT_NO).Append(",sc:1,name:'");
if (valObj.M_TB_ID > 0)
{
sb.Append(valObj.CH_NAME).Append("',ntype:'table-mx'}");
}
else
{
sb.Append(valObj.CH_NAME).Append("',ntype:'table'}");
}
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK") != -1)
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtTB_NAME.Value = "";
txtCH_NAME.Value = "";
txtNOTE.Value = "";
}
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_TABLE valObj = new TF_TABLE();
if (txtTB_NAME.Value != "")
valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value;
if (ViewState["OLDNAME"].ToString() != txtTB_NAME.Value)
{
if (BLLTable<TF_TABLE>.Exists(valObj))
{
litWarn.Text = "�ñ��Ѿ����ڣ����������룡";
return;
}
}
if (txtTB_ID.Value != "")
valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
if (txtCH_NAME.Value != "")
valObj.CH_NAME = Convert.ToString(txtCH_NAME.Value);
//if (txtM_TB_ID.Value != "")
valObj.M_TB_ID = pid;
if (txtSORT_NO.Value != "")
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
if (txtTB_TYPE.Value != "")
valObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
if (txtNOTE.Value != "")
valObj.NOTE = Convert.ToString(txtNOTE.Value);
if (keyid != "")
{
valObj.TB_ID = Convert.ToInt32(keyid);
count = BLLTable<TF_TABLE>.Factory(conn).Update(valObj, TF_TABLE.Attribute.TB_ID);
if (count > 0)
{
AgileFrame.Common.TF_TABLEHelper.Factory(conn).EditTable(ViewState["OLDNAME"].ToString(), valObj, ref errMsg);
}
}
else
{
valObj.CREATED = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddTableWithDefaultCols(valObj,"","", ref errMsg);
count = BLLTable<TF_TABLE>.Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
}
if (count > 0)
{
if (Request["tree"] != null)
{
string gotoUrl = "../../../ok.aspx";
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.SORT_NO).Append(",sc:1,name:'");
if (valObj.M_TB_ID > 0)
{
sb.Append(valObj.CH_NAME).Append("',ntype:'table-mx'}");
}
else
{
sb.Append(valObj.CH_NAME).Append("',ntype:'table'}");
}
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK") != -1)
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtTB_NAME.Value = "";
txtCH_NAME.Value = "";
txtNOTE.Value = "";
}
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_TABLE valObj = new TF_TABLE();
if (string.IsNullOrEmpty(keyid))
{
if (txtTB_NAME.Value != "")
valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value;
if (ViewState["OLDNAME"].ToString() != valObj.TB_NAME)
{
if (BLLTable<TF_TABLE>.Exists(valObj))
{
litWarn.Text = "�ñ��Ѿ����ڣ����������룡";
return;
}
}
if (txtTB_ID.Value != "")
valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
//if (txtM_TB_ID.Value != "")
valObj.M_TB_ID = pid;
if (txtTB_TYPE.Value != "")
valObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
}
else {
valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value;
}
if(txtSORT_NO.Value !="" )
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
//ADD START ��������ȱ�� jin-shenjian 2013/10/12
if (txtCH_NAME.Value != "")
valObj.CH_NAME = Convert.ToString(txtCH_NAME.Value);
//ADD END ��������ȱ�� jin-shenjian 2013/10/12
if(txtNOTE.Value !="" )
valObj.NOTE = Convert.ToString(txtNOTE.Value);
if (keyid != "")
{
valObj.TB_ID = Convert.ToInt32(keyid);
count = BLLTable<TF_TABLE>.Factory(conn).Update(valObj, TF_TABLE.Attribute.TB_ID);
if (count > 0)
{
TF_TABLEHelper.Factory(conn).EditTable(ViewState["OLDNAME"].ToString(), valObj, ref errMsg);
}
}
else
{
int ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddTableWithDefaultCols(valObj, txtTB_NAME_Save.Value, GetConnByDevKey(txtDB_NAME_Save.Value), ref errMsg);
if (ret1 == 0)
{
litWarn.Text = errMsg;
Response.End(); return;
}
valObj.SOURCE_TABLE = txtTB_NAME_Save.Value;
valObj.SOURCE_DB = txtDB_NAME_Save.Value;
count = BLLTable<TF_TABLE>.Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
TF_TB_FIELD valField = new TF_TB_FIELD();
DataBaseTable tbsource = null;
string strRetMessage = "";
if (!string.IsNullOrEmpty(valObj.TB_NAME) && DataBase.Factory(conn).TryGetValue(valObj.TB_NAME, out tbsource))
{
int count1 = new TF_TABLEHelper(conn).SaveToTF_TB_FIELD(valObj.TB_NAME, valObj.TB_ID,ref strRetMessage);
if (count1 < 1)
{
}
}
}
if (count > 0)
{
string gotoUrl = WebHelper.GetAppPath() + @"ok.aspx";
if (Request["tree"] != null)
{
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.SORT_NO).Append(",sc:1,name:'");
if (valObj.M_TB_ID > 0)
{
sb.Append(valObj.CH_NAME).Append("',ntype:'TF_TABLE-mx'}");
}
else
{
sb.Append(valObj.CH_NAME).Append("',ntype:'TF_TABLE'}");
}
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK") != -1)
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtTB_NAME.Value = "";
txtCH_NAME.Value = "";
txtNOTE.Value = "";
}
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_TABLE valObj = new TF_TABLE();
//if(txtTB_ID.Value !="" )
// valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
if (keyid != "")
{
valObj.TB_ID = Convert.ToInt32(keyid);
count = BLLTable <TF_TABLE> .Factory(conn).Update(valObj, TF_TABLE.Attribute.TB_ID);
}
else
{
count = BLLTable <TF_TABLE> .Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("{valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("}");
if (ViewState["sbData"] == null)
{
ViewState["sbData"] = sbData.ToString();
}
else
{
ViewState["sbData"] += "," + sbData.ToString();
}
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK") != -1)
{
if (ViewState["sbData"] == null)
{
string dataStr = "[" + ViewState["sbData"].ToString() + "]";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
//txtTB_ID.Value ="";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}