/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string dicid, string buscode, string strcode, string dictype, string lng, string pdicid, string diccode, string dicname, string dicvalue, string orderno, string remark, string status, string cuser)
{
bool rel = false;
try
{
Entity = new ts_DictsEntity();
Entity.dicid = StringHelper.StringToLong(dicid);
Entity.strcode = strcode;
Entity.dictype = dictype;
Entity.lng = lng;
Entity.pdicid = StringHelper.StringToLong(pdicid);
Entity.diccode = diccode;
Entity.dicname = dicname;
Entity.dicvalue = dicvalue;
Entity.orderno = StringHelper.StringToInt(orderno);
Entity.remark = remark;
Entity.status = status;
Entity.cuser = StringHelper.StringToLong(cuser);
rel = true;
}
catch (System.Exception)
{
}
return(rel);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref ts_DictsEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@dicid", Entity.dicid),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@strcode", Entity.strcode),
new SqlParameter("@dictype", Entity.dictype),
new SqlParameter("@lng", Entity.lng),
new SqlParameter("@pdicid", Entity.pdicid),
new SqlParameter("@diccode", Entity.diccode),
new SqlParameter("@dicname", Entity.dicname),
new SqlParameter("@dicvalue", Entity.dicvalue),
new SqlParameter("@orderno", Entity.orderno),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@cuser", Entity.cuser),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_ts_Dicts_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.dicid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, ts_DictsEntity UEntity)
{
//更新数据
int result = dal.Update(UEntity);
//检测执行结果
CheckResult(result, "");
}
//保存数据
protected void Save_btn_Click(object sender, EventArgs e)
{
//获取页面信息
string buscode = Helper.GetAppSettings("BusCode");
string strcode = Helper.GetAppSettings("Stocode");
string dictype = "0";
string lng = this.ddl_lng.SelectedValue;
string pdicid = this.ddl_pdicid.SelectedValue;
string diccode = txt_diccode.Text;
string dicname = txt_dicname.Text;
string dicvalue = "";
string orderno = txt_orderno.Text;
string remark = txt_remark.Text;
string status = ddl_status.SelectedValue;
string cuser = base.LoginedUser.UserID.ToString();
DataTable dt = new DataTable();
if (hidId.Value.Length == 0)//添加信息
{
string dicid = "";
bll.Add("0", "0", dicid, buscode, strcode, dictype, lng, pdicid, diccode, dicname, dicvalue, orderno, remark, status, cuser);
hidId.Value = bll.oResult.Data;
this.PageTitle.Operate = "修改";
}
else//修改信息
{
ts_DictsEntity UEntity = bll.GetEntitySigInfo("where id=" + hidId.Value);
UEntity.strcode = strcode;
UEntity.dictype = dictype;
UEntity.lng = lng;
UEntity.pdicid = StringHelper.StringToLong(pdicid);
UEntity.diccode = diccode;
UEntity.dicname = dicname;
UEntity.dicvalue = dicvalue;
UEntity.orderno = StringHelper.StringToInt(orderno);
UEntity.remark = remark;
UEntity.status = status;
UEntity.cuser = StringHelper.StringToInt(cuser);
bll.Update("0", "0", UEntity);
this.PageTitle.Operate = "修改";
}
//显示结果
ShowResult(bll.oResult.Code, bll.oResult.Msg, errormessage);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ts_DictsEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@dicid", Entity.dicid),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@strcode", Entity.strcode),
new SqlParameter("@dictype", Entity.dictype),
new SqlParameter("@lng", Entity.lng),
new SqlParameter("@pdicid", Entity.pdicid),
new SqlParameter("@diccode", Entity.diccode),
new SqlParameter("@dicname", Entity.dicname),
new SqlParameter("@dicvalue", Entity.dicvalue),
new SqlParameter("@orderno", Entity.orderno),
new SqlParameter("@remark", Entity.remark),
new SqlParameter("@status", Entity.status),
new SqlParameter("@cuser", Entity.cuser),
};
return(DBHelper.ExecuteNonQuery("dbo.p_ts_Dicts_Update", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private ts_DictsEntity SetEntityInfo(DataRow dr)
{
ts_DictsEntity Entity = new ts_DictsEntity();
Entity.dicid = StringHelper.StringToLong(dr["dicid"].ToString());
Entity.strcode = dr["strcode"].ToString();
Entity.dictype = dr["dictype"].ToString();
Entity.lng = dr["lng"].ToString();
Entity.pdicid = StringHelper.StringToLong(dr["pdicid"].ToString());
Entity.diccode = dr["diccode"].ToString();
Entity.dicname = dr["dicname"].ToString();
Entity.dicvalue = dr["dicvalue"].ToString();
Entity.orderno = StringHelper.StringToInt(dr["orderno"].ToString());
Entity.remark = dr["remark"].ToString();
Entity.status = dr["status"].ToString();
Entity.cuser = StringHelper.StringToLong(dr["cuser"].ToString());
return(Entity);
}
