public List <Model_BookArea> DataTableToList(DataTable dt) { List <Model_BookArea> list = new List <Model_BookArea>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_BookArea item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(Model_BookArea model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into BookArea("); builder.Append("BookArea_ID,ResourceFolder_Id,Book_Name,Province_ID,City_ID,County_ID,CreateTime,CreateUser)"); builder.Append(" values ("); builder.Append("@BookArea_ID,@ResourceFolder_Id,@Book_Name,@Province_ID,@City_ID,@County_ID,@CreateTime,@CreateUser)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@BookArea_ID", SqlDbType.Char, 0x24), new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@Book_Name", SqlDbType.NVarChar, 100), new SqlParameter("@Province_ID", SqlDbType.Char, 0x24), new SqlParameter("@City_ID", SqlDbType.Char, 0x24), new SqlParameter("@County_ID", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.BookArea_ID; cmdParms[1].Value = model.ResourceFolder_Id; cmdParms[2].Value = model.Book_Name; cmdParms[3].Value = model.Province_ID; cmdParms[4].Value = model.City_ID; cmdParms[5].Value = model.County_ID; cmdParms[6].Value = model.CreateTime; cmdParms[7].Value = model.CreateUser; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_BookArea DataRowToModel(DataRow row) { Model_BookArea area = new Model_BookArea(); if (row != null) { if (row["BookArea_ID"] != null) { area.BookArea_ID = row["BookArea_ID"].ToString(); } if (row["ResourceFolder_Id"] != null) { area.ResourceFolder_Id = row["ResourceFolder_Id"].ToString(); } if (row["Book_Name"] != null) { area.Book_Name = row["Book_Name"].ToString(); } if (row["Province_ID"] != null) { area.Province_ID = row["Province_ID"].ToString(); } if (row["City_ID"] != null) { area.City_ID = row["City_ID"].ToString(); } if (row["County_ID"] != null) { area.County_ID = row["County_ID"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { area.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } if (row["CreateUser"] != null) { area.CreateUser = row["CreateUser"].ToString(); } } return(area); }
public bool Update(Model_BookArea model) { StringBuilder builder = new StringBuilder(); builder.Append("update BookArea set "); builder.Append("ResourceFolder_Id=@ResourceFolder_Id,"); builder.Append("Book_Name=@Book_Name,"); builder.Append("Province_ID=@Province_ID,"); builder.Append("City_ID=@City_ID,"); builder.Append("County_ID=@County_ID,"); builder.Append("CreateTime=@CreateTime,"); builder.Append("CreateUser=@CreateUser"); builder.Append(" where BookArea_ID=@BookArea_ID "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@Book_Name", SqlDbType.NVarChar, 100), new SqlParameter("@Province_ID", SqlDbType.Char, 0x24), new SqlParameter("@City_ID", SqlDbType.Char, 0x24), new SqlParameter("@County_ID", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@BookArea_ID", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.ResourceFolder_Id; cmdParms[1].Value = model.Book_Name; cmdParms[2].Value = model.Province_ID; cmdParms[3].Value = model.City_ID; cmdParms[4].Value = model.County_ID; cmdParms[5].Value = model.CreateTime; cmdParms[6].Value = model.CreateUser; cmdParms[7].Value = model.BookArea_ID; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
protected void btnSave_Click(object sender, EventArgs e) { try { List <Model_BookArea> listM = new List <Model_BookArea>(); string[] strArr = hidAreaIds.Value.Split(','); for (int i = 0; i < strArr.Length; i++) { string[] strAreaId = strArr[i].Split('^'); Model_BookArea model = new Model_BookArea(); model.BookArea_ID = Guid.NewGuid().ToString(); model.ResourceFolder_Id = bid; model.Book_Name = bname; model.Province_ID = strAreaId[0]; if (strAreaId.Length > 1) { model.City_ID = strAreaId[1]; } model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; listM.Add(model); } if (new BLL_BookArea().AddModelList(bid, listM) > 0) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>$(function(){ Handel('1','操作成功')});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>$(function(){ Handel('2','操作失败')});</script>"); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>$(function(){ Handel('2','" + ex.Message + "')});</script>"); } }
public bool Add(Model_BookArea model) { return(this.dal.Add(model)); }
public bool Update(Model_BookArea model) { return(this.dal.Update(model)); }