public bool Exists(Common_DictModel model) { StringBuilder builder = new StringBuilder(); builder.Append("select count(1) from Common_Dict"); builder.AppendFormat(" where Common_Dict_ID<>'{0}'and D_Name='{1}' and D_Type='{2}' ", model.Common_Dict_ID, model.D_Name, model.D_Type); return(int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0); }
internal int Update(DbTransaction tran, Common_DictModel model) { StringBuilder builder = new StringBuilder(); builder.Append(" UPDATE "); builder.Append(" Common_Dict "); builder.Append(" SET "); builder.Append(" Common_Dict_ID=@Common_Dict_ID,D_Name=@D_Name,D_ParentID=@D_ParentID,D_Value=@D_Value,D_Code=@D_Code,D_Order=@D_Order,D_Type=@D_Type,D_Remark=@D_Remark,D_CreateUser=@D_CreateUser,D_CreateTime=@D_CreateTime,D_ModifyUser=@D_ModifyUser,D_ModifyTime=@D_ModifyTime "); builder.Append(" WHERE "); builder.Append(" Common_Dict_ID=@Common_Dict_ID "); return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.Common_Dict_ID, model.D_Name, model.D_ParentID, model.D_Value, model.D_Code, model.D_Order, model.D_Type, model.D_Remark, model.D_CreateUser, model.D_CreateTime, model.D_ModifyUser, model.D_ModifyTime })); }
internal int Add(DbTransaction tran, Common_DictModel model) { StringBuilder builder = new StringBuilder(); builder.Append(" INSERT INTO "); builder.Append(" Common_Dict( "); builder.Append(" Common_Dict_ID,D_Name,D_ParentID,D_Value,D_Code,D_Order,D_Type,D_Remark,D_CreateUser,D_CreateTime,D_ModifyUser,D_ModifyTime "); builder.Append(" ) "); builder.Append(" values( "); builder.Append(" @Common_Dict_ID,@D_Name,@D_ParentID,@D_Value,@D_Code,@D_Order,@D_Type,@D_Remark,@D_CreateUser,@D_CreateTime,@D_ModifyUser,@D_ModifyTime "); builder.Append(" ) "); return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.Common_Dict_ID, model.D_Name, model.D_ParentID, model.D_Value, model.D_Code, model.D_Order, model.D_Type, model.D_Remark, model.D_CreateUser, model.D_CreateTime, model.D_ModifyUser, model.D_ModifyTime })); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (CheckInput()) { Common_DictModel model = new Common_DictModel(); model = GetData(); bool result = false; if (string.IsNullOrEmpty(common_dict_id))//添加 { if (bll.Exists(model, 1)) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.div_PopEdit('2','已存在同名数据更新项!');</script>"); return; } else { result = bll.Add(model) > 0 ? true : false; } } else//修改 { if (bll.Exists(model, 2)) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.div_PopEdit('2','已存在同名数据更新项!');</script>"); return; } else { result = bll.Update(model) > 0 ? true : false; } } if (result) { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.div_PopEdit('1','保存成功!','" + model.Common_Dict_ID + "');</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.div_PopEdit('2','保存失败!');</script>"); } } } catch (Exception ex) { new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace)); throw ex; } }
public bool Exists(Common_DictModel model, int type) { StringBuilder builder = new StringBuilder(); builder.Append("select count(1) from Common_Dict"); if (type == 1) { builder.AppendFormat(" where (D_Name='{0}' or D_Remark='{1}') and D_Type='{2}'", model.D_Name, model.D_Remark, model.D_Type); } else { builder.AppendFormat(" where Common_Dict_ID<>'{0}' and D_Type='{1}' and (D_Remark='{2}' or D_Name='{3}') ", new object[] { model.Common_Dict_ID, model.D_Type, model.D_Remark, model.D_Name }); } return(int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0); }
//获取界面参数 private Common_DictModel GetData() { Common_DictModel model = new Common_DictModel(); if (string.IsNullOrEmpty(common_dict_id)) { model.Common_Dict_ID = Guid.NewGuid().ToString(); model.D_CreateUser = loginUser.SysUser_ID; model.D_CreateTime = DateTime.Now; } else { model = new Common_DictBLL().GetCommon_DictModelByPK(common_dict_id); model.D_ModifyTime = DateTime.Now; model.D_ModifyUser = loginUser.SysUser_ID; } model.D_Name = txtd_name.Text.Trim(); model.D_Code = txtD_code.Text.Trim(); model.D_Remark = txtd_Remark.Text.Trim(); model.D_Type = 43; return(model); }
//从页面上获取模板数据 private Common_DictModel GetSysCodeFromPage(int i) { Common_DictModel Common_DictTemp = null; if (i == 1) { Common_DictTemp = new Common_DictModel(); Common_DictTemp.Common_Dict_ID = Guid.NewGuid().ToString(); Common_DictTemp.D_CreateUser = loginUser.SysUser_ID; Common_DictTemp.D_CreateTime = DateTime.Now; } else { Common_DictTemp = new Common_DictModel(); Common_DictTemp.Common_Dict_ID = sysCommon_Dict_ID; Common_DictTemp.D_ModifyUser = loginUser.SysUser_ID; Common_DictTemp.D_ModifyTime = DateTime.Now; } Common_DictTemp.D_Name = txtD_Name.Text.Trim(); if (!string.IsNullOrEmpty(txtD_Value.Text.Trim())) { Common_DictTemp.D_Value = int.Parse(txtD_Value.Text.Trim()); } //Common_DictTemp.D_Code = txtD_Code.Text.Trim(); if (!string.IsNullOrEmpty(txtD_Order.Text.Trim())) { Common_DictTemp.D_Order = int.Parse(txtD_Order.Text.Trim()); } if (!string.IsNullOrEmpty(ddlD_Type.SelectedValue.Trim())) { Common_DictTemp.D_Type = int.Parse(ddlD_Type.SelectedValue.Trim()); } Common_DictTemp.D_Remark = txtRemark.Text.Trim(); return(Common_DictTemp); }
public bool Exists(Common_DictModel model) { return(this.DAL.Exists(model)); }
public bool Exists(Common_DictModel model, int type) { return(this.DAL.Exists(model, type)); }
public int Update(Common_DictModel model) { return(this.DAL.Update(model)); }
public int Add(Common_DictModel model) { return(this.DAL.Add(model)); }
internal Common_DictModel GetCommon_DictModelByPK(DbTransaction tran, string common_dict_id) { StringBuilder builder = new StringBuilder(); builder.Append(" SELECT "); builder.Append(" TOP 1 * "); builder.Append(" FROM "); builder.Append(" Common_Dict "); builder.Append(" WHERE "); builder.Append(" Common_Dict_ID=@Common_Dict_ID "); DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, new object[] { common_dict_id }); Common_DictModel model = null; if (set.Tables[0].Rows.Count > 0) { DataRow row = set.Tables[0].Rows[0]; model = new Common_DictModel(); if (row["Common_Dict_ID"] != null) { model.Common_Dict_ID = row["Common_Dict_ID"].ToString(); } if (row["D_Name"] != null) { model.D_Name = row["D_Name"].ToString(); } if (row["D_ParentID"] != null) { model.D_ParentID = row["D_ParentID"].ToString(); } if (row["D_Value"] != null) { if (string.IsNullOrWhiteSpace(row["D_Value"].ToString())) { model.D_Value = null; } else { model.D_Value = new int?(int.Parse(row["D_Value"].ToString())); } } if (row["D_Code"] != null) { model.D_Code = row["D_Code"].ToString(); } if (row["D_Order"] != null) { if (string.IsNullOrWhiteSpace(row["D_Order"].ToString())) { model.D_Order = null; } else { model.D_Order = new int?(int.Parse(row["D_Order"].ToString())); } } if (row["D_Type"] != null) { if (string.IsNullOrWhiteSpace(row["D_Type"].ToString())) { model.D_Type = null; } else { model.D_Type = new int?(int.Parse(row["D_Type"].ToString())); } } if (row["D_Remark"] != null) { model.D_Remark = row["D_Remark"].ToString(); } if (row["D_CreateUser"] != null) { model.D_CreateUser = row["D_CreateUser"].ToString(); } if (row["D_CreateTime"] != null) { if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString())) { model.D_CreateTime = null; } else { model.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString())); } } if (row["D_ModifyUser"] != null) { model.D_ModifyUser = row["D_ModifyUser"].ToString(); } if (row["D_ModifyTime"] == null) { return(model); } if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString())) { model.D_ModifyTime = null; return(model); } model.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString())); } return(model); }
//验证编辑是否存在 private bool Exists(Common_DictModel model) { return(BLL.Exists(model)); }
public int Add(Common_DictModel model) { return(this.Add(null, model)); }
internal List <Common_DictModel> GetCommon_DictModelList(DbTransaction tran, int recordNum, string orderColumn, string orderType, string strCondition, params object[] param) { StringBuilder builder = new StringBuilder(); builder.Append(" SELECT "); if (recordNum > 0) { builder.Append(" TOP " + recordNum); } builder.Append(" * "); builder.Append(" FROM "); builder.Append(" Common_Dict "); if (!string.IsNullOrEmpty(strCondition)) { builder.Append(" WHERE "); builder.Append(strCondition); } if (!string.IsNullOrEmpty(orderColumn)) { builder.Append(" ORDER BY "); builder.Append(orderColumn); if (!string.IsNullOrEmpty(orderType)) { builder.Append(" " + orderType); } } DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param); List <Common_DictModel> list = new List <Common_DictModel>(); Common_DictModel item = null; foreach (DataRow row in set.Tables[0].Rows) { item = new Common_DictModel(); if (row["Common_Dict_ID"] != null) { item.Common_Dict_ID = row["Common_Dict_ID"].ToString(); } if (row["D_Name"] != null) { item.D_Name = row["D_Name"].ToString(); } if (row["D_ParentID"] != null) { item.D_ParentID = row["D_ParentID"].ToString(); } if (row["D_Value"] != null) { if (string.IsNullOrWhiteSpace(row["D_Value"].ToString())) { item.D_Value = null; } else { item.D_Value = new int?(int.Parse(row["D_Value"].ToString())); } } if (row["D_Code"] != null) { item.D_Code = row["D_Code"].ToString(); } if (row["D_Order"] != null) { if (string.IsNullOrWhiteSpace(row["D_Order"].ToString())) { item.D_Order = null; } else { item.D_Order = new int?(int.Parse(row["D_Order"].ToString())); } } if (row["D_Type"] != null) { if (string.IsNullOrWhiteSpace(row["D_Type"].ToString())) { item.D_Type = null; } else { item.D_Type = new int?(int.Parse(row["D_Type"].ToString())); } } if (row["D_Remark"] != null) { item.D_Remark = row["D_Remark"].ToString(); } if (row["D_CreateUser"] != null) { item.D_CreateUser = row["D_CreateUser"].ToString(); } if (row["D_CreateTime"] != null) { if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString())) { item.D_CreateTime = null; } else { item.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString())); } } if (row["D_ModifyUser"] != null) { item.D_ModifyUser = row["D_ModifyUser"].ToString(); } if (row["D_ModifyTime"] != null) { if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString())) { item.D_ModifyTime = null; } else { item.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString())); } } list.Add(item); } return(list); }
//验证添加是否存在 private bool SysCommon_DictExists(Common_DictModel model) { return(BLL.SysCommon_DictExists(model)); }
public int Update(Common_DictModel model) { return(this.Update(null, model)); }
internal List <Common_DictModel> GetCommon_DictModelListByPage(DbTransaction tran, int pageSize, int pageIndex, string orderColumn, string orderType, string strCondition, params object[] param) { if ((pageSize <= 0) || (pageIndex <= 0)) { throw new Exception("分页参数错误,必须大于零"); } if (string.IsNullOrEmpty(orderColumn)) { throw new Exception("排序字段必须填写"); } int num = ((pageIndex - 1) * pageSize) + 1; int num2 = pageIndex * pageSize; StringBuilder builder = new StringBuilder(); builder.Append(" SELECT * FROM ("); builder.Append(string.Format(" SELECT (ROW_NUMBER() OVER(ORDER BY {0} {1})) as rownum,* FROM Common_Dict", orderColumn, orderType)); if (!string.IsNullOrWhiteSpace(strCondition)) { builder.Append(" WHERE "); builder.Append(strCondition); } builder.Append(" ) t "); builder.Append(" WHERE rownum between "); builder.Append(string.Format(" {0} ", num)); builder.Append(" AND "); builder.Append(string.Format(" {0} ", num2)); DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param); List <Common_DictModel> list = new List <Common_DictModel>(); Common_DictModel item = null; foreach (DataRow row in set.Tables[0].Rows) { item = new Common_DictModel(); if (row["Common_Dict_ID"] != null) { item.Common_Dict_ID = row["Common_Dict_ID"].ToString(); } if (row["D_Name"] != null) { item.D_Name = row["D_Name"].ToString(); } if (row["D_ParentID"] != null) { item.D_ParentID = row["D_ParentID"].ToString(); } if (row["D_Value"] != null) { if (string.IsNullOrWhiteSpace(row["D_Value"].ToString())) { item.D_Value = null; } else { item.D_Value = new int?(int.Parse(row["D_Value"].ToString())); } } if (row["D_Code"] != null) { item.D_Code = row["D_Code"].ToString(); } if (row["D_Order"] != null) { if (string.IsNullOrWhiteSpace(row["D_Order"].ToString())) { item.D_Order = null; } else { item.D_Order = new int?(int.Parse(row["D_Order"].ToString())); } } if (row["D_Type"] != null) { if (string.IsNullOrWhiteSpace(row["D_Type"].ToString())) { item.D_Type = null; } else { item.D_Type = new int?(int.Parse(row["D_Type"].ToString())); } } if (row["D_Remark"] != null) { item.D_Remark = row["D_Remark"].ToString(); } if (row["D_CreateUser"] != null) { item.D_CreateUser = row["D_CreateUser"].ToString(); } if (row["D_CreateTime"] != null) { if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString())) { item.D_CreateTime = null; } else { item.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString())); } } if (row["D_ModifyUser"] != null) { item.D_ModifyUser = row["D_ModifyUser"].ToString(); } if (row["D_ModifyTime"] != null) { if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString())) { item.D_ModifyTime = null; } else { item.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString())); } } list.Add(item); } return(list); }