protected void Button1_Click(object sender, EventArgs e)
{
string All_Title_Txt = "";
PopedomType pt = PopedomType.New;
sys_FieldTable Ft = BusinessFacade.sys_FieldDisp(FieldID);
string F_CName_Value = (string)Common.sink(F_CName.UniqueID, MethodType.Post, 50, 1, DataType.Str);
string F_Remark_Value = (string)Common.sink(F_Remark.UniqueID, MethodType.Post, 200, 0, DataType.Str);
Ft.F_CName = F_CName_Value;
Ft.F_Remark = F_Remark_Value;
if (CMD == "New")
{
string F_Key_Value = (string)Common.sink(F_Key.UniqueID, MethodType.Post, 50, 1, DataType.CharAndNum);
Ft.F_Key = F_Key_Value;
All_Title_Txt = "增加";
Ft.DB_Option_Action_ = "Insert";
}
else if (CMD == "Edit")
{
pt = PopedomType.Edit;
All_Title_Txt = "修改";
Ft.DB_Option_Action_ = "Update";
}
if (BusinessFacade.sys_FieldCheckPK(Ft, pt))
{
EventMessage.MessageBox(1, "操作失败", string.Format("存在相同的值({0})!", Ft.F_Key), Icon_Type.Alert, Common.GetHomeBaseUrl("default.aspx"));
}
BusinessFacade.sys_FieldInsertUpdate(Ft);
EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", FieldID, All_Title_Txt), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
protected void Button1_Click(object sender, EventArgs e)
{
int FieldID = (int)Common.sink("FieldID", MethodType.Get, 255, 1, DataType.Int);
sys_FieldTable ft = BusinessFacade.sys_FieldDisp(FieldID);
string V_Text_Value = (string)Common.sink(V_Text_Input.UniqueID, MethodType.Post, 100, 1, DataType.Str);
string V_Code_Value = (string)Common.sink(V_Code_Input.UniqueID, MethodType.Post, 100, 0, DataType.Str);
int ValueID = (int)Common.sink("ValueID", MethodType.Get, 255, 0, DataType.Int);
sys_FieldValueTable fvt = BusinessFacade.sys_FieldValueDisp(ValueID);
fvt.V_Text = V_Text_Value;
fvt.V_Code = V_Code_Value;
fvt.V_F_Key = ft.F_Key;
string Messages = "";
if (CMD == "Edit")
{
fvt.DB_Option_Action_ = "Update";
Messages = string.Format("修改应用字段值(ID:{0})成功!", fvt.ValueID);
}
else if (CMD == "New")
{
QueryParam qp = new QueryParam();
qp.Where = string.Format("where V_F_Key = '{0}'", Common.inSQL(ft.F_Key));
//qp.PageSize = 1;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount);
if (RecordCount == 0)
{
fvt.V_ShowOrder = 0;
}
else
{
fvt.V_ShowOrder = ((sys_FieldValueTable)lst[RecordCount - 1]).V_ShowOrder + 1;
}
fvt.DB_Option_Action_ = "Insert";
Messages = string.Format("增加应用字段值({0})成功!", fvt.V_Text);
}
BusinessFacade.sys_FieldValueInsertUpdate(fvt);
EventMessage.EventWriteDB(1, Messages);
ClientScriptManager cs = Page.ClientScript;
cs.RegisterStartupScript(typeof(string), "TabJs", "<script language='javascript'>window.returnVal=\"" + Messages + "\";window.parent.hidePopWin(true);</script>");
}
private void OnStart()
{
Button2.Attributes.Add("onclick", "return doConfirm(this.form);");
if (CMD == "OrderBy")
{
Table_OrderBy_FieldValue.Visible = true;
string F_Key = (string)Common.sink("F_Key", MethodType.Get, 50, 1, DataType.CharAndNum);
QueryParam qp = new QueryParam();
qp.Where = string.Format("where V_F_Key = '{0}'", Common.inSQL(F_Key));
qp.Orderfld = " V_ShowOrder ";
qp.OrderType = 0;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount);
OrderByListItems.DataTextField = "V_Text";
OrderByListItems.DataValueField = "ValueID";
OrderByListItems.DataSource = lst;
OrderByListItems.DataBind();
Button3.OnClientClick = string.Format("selectAll({0})", OrderByListItems.UniqueID);
}
else
{
int FieldID = (int)Common.sink("FieldID", MethodType.Get, 255, 1, DataType.Int);
sys_FieldTable ft = BusinessFacade.sys_FieldDisp(FieldID);
F_Key.Text = ft.F_Key;
F_CName.Text = ft.F_CName;
Table_Manager_FieldValue.Visible = true;
if (CMD == "Edit")
{
int ValueID = (int)Common.sink("ValueID", MethodType.Get, 255, 1, DataType.Int);
V_Text_Input.Text = BusinessFacade.sys_FieldValueDisp(ValueID).V_Text;
V_Code_Input.Text = BusinessFacade.sys_FieldValueDisp(ValueID).V_Code;
}
else
{
Button2.Visible = false;
}
}
}
/// <summary>
/// 将记录集转为sys_FieldTable实体类
/// </summary>
/// <param name="dr">记录集</param>
/// <returns>sys_FieldTable</returns>
protected object Populatesys_Field(IDataReader dr)
{
sys_FieldTable nc = new sys_FieldTable();
if (!Convert.IsDBNull(dr["FieldID"]))
{
nc.FieldID = Convert.ToInt32(dr["FieldID"]); // 应用字段ID号
}
if (!Convert.IsDBNull(dr["F_Key"]))
{
nc.F_Key = Convert.ToString(dr["F_Key"]).Trim(); // 应用字段关键字
}
if (!Convert.IsDBNull(dr["F_CName"]))
{
nc.F_CName = Convert.ToString(dr["F_CName"]).Trim(); // 应用字段中文说明
}
if (!Convert.IsDBNull(dr["F_Remark"]))
{
nc.F_Remark = Convert.ToString(dr["F_Remark"]).Trim(); // 描述说明
}
return(nc);
}
/// <summary>
/// 新增/删除/修改 sys_Field
/// </summary>
/// <param name="fam">sys_FieldTable实体类</param>
/// <returns>返回0操正常</returns>
public override int sys_FieldInsertUpdate(sys_FieldTable fam)
{
int rInt = 0;
using (SqlConnection Conn = GetSqlConnection())
{
SqlCommand cmd = new SqlCommand("sys_FieldInsertUpdateDelete", Conn);
cmd.CommandType = CommandType.StoredProcedure;
//设置参数
cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录
cmd.Parameters.Add("@FieldID", SqlDbType.Int).Value = fam.FieldID; //应用字段ID号
cmd.Parameters.Add("@F_Key", SqlDbType.VarChar).Value = fam.F_Key; //应用字段关键字
cmd.Parameters.Add("@F_CName", SqlDbType.NVarChar).Value = fam.F_CName; //应用字段中文说明
cmd.Parameters.Add("@F_Remark", SqlDbType.NVarChar).Value = fam.F_Remark; //描述说明
Conn.Open();
rInt = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
Conn.Dispose();
Conn.Close();
}
return(rInt);
}
/// <summary> /// 新增/删除/修改 sys_Field /// </summary> /// <param name="fam">sys_FieldTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_FieldInsertUpdate(sys_FieldTable fam);
private void OnStart()
{
sys_FieldTable Ft = BusinessFacade.sys_FieldDisp(FieldID);
F_Key_Txt.Text = Ft.F_Key;
F_CName_Txt.Text = Ft.F_CName;
F_Remark_Txt.Text = Ft.F_Remark;
QueryParam qp = new QueryParam();
qp.Where = string.Format("where V_F_Key = '{0}'", Common.inSQL(Ft.F_Key));
qp.Orderfld = " V_ShowOrder ";
qp.OrderType = 0;
int RecordCount = 0;
ArrayList lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount);
Main_Value.DataSource = lst;
Main_Value.DataBind();
if (CMD == "List")
{
HeadMenuButtonItem bi1 = new HeadMenuButtonItem();
bi1.ButtonPopedom = PopedomType.Edit;
bi1.ButtonName = "应用字段";
bi1.ButtonUrl = string.Format("?CMD=Edit&FieldID={0}", FieldID);
HeadMenuWebControls1.ButtonList.Add(bi1);
HeadMenuButtonItem bi3 = new HeadMenuButtonItem();
bi3.ButtonPopedom = PopedomType.New;
bi3.ButtonName = "应用字段值";
bi3.ButtonUrl = string.Format("showPopWin('应用字段值增加','FieldValueBox.aspx?FieldID={0}&CMD=New&{1}', 300, 160, AlertMessageBox,true);", FieldID, Common.RndNum(7));
bi3.ButtonUrlType = UrlType.JavaScript;
HeadMenuWebControls1.ButtonList.Add(bi3);
HeadMenuButtonItem bi4 = new HeadMenuButtonItem();
bi4.ButtonPopedom = PopedomType.Edit;
bi4.ButtonName = "排序应用字段值";
bi4.ButtonIcon = "Orderby.gif";
bi4.ButtonUrl = string.Format("showPopWin('应用字段值排序','FieldValueBox.aspx?F_Key={0}&CMD=OrderBy&{1}', 180, 210, AlertMessageBox,true);", Ft.F_Key, Common.RndNum(7));
bi4.ButtonUrlType = UrlType.JavaScript;
HeadMenuWebControls1.ButtonList.Add(bi4);
Disp_Input.Visible = false;
F_Key_Txt.Visible = true;
F_CName_Txt.Visible = true;
F_Remark_Txt.Visible = true;
F_Key.Visible = false;
F_CName.Visible = false;
F_Remark.Visible = false;
}
else if (CMD == "Edit")
{
F_Key.Text = Ft.F_Key;
F_CName.Text = Ft.F_CName;
F_Remark.Text = Ft.F_Remark;
F_Key.Visible = false;
F_Key_Txt.Visible = true;
HeadMenuButtonItem bi5 = new HeadMenuButtonItem();
bi5.ButtonIcon = "back.gif";
bi5.ButtonPopedom = PopedomType.List;
bi5.ButtonName = "返回";
bi5.ButtonUrl = string.Format("?CMD=List&FieldID={0}", FieldID);
HeadMenuWebControls1.ButtonList.Add(bi5);
HeadMenuButtonItem bi2 = new HeadMenuButtonItem();
bi2.ButtonPopedom = PopedomType.Delete;
bi2.ButtonName = "应用字段";
bi2.ButtonUrlType = UrlType.JavaScript;
bi2.ButtonUrl = string.Format("DelData('?CMD=Delete&FieldID={0}')", FieldID);
HeadMenuWebControls1.ButtonList.Add(bi2);
Disp_Sub.Visible = false;
}
else if (CMD == "New")
{
Disp_Sub.Visible = false;
}
else if (CMD == "Delete")
{
Ft.DB_Option_Action_ = "Delete";
BusinessFacade.sys_FieldInsertUpdate(Ft);
foreach (sys_FieldValueTable var in lst)
{
var.DB_Option_Action_ = "Delete";
BusinessFacade.sys_FieldValueInsertUpdate(var);
}
EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", FieldID, "删除应用字段"), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
}
