/// <summary>
/// 设置
/// </summary>
public override void EntitySet()
{
FiledSet entity = new FiledSet();
entity.ID = HTDataID;
bool findFlag = entity.SelectByID();
txtFormID.Text = entity.FormID.ToString();
txtFAID.Text = entity.FAID.ToString();
txtFBID.Text = entity.FBID.ToString();
txtSort.Text = entity.Sort.ToString();
txtCode.Text = entity.Code.ToString();
txtName.Text = entity.Name.ToString();
txtFiledName.Text = entity.FiledName.ToString();
txtFiledType.Text = entity.FiledType.ToString();
drpBindType.EditValue = SysConvert.ToInt32(entity.BindType);
txtLength.Text = entity.Length.ToString();
txtRemark.Text = entity.Remark.ToString();
drpUseableFlag.EditValue = entity.UseableFlag;
drpUpDateFlag.EditValue = entity.UpDateFlag;
txtMainTable.Text = entity.MainTable;
if (!findFlag)
{
}
}
/// <summary>
/// 更新表单设置的值
/// </summary>
/// <param name="p_ID"></param>
/// <param name="p_TableName"></param>
/// <param name="p_FiledName"></param>
/// <param name="p_Value"></param>
/// <param name="sqlTrans"></param>
public void UpdateFiledSet(int p_ID, int p_FiledSetID, string p_Value, IDBTransAccess sqlTrans)
{
try
{
FiledSet entity = new FiledSet(sqlTrans);
entity.ID = p_FiledSetID;
entity.SelectByID();
string sql = "";
if (entity.UpDateFlag == 1) //更新标志
{
if (entity.FiledType == "string")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToString(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "decimal")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToDecimal(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "int")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToInt32(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "datetime")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToDateTime(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 获得实体
/// </summary>
/// <returns></returns>
private FiledSet EntityGet()
{
FiledSet entity = new FiledSet();
entity.ID = HTDataID;
entity.SelectByID();
entity.FormID = SysConvert.ToInt32(txtFormID.Text.Trim());
entity.FAID = SysConvert.ToInt32(txtFAID.Text.Trim());
entity.FBID = SysConvert.ToInt32(txtFBID.Text.Trim());
entity.Sort = SysConvert.ToInt32(txtSort.Text.Trim());
entity.Code = SysConvert.ToInt32(txtCode.Text.Trim());
entity.Name = txtName.Text.Trim();
entity.FiledName = txtFiledName.Text.Trim();
entity.FiledType = txtFiledType.Text.Trim();
entity.BindType = SysConvert.ToString(drpBindType.EditValue);
entity.Length = SysConvert.ToInt32(txtLength.Text.Trim());
entity.Remark = txtRemark.Text.Trim();
entity.UseableFlag = SysConvert.ToInt32(drpUseableFlag.EditValue);
entity.UpDateFlag = SysConvert.ToInt32(drpUpDateFlag.EditValue);
entity.MainTable = txtMainTable.Text.Trim();
return(entity);
}