protected void btnSave_Click(object sender, EventArgs e)
{
bool result = false;
model = bll.GetModel(rid);
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;
}
result = bll.Update(model);
ShowMsg(result == true ? 1 : 0, result == true ? "保存成功。" : "保存失败。");
}
public bool Update(Model_Bookshelves model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Bookshelves set ");
builder.Append("Book_Name=@Book_Name,");
builder.Append("BookImg_Url=@BookImg_Url,");
builder.Append("BookPrice=@BookPrice,");
builder.Append("BookShelvesState=@BookShelvesState,");
builder.Append("PutUpTime=@PutUpTime,");
builder.Append("PutDownTime=@PutDownTime,");
builder.Append("CreateUser=@CreateUser,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("BookBrief=@BookBrief");
builder.Append(" where ResourceFolder_Id=@ResourceFolder_Id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Book_Name", SqlDbType.NVarChar, 100), new SqlParameter("@BookImg_Url", SqlDbType.VarChar, 500), new SqlParameter("@BookPrice", SqlDbType.Decimal, 5), new SqlParameter("@BookShelvesState", SqlDbType.Char, 1), new SqlParameter("@PutUpTime", SqlDbType.DateTime), new SqlParameter("@PutDownTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@BookBrief", SqlDbType.Text), new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.Book_Name;
cmdParms[1].Value = model.BookImg_Url;
cmdParms[2].Value = model.BookPrice;
cmdParms[3].Value = model.BookShelvesState;
cmdParms[4].Value = model.PutUpTime;
cmdParms[5].Value = model.PutDownTime;
cmdParms[6].Value = model.CreateUser;
cmdParms[7].Value = model.CreateTime;
cmdParms[8].Value = model.BookBrief;
cmdParms[9].Value = model.ResourceFolder_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
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 Model_Bookshelves DataRowToModel(DataRow row)
{
Model_Bookshelves bookshelves = new Model_Bookshelves();
if (row != null)
{
if (row["ResourceFolder_Id"] != null)
{
bookshelves.ResourceFolder_Id = row["ResourceFolder_Id"].ToString();
}
if (row["Book_Name"] != null)
{
bookshelves.Book_Name = row["Book_Name"].ToString();
}
if (row["BookImg_Url"] != null)
{
bookshelves.BookImg_Url = row["BookImg_Url"].ToString();
}
if ((row["BookPrice"] != null) && (row["BookPrice"].ToString() != ""))
{
bookshelves.BookPrice = new decimal?(decimal.Parse(row["BookPrice"].ToString()));
}
if (row["BookShelvesState"] != null)
{
bookshelves.BookShelvesState = row["BookShelvesState"].ToString();
}
if ((row["PutUpTime"] != null) && (row["PutUpTime"].ToString() != ""))
{
bookshelves.PutUpTime = new DateTime?(DateTime.Parse(row["PutUpTime"].ToString()));
}
if ((row["PutDownTime"] != null) && (row["PutDownTime"].ToString() != ""))
{
bookshelves.PutDownTime = new DateTime?(DateTime.Parse(row["PutDownTime"].ToString()));
}
if (row["CreateUser"] != null)
{
bookshelves.CreateUser = row["CreateUser"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
bookshelves.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["BookBrief"] != null)
{
bookshelves.BookBrief = row["BookBrief"].ToString();
}
}
return(bookshelves);
}
public List <Model_Bookshelves> DataTableToList(DataTable dt)
{
List <Model_Bookshelves> list = new List <Model_Bookshelves>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_Bookshelves item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
private void isit_load()
{
model = new Model_Bookshelves();
model = bll.GetModel(rid);
if (model != null)
{
if (File.Exists(Server.MapPath(model.BookImg_Url)))
{
Image1.ImageUrl = model.BookImg_Url;
}
else
{
Image1.Visible = false;
}
}
else
{
Image1.Visible = false;
}
}
public bool Add(Model_Bookshelves model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Bookshelves(");
builder.Append("ResourceFolder_Id,Book_Name,BookImg_Url,BookPrice,BookShelvesState,PutUpTime,PutDownTime,CreateUser,CreateTime,BookBrief)");
builder.Append(" values (");
builder.Append("@ResourceFolder_Id,@Book_Name,@BookImg_Url,@BookPrice,@BookShelvesState,@PutUpTime,@PutDownTime,@CreateUser,@CreateTime,@BookBrief)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@Book_Name", SqlDbType.NVarChar, 100), new SqlParameter("@BookImg_Url", SqlDbType.VarChar, 500), new SqlParameter("@BookPrice", SqlDbType.Decimal, 5), new SqlParameter("@BookShelvesState", SqlDbType.Char, 1), new SqlParameter("@PutUpTime", SqlDbType.DateTime), new SqlParameter("@PutDownTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@BookBrief", SqlDbType.Text) };
cmdParms[0].Value = model.ResourceFolder_Id;
cmdParms[1].Value = model.Book_Name;
cmdParms[2].Value = model.BookImg_Url;
cmdParms[3].Value = model.BookPrice;
cmdParms[4].Value = model.BookShelvesState;
cmdParms[5].Value = model.PutUpTime;
cmdParms[6].Value = model.PutDownTime;
cmdParms[7].Value = model.CreateUser;
cmdParms[8].Value = model.CreateTime;
cmdParms[9].Value = model.BookBrief;
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()
}));
}
}
private void isit_load()
{
hidBook_Name.Value = Request.QueryString["bookname"];
hidResourceFolder_Id.Value = Request.QueryString["bookid"];
model = new Model_Bookshelves();
model = bll.GetModel(hidResourceFolder_Id.Value);
if (model != null)
{
if (File.Exists(Server.MapPath(model.BookImg_Url)))
{
Image1.ImageUrl = model.BookImg_Url;
}
else
{
Image1.Visible = false;
}
txtBookPrice.Text = model.BookPrice.ToString();
BookBrief.Value = model.BookBrief;
}
else
{
Image1.Visible = false;
}
}
public bool Add(Model_Bookshelves model)
{
return(this.dal.Add(model));
}
public bool Update(Model_Bookshelves model)
{
return(this.dal.Update(model));
}
