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));
}
