/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_bannerimage DataRowToModel(DataRow row)
{
LingLong.Admin.Model.t_bannerimage model = new LingLong.Admin.Model.t_bannerimage();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["BannerTitle"] != null)
{
model.BannerTitle = row["BannerTitle"].ToString();
}
if (row["ClickStatus"] != null && row["ClickStatus"].ToString() != "")
{
model.ClickStatus = int.Parse(row["ClickStatus"].ToString());
}
if (row["ImgUrl"] != null && row["ImgUrl"].ToString() != "")
{
model.ImgUrl = row["ImgUrl"].ToString();
}
if (row["ClickTrunOnUrl"] != null)
{
model.ClickTrunOnUrl = row["ClickTrunOnUrl"].ToString();
}
if (row["UpOnLineTime"] != null && row["UpOnLineTime"].ToString() != "")
{
model.UpOnLineTime = DateTime.Parse(row["UpOnLineTime"].ToString());
}
if (row["DownOnLimeTime"] != null && row["DownOnLimeTime"].ToString() != "")
{
model.DownOnLimeTime = DateTime.Parse(row["DownOnLimeTime"].ToString());
}
if (row["IsDeleted"] != null && row["IsDeleted"].ToString() != "")
{
model.IsDeleted = int.Parse(row["IsDeleted"].ToString());
}
if (row["DeleterUserId"] != null && row["DeleterUserId"].ToString() != "")
{
model.DeleterUserId = long.Parse(row["DeleterUserId"].ToString());
}
if (row["LastModificationTime"] != null && row["LastModificationTime"].ToString() != "")
{
model.LastModificationTime = DateTime.Parse(row["LastModificationTime"].ToString());
}
if (row["LastModifierUserId"] != null && row["LastModifierUserId"].ToString() != "")
{
model.LastModifierUserId = long.Parse(row["LastModifierUserId"].ToString());
}
if (row["CreationTime"] != null && row["CreationTime"].ToString() != "")
{
model.CreationTime = DateTime.Parse(row["CreationTime"].ToString());
}
if (row["CreatorUserId"] != null && row["CreatorUserId"].ToString() != "")
{
model.CreatorUserId = long.Parse(row["CreatorUserId"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LingLong.Admin.Model.t_bannerimage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_bannerimage set ");
strSql.Append("BannerTitle=@BannerTitle,");
strSql.Append("ClickStatus=@ClickStatus,");
strSql.Append("ImgUrl=@ImgUrl,");
strSql.Append("ClickTrunOnUrl=@ClickTrunOnUrl,");
strSql.Append("UpOnLineTime=@UpOnLineTime,");
strSql.Append("DownOnLimeTime=@DownOnLimeTime,");
strSql.Append("IsDeleted=@IsDeleted,");
strSql.Append("DeleterUserId=@DeleterUserId,");
strSql.Append("LastModificationTime=@LastModificationTime,");
strSql.Append("LastModifierUserId=@LastModifierUserId,");
strSql.Append("CreationTime=@CreationTime,");
strSql.Append("CreatorUserId=@CreatorUserId");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@BannerTitle", MySqlDbType.VarChar, 256),
new MySqlParameter("@ClickStatus", MySqlDbType.Int32, 11),
new MySqlParameter("@ImgUrl", MySqlDbType.VarChar, 2048),
new MySqlParameter("@ClickTrunOnUrl", MySqlDbType.VarChar, 2048),
new MySqlParameter("@UpOnLineTime", MySqlDbType.DateTime),
new MySqlParameter("@DownOnLimeTime", MySqlDbType.DateTime),
new MySqlParameter("@IsDeleted", MySqlDbType.Int32),
new MySqlParameter("@DeleterUserId", MySqlDbType.Int32),
new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime),
new MySqlParameter("@LastModifierUserId", MySqlDbType.Int32),
new MySqlParameter("@CreationTime", MySqlDbType.DateTime),
new MySqlParameter("@CreatorUserId", MySqlDbType.Int32),
new MySqlParameter("@ID", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.BannerTitle;
parameters[1].Value = model.ClickStatus;
parameters[2].Value = model.ImgUrl;
parameters[3].Value = model.ClickTrunOnUrl;
parameters[4].Value = model.UpOnLineTime;
parameters[5].Value = model.DownOnLimeTime;
parameters[6].Value = model.IsDeleted;
parameters[7].Value = model.DeleterUserId;
parameters[8].Value = model.LastModificationTime;
parameters[9].Value = model.LastModifierUserId;
parameters[10].Value = model.CreationTime;
parameters[11].Value = model.CreatorUserId;
parameters[12].Value = model.ID;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(LingLong.Admin.Model.t_bannerimage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_bannerimage(");
strSql.Append("BannerTitle,ClickStatus,ImgUrl,ClickTrunOnUrl,UpOnLineTime,DownOnLimeTime,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId)");
strSql.Append(" values (");
strSql.Append("@BannerTitle,@ClickStatus,@ImgUrl,@ClickTrunOnUrl,@UpOnLineTime,@DownOnLimeTime,@IsDeleted,@DeleterUserId,@LastModificationTime,@LastModifierUserId,@CreationTime,@CreatorUserId)");
MySqlParameter[] parameters =
{
new MySqlParameter("@BannerTitle", MySqlDbType.VarChar, 256),
new MySqlParameter("@ClickStatus", MySqlDbType.Int32, 11),
new MySqlParameter("@ImgUrl", MySqlDbType.VarChar, 2048),
new MySqlParameter("@ClickTrunOnUrl", MySqlDbType.VarChar, 2048),
new MySqlParameter("@UpOnLineTime", MySqlDbType.DateTime),
new MySqlParameter("@DownOnLimeTime", MySqlDbType.DateTime),
new MySqlParameter("@IsDeleted", MySqlDbType.Int32),
new MySqlParameter("@DeleterUserId", MySqlDbType.Int32),
new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime),
new MySqlParameter("@LastModifierUserId", MySqlDbType.Int32),
new MySqlParameter("@CreationTime", MySqlDbType.DateTime),
new MySqlParameter("@CreatorUserId", MySqlDbType.Int32)
};
parameters[0].Value = model.BannerTitle;
parameters[1].Value = model.ClickStatus;
parameters[2].Value = model.ImgUrl;
parameters[3].Value = model.ClickTrunOnUrl;
parameters[4].Value = model.UpOnLineTime;
parameters[5].Value = model.DownOnLimeTime;
parameters[6].Value = model.IsDeleted;
parameters[7].Value = model.DeleterUserId;
parameters[8].Value = model.LastModificationTime;
parameters[9].Value = model.LastModifierUserId;
parameters[10].Value = model.CreationTime;
parameters[11].Value = model.CreatorUserId;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_bannerimage GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,BannerTitle,ClickStatus,ImgUrl,ClickTrunOnUrl,UpOnLineTime,DownOnLimeTime,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId from t_bannerimage ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_bannerimage model = new LingLong.Admin.Model.t_bannerimage();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btn_upload_Click(object sender, EventArgs e)
{
//先把另一个文件上传上去
string trunonfile = "";
bool hastrunonfile = false;
if (file_ClickTrunOnUrl.HasFile)
{
hastrunonfile = true;
string exten = Path.GetExtension(file_ClickTrunOnUrl.FileName).ToLower();
if (IsImage(exten))
{
string trunonfilepath = "C:/WebSite/PublishOutput/Imges/linglong/";
if (Directory.Exists(Server.MapPath("/images/")) == false)//如果不存在就创建file文件夹
{
Directory.CreateDirectory(Server.MapPath("/images/"));
}
trunonfile = Guid.NewGuid().ToString();
string virpath = trunonfilepath + trunonfile + exten; //+ "business_banner.png";//CreatePasswordHash(pic_upload.FileName, 4) + fileExtension;//这是存到服务器上的虚拟路径
string mappath = Server.MapPath("/images/" + trunonfile + exten); //转换成服务器上的物理路径
file_ClickTrunOnUrl.PostedFile.SaveAs(mappath); //保存图片
if (File.Exists(virpath))
{
File.Delete(virpath);
}
File.Copy(mappath, virpath, true);
trunonfile = ConfigHelper.GetConfigAppSettings("ApiWebUrl") + "Imges/linglong/" + trunonfile + exten;
lab_ClickTrunOnUrl.Text = "";
}
else
{
lab_ClickTrunOnUrl.Text = "跳转图片类型不允许，请换张图片试试！";
return;
}
}
if (id > 0)
{
string filename = string.Empty, fileExtension = string.Empty;
if (pic_upload.HasFile)//验证是否包含文件
{
//取得文件的扩展名,并转换成小写
fileExtension = Path.GetExtension(pic_upload.FileName).ToLower();
if (IsImage(fileExtension))
{
//对上传文件的大小进行检测，限定文件最大不超过8M
if (pic_upload.PostedFile.ContentLength < 8192000)
{
string filepath = "C:/WebSite/PublishOutput/Imges/linglong/";
if (Directory.Exists(Server.MapPath("/images/")) == false)//如果不存在就创建file文件夹
{
Directory.CreateDirectory(Server.MapPath("/images/"));
}
filename = Guid.NewGuid().ToString();
string virpath = filepath + filename + fileExtension; //+ "business_banner.png";//CreatePasswordHash(pic_upload.FileName, 4) + fileExtension;//这是存到服务器上的虚拟路径
string mappath = Server.MapPath("/images/" + filename + fileExtension); //转换成服务器上的物理路径
pic_upload.PostedFile.SaveAs(mappath); //保存图片
if (File.Exists(virpath))
{
File.Delete(virpath);
}
File.Copy(mappath, virpath, true);
}
else
{
img_UpdateResult.ImageUrl = "";
lbl_pic.Text = "文件大小超出8M！请重新选择！";
}
}
else
{
img_UpdateResult.ImageUrl = "";
lbl_pic.Text = "要上传的文件类型不对！请重新选择！";
}
}
// 写数据库
LingLong.Admin.BLL.t_bannerimage bll = new LingLong.Admin.BLL.t_bannerimage();
LingLong.Admin.Model.t_bannerimage model = new LingLong.Admin.Model.t_bannerimage();
LingLong.Admin.Model.t_bannerimage oldmodel = bll.GetModel(id);
model.BannerTitle = txt_BannerTitle.Text;
model.ClickStatus = Convert.ToInt32(sel_ClickStatus.SelectedValue);
model.ClickTrunOnUrl = hastrunonfile ? trunonfile: oldmodel.ClickTrunOnUrl;
model.UpOnLineTime = Convert.ToDateTime(txt_UpOnLineTime.Text);
model.DownOnLimeTime = Convert.ToDateTime(txt_DownOnLimeTime.Text);
model.ImgUrl = pic_upload.HasFile ? ConfigHelper.GetConfigAppSettings("ApiWebUrl") + "Imges/linglong/" + filename + fileExtension : oldmodel.ImgUrl;
model.IsDeleted = 0;
model.DeleterUserId = null;
model.LastModificationTime = null;
model.LastModifierUserId = null;
model.CreationTime = DateTime.Now;
model.CreatorUserId = null;
model.ID = id;
bll.Update(model);
lbl_pic.Text = "";
img_UpdateResult.ImageUrl = pic_upload.HasFile ? ConfigHelper.GetConfigAppSettings("ApiWebUrl") + "Imges/linglong/" + filename + fileExtension : oldmodel.ImgUrl;
}
else
{
if (pic_upload.HasFile)//验证是否包含文件
{
//取得文件的扩展名,并转换成小写
string fileExtension = Path.GetExtension(pic_upload.FileName).ToLower();
//验证上传文件是否图片格式
//fileOk = IsImage(fileExtension);
if (IsImage(fileExtension))
{
//对上传文件的大小进行检测，限定文件最大不超过8M
if (pic_upload.PostedFile.ContentLength < 8192000)
{
string filepath = "C:/WebSite/PublishOutput/Imges/linglong/";
if (Directory.Exists(Server.MapPath("/images/")) == false)//如果不存在就创建file文件夹
{
Directory.CreateDirectory(Server.MapPath("/images/"));
}
string filename = Guid.NewGuid().ToString();
string virpath = filepath + filename + fileExtension; //+ "business_banner.png";//CreatePasswordHash(pic_upload.FileName, 4) + fileExtension;//这是存到服务器上的虚拟路径
string mappath = Server.MapPath("/images/" + filename + fileExtension); //转换成服务器上的物理路径
pic_upload.PostedFile.SaveAs(mappath); //保存图片
if (File.Exists(virpath))
{
File.Delete(virpath);
}
File.Copy(mappath, virpath, true);
// 写数据库
LingLong.Admin.Model.t_bannerimage model = new LingLong.Admin.Model.t_bannerimage();
model.BannerTitle = txt_BannerTitle.Text;
model.ClickStatus = Convert.ToInt32(sel_ClickStatus.SelectedValue);
model.ClickTrunOnUrl = hastrunonfile ? trunonfile : null;
model.UpOnLineTime = Convert.ToDateTime(txt_UpOnLineTime.Text);
model.DownOnLimeTime = Convert.ToDateTime(txt_DownOnLimeTime.Text);
model.ImgUrl = ConfigHelper.GetConfigAppSettings("ApiWebUrl") + "Imges/linglong/" + filename + fileExtension;
model.IsDeleted = 0;
model.DeleterUserId = null;
model.LastModificationTime = null;
model.LastModifierUserId = null;
model.CreationTime = DateTime.Now;
model.CreatorUserId = null;
LingLong.Admin.BLL.t_bannerimage bll = new LingLong.Admin.BLL.t_bannerimage();
bll.Add(model);
lbl_pic.Text = "";
img_UpdateResult.ImageUrl = ConfigHelper.GetConfigAppSettings("ApiWebUrl") + "Imges/linglong/" + filename + fileExtension;
//Response.AddHeader("Refresh", "0");
}
else
{
img_UpdateResult.ImageUrl = "";
lbl_pic.Text = "文件大小超出8M！请重新选择！";
}
}
else
{
img_UpdateResult.ImageUrl = "";
lbl_pic.Text = "要上传的文件类型不对！请重新选择！";
}
}
else
{
img_UpdateResult.ImageUrl = "";
lbl_pic.Text = "请选择要上传的图片！";
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LingLong.Admin.Model.t_bannerimage model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(LingLong.Admin.Model.t_bannerimage model)
{
return(dal.Add(model));
}
