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