/// <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);
