public Model_SysDepartment DataRowToModel(DataRow row)
{
Model_SysDepartment department = new Model_SysDepartment();
if (row != null)
{
if (row["SysDepartment_ID"] != null)
{
department.SysDepartment_ID = row["SysDepartment_ID"].ToString();
}
if (row["SysDepartment_Name"] != null)
{
department.SysDepartment_Name = row["SysDepartment_Name"].ToString();
}
if (row["SysDepartment_ParentID"] != null)
{
department.SysDepartment_ParentID = row["SysDepartment_ParentID"].ToString();
}
if (row["SysDepartment_Tel"] != null)
{
department.SysDepartment_Tel = row["SysDepartment_Tel"].ToString();
}
if (row["SysUser_ID"] != null)
{
department.SysUser_ID = row["SysUser_ID"].ToString();
}
if ((row["SysDepartment_Enable"] != null) && (row["SysDepartment_Enable"].ToString() != ""))
{
if ((row["SysDepartment_Enable"].ToString() == "1") || (row["SysDepartment_Enable"].ToString().ToLower() == "true"))
{
department.SysDepartment_Enable = true;
}
else
{
department.SysDepartment_Enable = false;
}
}
if (row["SysDepartment_Remark"] != null)
{
department.SysDepartment_Remark = row["SysDepartment_Remark"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
department.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["CreateUser"] != null)
{
department.CreateUser = row["CreateUser"].ToString();
}
if ((row["UpdateTime"] != null) && (row["UpdateTime"].ToString() != ""))
{
department.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
if (row["UpdateUser"] != null)
{
department.UpdateUser = row["UpdateUser"].ToString();
}
}
return(department);
}
public bool Update(Model_SysDepartment model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update SysDepartment set ");
builder.Append("SysDepartment_ID=@SysDepartment_ID,");
builder.Append("SysDepartment_Name=@SysDepartment_Name,");
builder.Append("SysDepartment_ParentID=@SysDepartment_ParentID,");
builder.Append("SysDepartment_Tel=@SysDepartment_Tel,");
builder.Append("SysUser_ID=@SysUser_ID,");
builder.Append("SysDepartment_Enable=@SysDepartment_Enable,");
builder.Append("SysDepartment_Remark=@SysDepartment_Remark,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("CreateUser=@CreateUser,");
builder.Append("UpdateTime=@UpdateTime,");
builder.Append("UpdateUser=@UpdateUser");
builder.Append(" where ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysDepartment_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysDepartment_Name", SqlDbType.NVarChar, 0x80), new SqlParameter("@SysDepartment_ParentID", SqlDbType.Char, 0x24), new SqlParameter("@SysDepartment_Tel", SqlDbType.NVarChar, 20), new SqlParameter("@SysUser_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysDepartment_Enable", SqlDbType.Bit, 1), new SqlParameter("@SysDepartment_Remark", SqlDbType.NVarChar, 0x800), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SysDepartment_ID;
cmdParms[1].Value = model.SysDepartment_Name;
cmdParms[2].Value = model.SysDepartment_ParentID;
cmdParms[3].Value = model.SysDepartment_Tel;
cmdParms[4].Value = model.SysUser_ID;
cmdParms[5].Value = model.SysDepartment_Enable;
cmdParms[6].Value = model.SysDepartment_Remark;
cmdParms[7].Value = model.CreateTime;
cmdParms[8].Value = model.CreateUser;
cmdParms[9].Value = model.UpdateTime;
cmdParms[10].Value = model.UpdateUser;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
// 为实体赋值
private Model_SysDepartment setModel(string ID)
{
Model_SysDepartment mcd;
string type = Request["handel"].ToString();
if (type == "1")//更新方法时setmodel
{
mcd = bll.GetModel_SysDepartmentByPK(ID);
mcd.SysDepartment_Name = TbStepName.Text.Trim();
mcd.SysDepartment_Remark = TbRemark.Text.Trim();
mcd.SysUser_ID = DropDownListUser.SelectedValue;
mcd.SysDepartment_Enable = DropDownListState.SelectedValue == "1" ? true : false;
mcd.SysDepartment_Tel = TbTel.Text.Trim();
mcd.UpdateUser = loginUser.SysUser_ID;
mcd.UpdateTime = DateTime.Now;
}
else //添加方法时setmodel
{
mcd = new Model_SysDepartment();
mcd.SysDepartment_ID = ID;
mcd.SysDepartment_Name = TbStepName.Text.Trim();
mcd.SysDepartment_Remark = TbRemark.Text.Trim();
mcd.SysUser_ID = DropDownListUser.SelectedValue;
mcd.SysDepartment_Enable = DropDownListState.SelectedValue == "1" ? true : false;
mcd.SysDepartment_Tel = TbTel.Text.Trim();
mcd.CreateUser = loginUser.SysUser_ID;
mcd.CreateTime = DateTime.Now;
}
return(mcd);
}
internal int Update(DbTransaction tran, Model_SysDepartment model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" UPDATE ");
builder.Append(" SysDepartment ");
builder.Append(" SET ");
builder.Append(" SysDepartment_ID=@SysDepartment_ID,SysDepartment_Name=@SysDepartment_Name,SysDepartment_ParentID=@SysDepartment_ParentID,SysDepartment_Tel=@SysDepartment_Tel,SysUser_ID=@SysUser_ID,SysDepartment_Enable=@SysDepartment_Enable,SysDepartment_Remark=@SysDepartment_Remark,CreateTime=@CreateTime,CreateUser=@CreateUser,UpdateTime=@UpdateTime,UpdateUser=@UpdateUser ");
builder.Append(" WHERE ");
builder.Append(" SysDepartment_ID=@SysDepartment_ID ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.SysDepartment_ID, model.SysDepartment_Name, model.SysDepartment_ParentID, model.SysDepartment_Tel, model.SysUser_ID, model.SysDepartment_Enable, model.SysDepartment_Remark, model.CreateTime, model.CreateUser, model.UpdateTime, model.UpdateUser }));
}
internal int Add(DbTransaction tran, Model_SysDepartment model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" INSERT INTO ");
builder.Append(" SysDepartment( ");
builder.Append(" SysDepartment_ID,SysDepartment_Name,SysDepartment_ParentID,SysDepartment_Tel,SysUser_ID,SysDepartment_Enable,SysDepartment_Remark,CreateTime,CreateUser,UpdateTime,UpdateUser ");
builder.Append(" ) ");
builder.Append(" values( ");
builder.Append(" @SysDepartment_ID,@SysDepartment_Name,@SysDepartment_ParentID,@SysDepartment_Tel,@SysUser_ID,@SysDepartment_Enable,@SysDepartment_Remark,@CreateTime,@CreateUser,@UpdateTime,@UpdateUser ");
builder.Append(" ) ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.SysDepartment_ID, model.SysDepartment_Name, model.SysDepartment_ParentID, model.SysDepartment_Tel, model.SysUser_ID, model.SysDepartment_Enable, model.SysDepartment_Remark, model.CreateTime, model.CreateUser, model.UpdateTime, model.UpdateUser }));
}
public bool IsOrNotExists(Model_SysDepartment model, int i)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from SysDepartment");
if (i == 0)
{
builder.AppendFormat(" where 1=1 and SysDepartment_ID<>'{0}' AND SysDepartment_Name='{1}'", model.SysDepartment_ID, model.SysDepartment_Name);
}
else
{
builder.AppendFormat(" where 1=1 and SysDepartment_Name='{0}'", model.SysDepartment_Name);
}
return(int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0);
}
public List <Model_SysDepartment> DataTableToList(DataTable dt)
{
List <Model_SysDepartment> list = new List <Model_SysDepartment>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_SysDepartment item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
// 添加方法
private int Add(out string strMessage)
{
int result = 0;
strMessage = string.Empty;
departmentID = Guid.NewGuid().ToString();
Model_SysDepartment sysDepartmentModel = setModel(departmentID);
try
{
if (string.IsNullOrEmpty(sysDepartmentModel.SysDepartment_Name))
{
strMessage = "部门名称不能为空";
}
else
{
if (!IsOrNotExists(sysDepartmentModel, 1))
{
result = bll.Add(sysDepartmentModel);
if (result == 1)
{
StringBuilder strLog = new StringBuilder();
strLog.AppendFormat("【添加部门】【ID】： {0}【部门名】：{1}【负责人ID】：{2} 【联系电话】 ： {3}【部门状态】 ： {4}",
sysDepartmentModel.SysDepartment_ID, sysDepartmentModel.SysDepartment_Name, sysDepartmentModel.SysUser_ID, sysDepartmentModel.SysDepartment_Tel, sysDepartmentModel.SysDepartment_Enable);
}
}
else
{
ShowMsg(2, "此部门名称存在");
}
}
}
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;
}
return(result);
}
public bool Add(Model_SysDepartment model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into SysDepartment(");
builder.Append("SysDepartment_ID,SysDepartment_Name,SysDepartment_ParentID,SysDepartment_Tel,SysUser_ID,SysDepartment_Enable,SysDepartment_Remark,CreateTime,CreateUser,UpdateTime,UpdateUser)");
builder.Append(" values (");
builder.Append("@SysDepartment_ID,@SysDepartment_Name,@SysDepartment_ParentID,@SysDepartment_Tel,@SysUser_ID,@SysDepartment_Enable,@SysDepartment_Remark,@CreateTime,@CreateUser,@UpdateTime,@UpdateUser)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysDepartment_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysDepartment_Name", SqlDbType.NVarChar, 0x80), new SqlParameter("@SysDepartment_ParentID", SqlDbType.Char, 0x24), new SqlParameter("@SysDepartment_Tel", SqlDbType.NVarChar, 20), new SqlParameter("@SysUser_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysDepartment_Enable", SqlDbType.Bit, 1), new SqlParameter("@SysDepartment_Remark", SqlDbType.NVarChar, 0x800), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SysDepartment_ID;
cmdParms[1].Value = model.SysDepartment_Name;
cmdParms[2].Value = model.SysDepartment_ParentID;
cmdParms[3].Value = model.SysDepartment_Tel;
cmdParms[4].Value = model.SysUser_ID;
cmdParms[5].Value = model.SysDepartment_Enable;
cmdParms[6].Value = model.SysDepartment_Remark;
cmdParms[7].Value = model.CreateTime;
cmdParms[8].Value = model.CreateUser;
cmdParms[9].Value = model.UpdateTime;
cmdParms[10].Value = model.UpdateUser;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int Add(Model_SysDepartment model)
{
return(this.Add(null, model));
}
public int Add(Model_SysDepartment model)
{
return this.DAL.Add(model);
}
public int Update(Model_SysDepartment model)
{
return(this.Update(null, model));
}
internal List <Model_SysDepartment> GetModel_SysDepartmentListByPage(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 SysDepartment", 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 <Model_SysDepartment> list = new List <Model_SysDepartment>();
Model_SysDepartment item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Model_SysDepartment();
if (row["SysDepartment_ID"] != null)
{
item.SysDepartment_ID = row["SysDepartment_ID"].ToString();
}
if (row["SysDepartment_Name"] != null)
{
item.SysDepartment_Name = row["SysDepartment_Name"].ToString();
}
if (row["SysDepartment_ParentID"] != null)
{
item.SysDepartment_ParentID = row["SysDepartment_ParentID"].ToString();
}
if (row["SysDepartment_Tel"] != null)
{
item.SysDepartment_Tel = row["SysDepartment_Tel"].ToString();
}
if (row["SysUser_ID"] != null)
{
item.SysUser_ID = row["SysUser_ID"].ToString();
}
if (row["SysDepartment_Enable"] != null)
{
if (string.IsNullOrWhiteSpace(row["SysDepartment_Enable"].ToString()))
{
item.SysDepartment_Enable = null;
}
else if ((row["SysDepartment_Enable"].ToString() == "0") || (row["SysDepartment_Enable"].ToString().ToLower() == "false"))
{
item.SysDepartment_Enable = false;
}
else if ((row["SysDepartment_Enable"].ToString() == "1") || (row["SysDepartment_Enable"].ToString().ToLower() == "true"))
{
item.SysDepartment_Enable = true;
}
}
if (row["SysDepartment_Remark"] != null)
{
item.SysDepartment_Remark = row["SysDepartment_Remark"].ToString();
}
if (row["CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["CreateTime"].ToString()))
{
item.CreateTime = null;
}
else
{
item.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
if (row["CreateUser"] != null)
{
item.CreateUser = row["CreateUser"].ToString();
}
if (row["UpdateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["UpdateTime"].ToString()))
{
item.UpdateTime = null;
}
else
{
item.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
}
if (row["UpdateUser"] != null)
{
item.UpdateUser = row["UpdateUser"].ToString();
}
list.Add(item);
}
return(list);
}
internal List <Model_SysDepartment> GetModel_SysDepartmentList(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(" SysDepartment ");
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 <Model_SysDepartment> list = new List <Model_SysDepartment>();
Model_SysDepartment item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Model_SysDepartment();
if (row["SysDepartment_ID"] != null)
{
item.SysDepartment_ID = row["SysDepartment_ID"].ToString();
}
if (row["SysDepartment_Name"] != null)
{
item.SysDepartment_Name = row["SysDepartment_Name"].ToString();
}
if (row["SysDepartment_ParentID"] != null)
{
item.SysDepartment_ParentID = row["SysDepartment_ParentID"].ToString();
}
if (row["SysDepartment_Tel"] != null)
{
item.SysDepartment_Tel = row["SysDepartment_Tel"].ToString();
}
if (row["SysUser_ID"] != null)
{
item.SysUser_ID = row["SysUser_ID"].ToString();
}
if (row["SysDepartment_Enable"] != null)
{
if (string.IsNullOrWhiteSpace(row["SysDepartment_Enable"].ToString()))
{
item.SysDepartment_Enable = null;
}
else if ((row["SysDepartment_Enable"].ToString() == "0") || (row["SysDepartment_Enable"].ToString().ToLower() == "false"))
{
item.SysDepartment_Enable = false;
}
else if ((row["SysDepartment_Enable"].ToString() == "1") || (row["SysDepartment_Enable"].ToString().ToLower() == "true"))
{
item.SysDepartment_Enable = true;
}
}
if (row["SysDepartment_Remark"] != null)
{
item.SysDepartment_Remark = row["SysDepartment_Remark"].ToString();
}
if (row["CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["CreateTime"].ToString()))
{
item.CreateTime = null;
}
else
{
item.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
if (row["CreateUser"] != null)
{
item.CreateUser = row["CreateUser"].ToString();
}
if (row["UpdateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["UpdateTime"].ToString()))
{
item.UpdateTime = null;
}
else
{
item.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
}
if (row["UpdateUser"] != null)
{
item.UpdateUser = row["UpdateUser"].ToString();
}
list.Add(item);
}
return(list);
}
public bool Update(Model_SysDepartment model)
{
return(this.dal.Update(model));
}
public int Update(Model_SysDepartment model)
{
return this.DAL.Update(model);
}
// 验证存在
public bool IsOrNotExists(Model_SysDepartment model, int i)
{
return(bll.IsOrNotExists(model, i));
}
public bool Add(Model_SysDepartment model)
{
return(this.dal.Add(model));
}
internal Model_SysDepartment GetModel_SysDepartmentByPK(DbTransaction tran, string sysdepartment_id)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
builder.Append(" TOP 1 * ");
builder.Append(" FROM ");
builder.Append(" SysDepartment ");
builder.Append(" WHERE ");
builder.Append(" SysDepartment_ID=@SysDepartment_ID ");
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, new object[] { sysdepartment_id });
Model_SysDepartment department = null;
if (set.Tables[0].Rows.Count > 0)
{
DataRow row = set.Tables[0].Rows[0];
department = new Model_SysDepartment();
if (row["SysDepartment_ID"] != null)
{
department.SysDepartment_ID = row["SysDepartment_ID"].ToString();
}
if (row["SysDepartment_Name"] != null)
{
department.SysDepartment_Name = row["SysDepartment_Name"].ToString();
}
if (row["SysDepartment_ParentID"] != null)
{
department.SysDepartment_ParentID = row["SysDepartment_ParentID"].ToString();
}
if (row["SysDepartment_Tel"] != null)
{
department.SysDepartment_Tel = row["SysDepartment_Tel"].ToString();
}
if (row["SysUser_ID"] != null)
{
department.SysUser_ID = row["SysUser_ID"].ToString();
}
if (row["SysDepartment_Enable"] != null)
{
if (string.IsNullOrWhiteSpace(row["SysDepartment_Enable"].ToString()))
{
department.SysDepartment_Enable = null;
}
else if ((row["SysDepartment_Enable"].ToString() == "0") || (row["SysDepartment_Enable"].ToString().ToLower() == "false"))
{
department.SysDepartment_Enable = false;
}
else if ((row["SysDepartment_Enable"].ToString() == "1") || (row["SysDepartment_Enable"].ToString().ToLower() == "true"))
{
department.SysDepartment_Enable = true;
}
}
if (row["SysDepartment_Remark"] != null)
{
department.SysDepartment_Remark = row["SysDepartment_Remark"].ToString();
}
if (row["CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["CreateTime"].ToString()))
{
department.CreateTime = null;
}
else
{
department.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
if (row["CreateUser"] != null)
{
department.CreateUser = row["CreateUser"].ToString();
}
if (row["UpdateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["UpdateTime"].ToString()))
{
department.UpdateTime = null;
}
else
{
department.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
}
if (row["UpdateUser"] != null)
{
department.UpdateUser = row["UpdateUser"].ToString();
}
}
return(department);
}
public bool IsOrNotExists(Model_SysDepartment model, int i)
{
return this.dal.IsOrNotExists(model, i);
}