protected void lbtnSave_Click(object sender, EventArgs e)
{
int download_id = Convert.ToInt32(ViewState["download_id"].ToString());
YouthDownload original_model = download_bll.GetDownloadsById(download_id);
model.Download_id = download_id;
model.Download_title = txtTitle.Text.Trim();
model.Download_father_id = Convert.ToInt32(ddl_download_col.SelectedValue);
model.Uploader = original_model.Uploader;
model.Upload_time = original_model.Upload_time;
model.Click_times = original_model.Click_times;
model.Download_source = Convert.ToInt32(ddl_source.SelectedValue);
/*
* model.Last_updater = Session[Constant.adminName].ToString();
* model.Last_update_time = DateTime.Now;
* model.Is_check = "N";
* model.Checker = "";
* model.Check_time = original_model.Check_time;
* model.Rechecker = "";
* model.Recheck_time = original_model.Recheck_time;
*/
if (download_bll.UpdDownload(model))
{
//编辑成功
MyUtil.ShowMessageRedirect(this.Page, "修改成功", "Download.aspx");
}
else
{
//编辑失败
MyUtil.ShowMessage(this.Page, "修改失败");
}
}
protected void bindDownload(int download_id)
{
model = download_bll.GetDownloadsById(download_id);
ddl_download_col.Items.FindByValue(model.Download_father_id.ToString()).Selected = true;
txtTitle.Text = model.Download_title;
ddl_source.Items.FindByValue(model.Download_source.ToString()).Selected = true;
}
protected void lbtnSave_Click(object sender, EventArgs e)
{
UploadFile();
YouthDownload model = new YouthDownload();
//文件保存路径
model.Download_title = txtTitle.Text.Trim();
model.Download_path = saveUrl + download_content.FileName;
model.Download_father_id = Convert.ToInt32(ddl_download_col.SelectedValue);
model.Uploader = Session[Constant.adminName].ToString();
model.Upload_time = DateTime.Today;
model.Click_times = 0;
model.Download_source = Convert.ToInt32(ddl_source.SelectedValue);
/*
* model.Last_updater = Session[Constant.adminName].ToString();
* model.Last_update_time = DateTime.Today;
* model.Is_check = "N";
* model.Checker = "";
* model.Check_time = DateTime.Today;
* model.Rechecker = "";
* model.Recheck_time = DateTime.Today;
*/
AUTO.BLL.YouthDownloadsBLL download_dal = new AUTO.BLL.YouthDownloadsBLL();
if (download_dal.AddYouthDownload(model))
{
//添加成功
MyUtil.ShowMessageRedirect(this.Page, "添加成功", "Download.aspx");
}
else
{
//添加失败
MyUtil.ShowMessage(this.Page, "添加失败");
}
}
/// <summary>
/// 更新文件
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdDownload(YouthDownload model)
{
int rows = download_dal.UpdDownload(model);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加文件
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddYouthDownload(YouthDownload model)
{
StringBuilder str = new StringBuilder();
str.Append(" insert into downloads(");
str.Append(" download_title,download_path,download_father_id,uploader,upload_time,click_times,download_source");
str.Append(")");
str.Append(" values ");
str.Append("(@download_title,@download_path,@download_father_id,@uploader,@upload_time,@click_times,@download_source)");
SqlParameter[] parameters =
{
new SqlParameter("@download_title", SqlDbType.NVarChar, 50),
new SqlParameter("@download_path", SqlDbType.NText),
new SqlParameter("@download_father_id", SqlDbType.Int, 8),
new SqlParameter("@uploader", SqlDbType.NVarChar, 25),
new SqlParameter("@upload_time", SqlDbType.DateTime),
new SqlParameter("@click_times", SqlDbType.Int, 8),
new SqlParameter("@download_source", SqlDbType.Int, 8)
/*
* new SqlParameter("@last_updater",SqlDbType.NVarChar,25),
* new SqlParameter("@last_update_time",SqlDbType.DateTime),
* new SqlParameter("@is_check",SqlDbType.VarChar,8),
* new SqlParameter("@checker",SqlDbType.NVarChar,25),
* new SqlParameter("@check_time",SqlDbType.DateTime),
* new SqlParameter("@rechecker",SqlDbType.NVarChar,25),
* new SqlParameter("@recheck_time",SqlDbType.DateTime)
*/
};
parameters[0].Value = model.Download_title;
parameters[1].Value = model.Download_path;
parameters[2].Value = model.Download_father_id;
parameters[3].Value = model.Uploader;
parameters[4].Value = model.Upload_time;
parameters[5].Value = model.Click_times;
parameters[6].Value = model.Download_source;
/*
* parameters[7].Value = model.Last_updater;
* parameters[8].Value = model.Last_update_time;
* parameters[9].Value = model.Is_check;
* parameters[10].Value = model.Checker;
* parameters[11].Value = model.Check_time;
* parameters[12].Value = model.Rechecker;
* parameters[13].Value = model.Recheck_time;
*/
int rows = DbHelperSQL.ExecuteSql(str.ToString(), parameters);
return(rows);
}
protected void bindDownload()
{
download = download_bll.GetDownloadsById(download_id);
downloads_title.Text = download.Download_title;
download_path = download.Download_path;
download_name = download_path.Split('/').Last();
UploadTime.Text = FormatTime(download.Upload_time);
Uploader.Text = download.Uploader;
Clicks.Text = download.Click_times.ToString();
/*
* updater.Text = download.Last_updater;
* checker.Text = download.Checker;
*/
}
/// <summary>
/// 更新文件
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdDownload(YouthDownload model)
{
StringBuilder str = new StringBuilder();
str.Append(" update downloads set ");
str.Append(" download_title=@download_title,");
str.Append(" download_path=@download_path,");
str.Append(" download_father_id=@download_father_id,");
str.Append(" uploader=@uploader,");
str.Append(" upload_time=@upload_time,");
str.Append(" click_times=@click_times,");
str.Append("download_source=@download_source,");
/*
* str.Append(" last_updater=@last_updater,");
* str.Append(" last_update_time=@last_update_time,");
* str.Append(" is_check=@is_check,");
* str.Append(" checker=@checker,");
* str.Append(" check_time=@check_time,");
* str.Append(" rechecker=@rechecker,");
* str.Append(" recheck_time=@recheck_time ");
*/
str.Append(" where download_id=@download_id ");
SqlParameter[] parameters =
{
new SqlParameter("@download_title", SqlDbType.NVarChar, 50),
new SqlParameter("@download_path", SqlDbType.NText),
new SqlParameter("@download_father_id", SqlDbType.Int, 8),
new SqlParameter("@uploader", SqlDbType.NVarChar, 25),
new SqlParameter("@upload_time", SqlDbType.DateTime),
new SqlParameter("@click_times", SqlDbType.Int, 8),
new SqlParameter("@download_source", SqlDbType.Int, 8),
/*
* new SqlParameter("@last_updater",SqlDbType.NVarChar,25),
* new SqlParameter("@last_update_time",SqlDbType.DateTime),
* new SqlParameter("@is_check",SqlDbType.VarChar,8),
* new SqlParameter("@checker",SqlDbType.NVarChar,25),
* new SqlParameter("@check_time",SqlDbType.DateTime),
* new SqlParameter("@rechecker",SqlDbType.NVarChar,25),
* new SqlParameter("@recheck_time",SqlDbType.DateTime),
* new SqlParameter("@download_id",SqlDbType.Int,8)
*/
};
parameters[0].Value = model.Download_title;
parameters[1].Value = model.Download_path;
parameters[2].Value = model.Download_father_id;
parameters[3].Value = model.Uploader;
parameters[4].Value = model.Upload_time;
parameters[5].Value = model.Click_times;
parameters[6].Value = model.Download_source;
/*
* parameters[7].Value = model.Last_updater;
* parameters[8].Value = model.Last_update_time;
* parameters[9].Value = model.Is_check;
* parameters[10].Value = model.Checker;
* parameters[11].Value = model.Check_time;
* parameters[12].Value = model.Rechecker;
* parameters[13].Value = model.Recheck_time;
* parameters[14].Value = model.Download_id;
*/
int rows = DbHelperSQL.ExecuteSql(str.ToString(), parameters);
return(rows);
}
