protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string idx = Request["Idx"];
if (!String.IsNullOrEmpty(idx))
{
DBEntity.Tab_xw_FlashItem ent = new DBEntity.Tab_xw_FlashItem();
ent = ent.Get(idx);
this.aTitle.Text = ent.aTitle;
this.Image1.ImageUrl = string.Format("~/upload/Advertisement/{0}", ent.aImg);
this.aOrderNumb.Text = ent.aOrderNumb.ToString();
this.aTypeName.Text = ent.aTypeName.ToString();
this.hiddenFileName.Value = ent.aImg;
ltlPageTitle.Text = "Flash广告-编辑";
}
else
{
ltlPageTitle.Text = "Flash广告-添加";
}
}
}
private static Tab_xw_FlashItem ToModel(DataRow row)
{
Tab_xw_FlashItem model = new Tab_xw_FlashItem();
model.Idx = row.IsNull("Idx") ? null : (System.Int32?)row["Idx"];
model.aTitle = row.IsNull("aTitle") ? null : (System.String)row["aTitle"];
model.aLink = row.IsNull("aLink") ? null : (System.String)row["aLink"];
model.aImg = row.IsNull("aImg") ? null : (System.String)row["aImg"];
model.aTypeName = row.IsNull("aTypeName") ? null : (System.String)row["aTypeName"];
model.aCreatedate = row.IsNull("aCreatedate") ? null : (System.DateTime?)row["aCreatedate"];
model.aOrderNumb = row.IsNull("aOrderNumb") ? null : (System.Int32?)row["aOrderNumb"];
return(model);
}
public int AddNew(Tab_xw_FlashItem model)
{
string sql = "insert into Tab_xw_FlashItem(aTitle,aLink,aImg,aTypeName,aCreatedate,aOrderNumb) values(@aTitle,@aLink,@aImg,@aTypeName,@aCreatedate,@aOrderNumb); select @@identity ;";
int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql
, new SqlParameter("@aTitle", model.aTitle)
, new SqlParameter("@aLink", model.aLink)
, new SqlParameter("@aImg", model.aImg)
, new SqlParameter("@aTypeName", model.aTypeName)
, new SqlParameter("@aCreatedate", model.aCreatedate)
, new SqlParameter("@aOrderNumb", model.aOrderNumb)
));
return(Idx);
}
public bool Update(Tab_xw_FlashItem model)
{
string sql = "update Tab_xw_FlashItem set aTitle=@aTitle,aLink=@aLink,aImg=@aImg,aTypeName=@aTypeName,aCreatedate=@aCreatedate,aOrderNumb=@aOrderNumb where Idx=@Idx";
int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql
, new SqlParameter("@aTitle", model.aTitle)
, new SqlParameter("@aLink", model.aLink)
, new SqlParameter("@aImg", model.aImg)
, new SqlParameter("@aTypeName", model.aTypeName)
, new SqlParameter("@aCreatedate", model.aCreatedate)
, new SqlParameter("@aOrderNumb", model.aOrderNumb)
, new SqlParameter("Idx", model.Idx)
);
return(rows > 0);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string fileName = this.hiddenFileName.Value;
if (myFileUpload.HasFile)
{
Cmn.uploadFile upF = new Cmn.uploadFile();
string[] allowExtensions = { ".jpg", ".gif", ".png" };
int maxSize = Convert.ToInt32(Cmn.WebConfig.getApp("app_MaxSizeUpload"));
string savePath = Request.MapPath("~/upload/Advertisement/");
fileName = Cmn.Date.ToDateStr2(DateTime.Now) + "_" + Cmn.Rand.GetGuid() + "." + Cmn.Str.GetFileExtends(myFileUpload.FileName);
try
{
upF.Upload(this.myFileUpload, allowExtensions, maxSize, savePath, fileName);
}
catch (Exception exp)
{
Cmn.Js.ShowAlert(exp.Message);
return;
}
}
string idx = Request["Idx"];
DBEntity.Tab_xw_FlashItem ent = new DBEntity.Tab_xw_FlashItem();
ent.aTitle = this.aTitle.Text;
ent.aLink = this.aLink.Text;
ent.aImg = fileName;
ent.aOrderNumb = Convert.ToInt32(this.aOrderNumb.Text);
ent.aTypeName = this.aTypeName.Text;
ent.aCreatedate = DateTime.Now;
if (string.IsNullOrEmpty(idx))
{
ent.AddNew(ent);
}
else
{
ent.Idx = Convert.ToInt32(idx);
ent.Update(ent);
}
Cmn.Js.ShowAlert("操作成功！");
Cmn.Js.ExeScript("location.href='xwFlashItemManage.aspx'");
}
public Tab_xw_FlashItem Get(string Idx)
{
DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_xw_FlashItem where Idx=@Idx",
new SqlParameter("Idx", Idx)).Tables[0];
if (dt.Rows.Count > 1)
{
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
Tab_xw_FlashItem model = ToModel(row);
return(model);
}
