public Model_BookAttrbute DataRowToModel(DataRow row) { Model_BookAttrbute attrbute = new Model_BookAttrbute(); if (row != null) { if (row["BookAttrId"] != null) { attrbute.BookAttrId = row["BookAttrId"].ToString(); } if (row["ResourceFolder_Id"] != null) { attrbute.ResourceFolder_Id = row["ResourceFolder_Id"].ToString(); } if (row["AttrEnum"] != null) { attrbute.AttrEnum = row["AttrEnum"].ToString(); } if (row["AttrValue"] != null) { attrbute.AttrValue = row["AttrValue"].ToString(); } if (row["CreateUser"] != null) { attrbute.CreateUser = row["CreateUser"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { attrbute.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } } return(attrbute); }
public bool Add(Model_BookAttrbute model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into BookAttrbute("); builder.Append("BookAttrId,ResourceFolder_Id,AttrEnum,AttrValue,CreateUser,CreateTime)"); builder.Append(" values ("); builder.Append("@BookAttrId,@ResourceFolder_Id,@AttrEnum,@AttrValue,@CreateUser,@CreateTime)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@BookAttrId", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@AttrEnum", SqlDbType.VarChar, 50), new SqlParameter("@AttrValue", SqlDbType.VarChar, 10), new SqlParameter("@CreateUser", SqlDbType.NVarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; cmdParms[0].Value = model.BookAttrId; cmdParms[1].Value = model.ResourceFolder_Id; cmdParms[2].Value = model.AttrEnum; cmdParms[3].Value = model.AttrValue; cmdParms[4].Value = model.CreateUser; cmdParms[5].Value = model.CreateTime; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <Model_BookAttrbute> DataTableToList(DataTable dt) { List <Model_BookAttrbute> list = new List <Model_BookAttrbute>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_BookAttrbute item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Update(Model_BookAttrbute model) { StringBuilder builder = new StringBuilder(); builder.Append("update BookAttrbute set "); builder.Append("ResourceFolder_Id=@ResourceFolder_Id,"); builder.Append("AttrEnum=@AttrEnum,"); builder.Append("AttrValue=@AttrValue,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("CreateTime=@CreateTime"); builder.Append(" where BookAttrId=@BookAttrId "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@AttrEnum", SqlDbType.VarChar, 50), new SqlParameter("@AttrValue", SqlDbType.VarChar, 10), new SqlParameter("@CreateUser", SqlDbType.NVarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@BookAttrId", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.ResourceFolder_Id; cmdParms[1].Value = model.AttrEnum; cmdParms[2].Value = model.AttrValue; cmdParms[3].Value = model.CreateUser; cmdParms[4].Value = model.CreateTime; cmdParms[5].Value = model.BookAttrId; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public static string OperateResourceAuth(string AttrEnum, string ReId, string AttrValue) { string temp = "0"; try { Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"]; BLL_BookAttrbute bll = new BLL_BookAttrbute(); Model_BookAttrbute model = new Model_BookAttrbute(); List <Model_BookAttrbute> list = bll.GetModelList("ResourceFolder_Id='" + ReId + "' and AttrEnum='" + AttrEnum + "' "); bool result = false; if (list.Count != 0) { model = list[0]; model.AttrValue = AttrValue; model.CreateTime = DateTime.Now; result = bll.Update(model); } else { model.BookAttrId = Guid.NewGuid().ToString(); model.ResourceFolder_Id = ReId; model.AttrEnum = AttrEnum; model.AttrValue = AttrValue; model.CreateUser = loginUser.SysUser_ID; model.CreateTime = DateTime.Now; result = bll.Add(model); } if (result) { temp = "1"; } } catch (Exception) { } return(temp); }
public bool Update(Model_BookAttrbute model) { return(this.dal.Update(model)); }
public bool Add(Model_BookAttrbute model) { return(this.dal.Add(model)); }