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