/// <summary> /// 将记录集转为sys_FieldValueTable实体类 /// </summary> /// <param name="dr">记录集</param> /// <returns>sys_FieldValueTable</returns> protected object Populatesys_FieldValue(IDataReader dr) { sys_FieldValueTable nc = new sys_FieldValueTable(); if (!Convert.IsDBNull(dr["ValueID"])) { nc.ValueID = Convert.ToInt32(dr["ValueID"]); // 索引ID号 } if (!Convert.IsDBNull(dr["V_F_Key"])) { nc.V_F_Key = Convert.ToString(dr["V_F_Key"]).Trim(); // 与sys_Field表中F_Key字段关联 } if (!Convert.IsDBNull(dr["V_Text"])) { nc.V_Text = Convert.ToString(dr["V_Text"]).Trim(); // 中文说明 } if (!Convert.IsDBNull(dr["V_Code"])) { nc.V_Code = Convert.ToString(dr["V_Code"]).Trim(); // 编码 } if (!Convert.IsDBNull(dr["V_ShowOrder"])) { nc.V_ShowOrder = Convert.ToInt32(dr["V_ShowOrder"]); // 同级显示顺序 } return(nc); }
protected void Button2_Click(object sender, EventArgs e) { int ValueID = (int)Common.sink("ValueID", MethodType.Get, 255, 1, DataType.Int); sys_FieldValueTable ft = new sys_FieldValueTable(); ft.DB_Option_Action_ = "Delete"; ft.ValueID = ValueID; BusinessFacade.sys_FieldValueInsertUpdate(ft); EventMessage.EventWriteDB(1, string.Format("删除应用字段值({0})成功!", ft.V_Text)); ClientScriptManager cs = Page.ClientScript; cs.RegisterStartupScript(typeof(string), "TabJs", "<script language='javascript'>window.returnVal='删除成功!';window.parent.hidePopWin(true);</script>"); }
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>"); }
/// <summary> /// 新增/删除/修改 sys_FieldValue /// </summary> /// <param name="fam">sys_FieldValueTable实体类</param> /// <returns>返回0操正常</returns> public override int sys_FieldValueInsertUpdate(sys_FieldValueTable fam) { int rInt = 0; using (SqlConnection Conn = GetSqlConnection()) { SqlCommand cmd = new SqlCommand("sys_FieldValueInsertUpdateDelete", 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("@ValueID", SqlDbType.Int).Value = fam.ValueID; //索引ID号 cmd.Parameters.Add("@V_F_Key", SqlDbType.VarChar).Value = fam.V_F_Key; //与sys_Field表中F_Key字段关联 cmd.Parameters.Add("@V_Text", SqlDbType.NVarChar).Value = fam.V_Text; //中文说明 cmd.Parameters.Add("@V_Code", SqlDbType.NVarChar).Value = fam.V_Code; //编码 cmd.Parameters.Add("@V_ShowOrder", SqlDbType.Int).Value = fam.V_ShowOrder; //同级显示顺序 Conn.Open(); rInt = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); Conn.Dispose(); Conn.Close(); } return(rInt); }
/// <summary> /// 创建html /// </summary> /// <returns></returns> private string CreateHtml() { string F_Value = ""; int RecordCount = 0; QueryParam qp = new QueryParam(); qp.Where = string.Format("Where V_F_Key='{0}'", Common.inSQL(this.F_Key)); qp.Orderfld = " V_ShowOrder "; qp.OrderType = 0; ArrayList lst = new ArrayList(); try { lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount); } catch { for (int i = 0; i < 5; i++) { sys_FieldValueTable fv = new sys_FieldValueTable(); fv.ValueID = i; fv.V_Text = string.Format("测试{0}", i); lst.Add(fv); } } StringBuilder sb = new StringBuilder(); string SelectOk = ""; //是否选中当前选项 string rString = ""; if (Disabled) { rString += " disabled "; } if (Readonly) { rString += " readonly "; } if (FieldDisp == FieldDispType.Select) { sb.AppendFormat("<select name={0} title=\"{1}\" {2}>", Field_Name, F_Title, rString); sb.Append("<option value=\"\">请选择...</option>"); foreach (sys_FieldValueTable var in lst) { if (UseCodeValue) { F_Value = var.V_Code.Trim(); } else if (UseValue == "V_Text") { F_Value = var.V_Text.Trim(); } else { F_Value = var.ValueID.ToString(); } if (Common.Check_Char_Is(F_Value, Field_Value)) { SelectOk = "selected"; } else { SelectOk = ""; } sb.AppendFormat("<option value=\"{0}\" {2}>{1}</option>", F_Value, var.V_Text, SelectOk); } sb.Append("</select>"); } else if (FieldDisp == FieldDispType.CheckBox || FieldDisp == FieldDispType.RadioBox) { if (!LineNumOn) { LineNum = 1; } int Tempi = 1; //当前记录数 int TdWidth = 100 / LineNum; //TD宽度 int C_nextline = 0; //换行标识 string InputTypeTxt = "checkbox"; if (FieldDisp == FieldDispType.RadioBox) { InputTypeTxt = "radio"; } sb.Append("<table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"1\" ><tr>"); foreach (sys_FieldValueTable var in lst) { if (UseCodeValue) { F_Value = var.V_Code.Trim(); } else if (UseValue == "V_Text") { F_Value = var.V_Text.Trim(); } else { F_Value = var.ValueID.ToString(); } if (C_nextline == 1) { sb.Append("</tr>"); C_nextline = 0; sb.Append("<tr>"); } if (Common.Check_Char_Is(F_Value, Field_Value)) { SelectOk = "checked"; } else { SelectOk = ""; } sb.AppendFormat("<td width=\"{5}%\"><input name=\"{0}\" id=\"{0}{6}\" type={4} value=\"{1}\" {3} {7}><label for=\"{0}{6}\">{2}</label></td>", Field_Name, F_Value, var.V_Text, SelectOk, InputTypeTxt, TdWidth, Tempi, rString); //产生换行标识 if ((Tempi % LineNum) == 0) { C_nextline = 1; } Tempi++; } //补齐td int LostTDNum = LineNum - lst.Count % LineNum; if (LostTDNum != LineNum && LineNum > 0) { for (int i = 0; i < LostTDNum; i++) { sb.AppendFormat("<td width=\"{0}%\"> </td>", TdWidth); } sb.Append("</tr>"); } sb.Append("</table>"); } return(sb.ToString()); }
/// <summary> /// 新增/删除/修改 sys_FieldValue /// </summary> /// <param name="fam">sys_FieldValueTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_FieldValueInsertUpdate(sys_FieldValueTable fam);