public Model_BookshelvesLog DataRowToModel(DataRow row) { Model_BookshelvesLog log = new Model_BookshelvesLog(); if (row != null) { if (row["BookshelvesLog_Id"] != null) { log.BookshelvesLog_Id = row["BookshelvesLog_Id"].ToString(); } if (row["BookId"] != null) { log.BookId = row["BookId"].ToString(); } if (row["LogTypeEnum"] != null) { log.LogTypeEnum = row["LogTypeEnum"].ToString(); } if (row["CreateUser"] != null) { log.CreateUser = row["CreateUser"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { log.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } if (row["LogRemark"] != null) { log.LogRemark = row["LogRemark"].ToString(); } } return(log); }
protected void btnSave_Click(object sender, EventArgs e) { bool result = false; model = bll.GetModel(hidResourceFolder_Id.Value); bool isUpate = true; if (model == null) { isUpate = false; model = new Model_Bookshelves(); model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; model.ResourceFolder_Id = hidResourceFolder_Id.Value; } string savePath = Server.MapPath("~/Upload/BookCover/");//指定上传文件在服务器上的保存路径 if (fpBookImg_Url.HasFile) { //检查服务器上是否存在这个物理路径,如果不存在则创建 if (!System.IO.Directory.Exists(savePath)) { System.IO.Directory.CreateDirectory(savePath); } string strFileName = Guid.NewGuid().ToString(); string strExt = Path.GetExtension(fpBookImg_Url.PostedFile.FileName); savePath = savePath + "\\" + strFileName + strExt; fpBookImg_Url.SaveAs(savePath); model.BookImg_Url = "/Upload/BookCover/" + strFileName + strExt; } model.Book_Name = hidBook_Name.Value; model.BookPrice = Convert.ToDecimal(txtBookPrice.Text); model.BookShelvesState = "1"; model.PutUpTime = DateTime.Now; model.BookBrief = BookBrief.Value; if (isUpate) { result = bll.Update(model); } else { result = bll.Add(model); } Model_BookshelvesLog modelLog = new Model_BookshelvesLog(); modelLog.BookshelvesLog_Id = Guid.NewGuid().ToString(); modelLog.BookId = model.ResourceFolder_Id; modelLog.LogTypeEnum = "1"; modelLog.CreateUser = loginUser.SysUser_ID; modelLog.CreateTime = DateTime.Now; new BLL_BookshelvesLog().Add(modelLog); ShowMsg(result == true ? 1 : 0, result == true ? "保存成功。" : "保存失败。"); }
public bool Add(Model_BookshelvesLog model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into BookshelvesLog("); builder.Append("BookshelvesLog_Id,BookId,LogTypeEnum,CreateUser,CreateTime,LogRemark)"); builder.Append(" values ("); builder.Append("@BookshelvesLog_Id,@BookId,@LogTypeEnum,@CreateUser,@CreateTime,@LogRemark)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@BookshelvesLog_Id", SqlDbType.Char, 0x24), new SqlParameter("@BookId", SqlDbType.Char, 0x24), new SqlParameter("@LogTypeEnum", SqlDbType.Char, 1), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@LogRemark", SqlDbType.NVarChar, 200) }; cmdParms[0].Value = model.BookshelvesLog_Id; cmdParms[1].Value = model.BookId; cmdParms[2].Value = model.LogTypeEnum; cmdParms[3].Value = model.CreateUser; cmdParms[4].Value = model.CreateTime; cmdParms[5].Value = model.LogRemark; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <Model_BookshelvesLog> DataTableToList(DataTable dt) { List <Model_BookshelvesLog> list = new List <Model_BookshelvesLog>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_BookshelvesLog item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Update(Model_BookshelvesLog model) { StringBuilder builder = new StringBuilder(); builder.Append("update BookshelvesLog set "); builder.Append("BookId=@BookId,"); builder.Append("LogTypeEnum=@LogTypeEnum,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("CreateTime=@CreateTime,"); builder.Append("LogRemark=@LogRemark"); builder.Append(" where BookshelvesLog_Id=@BookshelvesLog_Id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@BookId", SqlDbType.Char, 0x24), new SqlParameter("@LogTypeEnum", SqlDbType.Char, 1), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@LogRemark", SqlDbType.NVarChar, 200), new SqlParameter("@BookshelvesLog_Id", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.BookId; cmdParms[1].Value = model.LogTypeEnum; cmdParms[2].Value = model.CreateUser; cmdParms[3].Value = model.CreateTime; cmdParms[4].Value = model.LogRemark; cmdParms[5].Value = model.BookshelvesLog_Id; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public static string SetBookShelvesState(string id) { try { BLL_Bookshelves bll = new BLL_Bookshelves(); Model_Bookshelves model = bll.GetModel(id); model.BookShelvesState = "0"; model.PutDownTime = DateTime.Now; bool inum = bll.Update(model); if (inum) { Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"]; Model_BookshelvesLog modelLog = new Model_BookshelvesLog(); modelLog.BookshelvesLog_Id = Guid.NewGuid().ToString(); modelLog.BookId = model.ResourceFolder_Id; modelLog.LogTypeEnum = "2"; modelLog.CreateUser = loginUser.SysUser_ID; modelLog.CreateTime = DateTime.Now; new BLL_BookshelvesLog().Add(modelLog); return(JsonConvert.SerializeObject(new { err = "null" })); } else { return(JsonConvert.SerializeObject(new { err = "" })); } } catch (Exception) { return(JsonConvert.SerializeObject(new { err = "error"//ex.Message.ToString() })); } }
public bool Add(Model_BookshelvesLog model) { return(this.dal.Add(model)); }
public bool Update(Model_BookshelvesLog model) { return(this.dal.Update(model)); }