/// <summary> /// datarow转成对象实体 /// </summary> public BWJS.Model.DepartmentInfo DataRowToModel(DataRow row) { BWJS.Model.DepartmentInfo model = new BWJS.Model.DepartmentInfo(); if (row != null) { if (row["DepartmentID"].ToString() != "") { model.DepartmentID = int.Parse(row["DepartmentID"].ToString()); } if (row["ParentID"].ToString() != "") { model.ParentID = int.Parse(row["ParentID"].ToString()); } model.DepartmentCode = row["DepartmentCode"].ToString(); model.Remark = row["Remark"].ToString(); model.DepartmentName = row["DepartmentName"].ToString(); if (row["CreatedUser"].ToString() != "") { model.CreatedUser = int.Parse(row["CreatedUser"].ToString()); } if (row["RecordIsDelete"].ToString() != "" && (row["RecordIsDelete"].ToString().ToLower() == "false")) { model.RecordIsDelete = false; } else { model.RecordIsDelete = true; } if (row["RecordCreateTime"].ToString() != "") { model.RecordCreateTime = DateTime.Parse(row["RecordCreateTime"].ToString()); } if (row["RecordUpdateTime"].ToString() != "") { model.RecordUpdateTime = DateTime.Parse(row["RecordUpdateTime"].ToString()); } if (row["IsReceiveBusiness"].ToString() != "" && row["IsReceiveBusiness"].ToString().ToLower() == "true") { model.IsReceiveBusiness = true; } else { model.IsReceiveBusiness = false; } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.DepartmentInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DepartmentInfo("); strSql.Append(@"DepartmentName , ParentID , DepartmentCode , Remark , IsReceiveBusiness , CreatedUser , RecordIsDelete , RecordCreateTime , RecordUpdateTime"); strSql.Append(") values ("); strSql.Append(@"@DepartmentName , @ParentID , @DepartmentCode , @Remark , @IsReceiveBusiness , @CreatedUser , @RecordIsDelete , @RecordCreateTime , @RecordUpdateTime"); strSql.Append(") "); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@DepartmentName", model.DepartmentName), new SqlParameter("@ParentID", model.ParentID), new SqlParameter("@DepartmentCode", model.DepartmentCode), new SqlParameter("@Remark", model.Remark), new SqlParameter("@IsReceiveBusiness", model.IsReceiveBusiness), new SqlParameter("@CreatedUser", model.CreatedUser), new SqlParameter("@RecordIsDelete", model.RecordIsDelete), new SqlParameter("@RecordCreateTime", model.RecordCreateTime), new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime) }; object obj = BWJSHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJS.Model.DepartmentInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [DepartmentInfo] set "); strSql.Append(" DepartmentName = @DepartmentName , "); strSql.Append(" ParentID = @ParentID , "); strSql.Append(" DepartmentCode = @DepartmentCode , "); strSql.Append(" Remark = @Remark , "); strSql.Append(" UpdateUser = @UpdateUser , "); strSql.Append(" IsReceiveBusiness = @IsReceiveBusiness , "); strSql.Append(" RecordIsDelete = @RecordIsDelete , "); strSql.Append(" RecordUpdateTime = @RecordUpdateTime "); strSql.Append(" where DepartmentID=@DepartmentID "); SqlParameter[] parameters = { new SqlParameter("@DepartmentID", model.DepartmentID), new SqlParameter("@DepartmentName", model.DepartmentName), new SqlParameter("@ParentID", model.ParentID), new SqlParameter("@DepartmentCode", model.DepartmentCode), new SqlParameter("@Remark", model.Remark), new SqlParameter("@UpdateUser", model.UpdateUser), new SqlParameter("@IsReceiveBusiness", model.IsReceiveBusiness), new SqlParameter("@RecordIsDelete", model.RecordIsDelete), new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime) }; int rows = BWJSHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BWJS.Model.DepartmentInfo GetModel(int DepartmentID) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select DepartmentID , DepartmentName , ParentID , IsReceiveBusiness , DepartmentCode , Remark , UpdateUser , CreatedUser , RecordIsDelete , RecordCreateTime , RecordUpdateTime "); strSql.Append(" from DepartmentInfo "); strSql.Append(" where DepartmentID=@DepartmentID"); SqlParameter[] parameters = { new SqlParameter("@DepartmentID", SqlDbType.Int, 4) }; parameters[0].Value = DepartmentID; BWJS.Model.DepartmentInfo model = new BWJS.Model.DepartmentInfo(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BWJS.Model.DepartmentInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWJS.Model.DepartmentInfo model) { return(dal.Add(model)); }