/// <summary> /// 更新一条数据 /// </summary> public void Update(MesWeb.Model.T_Department model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("T_Department_Update"); db.AddInParameter(dbCommand, "DepartmentID", DbType.Int32, model.DepartmentID); db.AddInParameter(dbCommand, "DepartmentName", DbType.String, model.DepartmentName); db.AddInParameter(dbCommand, "DepartmentContactPerson", DbType.String, model.DepartmentContactPerson); db.AddInParameter(dbCommand, "DepartmentTel", DbType.String, model.DepartmentTel); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(MesWeb.Model.T_Department model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("T_Department_ADD"); db.AddOutParameter(dbCommand, "DepartmentID", DbType.Int32, 4); db.AddInParameter(dbCommand, "DepartmentName", DbType.String, model.DepartmentName); db.AddInParameter(dbCommand, "DepartmentContactPerson", DbType.String, model.DepartmentContactPerson); db.AddInParameter(dbCommand, "DepartmentTel", DbType.String, model.DepartmentTel); db.ExecuteNonQuery(dbCommand); return((int)db.GetParameterValue(dbCommand, "DepartmentID")); }
/// <summary> /// 对象实体绑定数据 /// </summary> public MesWeb.Model.T_Department ReaderBind(IDataReader dataReader) { MesWeb.Model.T_Department model = new MesWeb.Model.T_Department(); object ojb; ojb = dataReader["DepartmentID"]; if (ojb != null && ojb != DBNull.Value) { model.DepartmentID = (int)ojb; } model.DepartmentName = dataReader["DepartmentName"].ToString(); model.DepartmentContactPerson = dataReader["DepartmentContactPerson"].ToString(); model.DepartmentTel = dataReader["DepartmentTel"].ToString(); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public MesWeb.Model.T_Department GetModel(int DepartmentID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("T_Department_GetModel"); db.AddInParameter(dbCommand, "DepartmentID", DbType.Int32, DepartmentID); MesWeb.Model.T_Department model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
public JsonResult AddDepartment(MesWeb.Model.T_Department dept) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); var retData = new VM_Result_Data(); if (!string.IsNullOrEmpty(dept.DepartmentName)) { var allDeptList = bllDept.DataTableToList(bllDept.GetAllList().Tables[0]); foreach (var findDept in allDeptList) { if (findDept.DepartmentName.Trim() == dept.DepartmentName.Trim()) { retData.Content = "该部门已存在"; return(Json(retData)); } } try { if (bllDept.Add(dept) > 0) { retData.Code = RESULT_CODE.OK; retData.Content = "添加部门成功"; } else { retData.Content = "添加部门失败"; } } catch (Exception e) { retData.Content = "系统错误"; log.Error("添加部门时,数据库发生错误", e); } } else { retData.Content = "字段验证失败"; } return(Json(retData)); }
/// <summary> /// 得到一个对象实体 /// </summary> public MesWeb.Model.T_Department DataRowToModel(DataRow row) { MesWeb.Model.T_Department model = new MesWeb.Model.T_Department(); if (row != null) { if (row["DepartmentID"] != null && row["DepartmentID"].ToString() != "") { model.DepartmentID = int.Parse(row["DepartmentID"].ToString()); } if (row["DepartmentName"] != null) { model.DepartmentName = row["DepartmentName"].ToString(); } if (row["DepartmentContactPerson"] != null) { model.DepartmentContactPerson = row["DepartmentContactPerson"].ToString(); } if (row["DepartmentTel"] != null) { model.DepartmentTel = row["DepartmentTel"].ToString(); } } return(model); }