public void update()
{
if (this.TextBox1.Text.Trim() == string.Empty)
{
Jscript.Alert("投票信息标题不能为空！", this.Page);
}
else if (this.Text1.Value.Trim() == string.Empty)
{
Jscript.Alert("到期时间不能为空！", this.Page);
}
else
{
HXD.SQLServerDAL.tb_U_TouPiao toupiaodal = new HXD.SQLServerDAL.tb_U_TouPiao(); //投票操作类
HXD.Model.tb_U_TouPiao toupiaomodel = new HXD.Model.tb_U_TouPiao(); //投票属性类
toupiaomodel.id = id;
toupiaomodel.title = this.TextBox1.Text.Trim();
toupiaomodel.is_Examine = this.CheckBox1.Checked ? 1 : 0; //是否审核
toupiaomodel.is_Recommendation = this.CheckBox2.Checked ? 1 : 0; //是否推荐
toupiaomodel.end_time = Convert.ToDateTime(this.Text1.Value);
toupiaomodel.VoteType = this.RadioButton1.Checked ? 1 : 2;
if (toupiaodal.Update(toupiaomodel))
{
Jscript.AlertAndRedirect("投票信息修改成功！", "TouPiaoList.aspx?Page=" + Pages);
}
else
{
Jscript.Alert("投票信息修改失败！", Page); return;
}
}
}
/// <summary>
/// 保存信息
/// </summary>
protected void ModelSave()
{
string Field = "ClassId,", Val = this.ClassId.SelectedValue + "{$split$}";
mField mF = new mField();
bField bF = new bField();
mF.TableName = mm.TableName;
DataSet ds = bF.FieldList(mF);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string ValTemp = System.Web.HttpContext.Current.Request.Form[ds.Tables[0].Rows[i]["Field"].ToString()];
if (ValTemp != string.Empty && ValTemp != null)
{
Field += ds.Tables[0].Rows[i]["Field"].ToString() + ",";
Val += HXD.ModelField.Common.FieldType.FormatField(ds.Tables[0].Rows[i]["Type"].ToString(), ds.Tables[0].Rows[i]["Field"].ToString()) + "{$split$}";
}
}
if (mm.Id == 0)
{
bm.ModelInsert(mm.TableName, Field, Val);
}
else
{
bm.ModelUpdate(mm.Id, mm.TableName, Field, Val);
}
if (MenuId == 0)
{
Jscript.Alert("保存成功！", this.Page); binder();
}
else
{
Response.Redirect("Model_Manage.aspx?MenuId=" + MenuId);
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button2_Click(object sender, EventArgs e)
{
string ids = selInfo();
int num = 0;
if (ids.Length == 0)
{
Jscript.Alert("请选择要删除的记录！", this.Page);
return;
}
string[] arr = ids.TrimEnd(',').Split(',');
for (int i = 0; i < arr.Length; i++)
{
if (AdminUserService.Delete(Convert.ToInt32(arr[i])) > 0)
{
num++;
}
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('成功删除" + num + "条记录！');", true);
DataSet ds = AdminUserService.GetList("");
if (ds.Tables[0].Rows.Count > 0)
{
this.repInfo.DataSource = ds;
repInfo.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
string lei = this.TextBox1.Text;
string leishu = this.TextBox3.Text;
int count = int.Parse(da.GetSingeData("select count(*) from tm_path where myParent = 0 and (cn_name ='" + lei + "' or id=" + leishu + ")").ToString());
if (count > 0)
{
Jscript.Alert("该名称或基准ID已被使用，请重试！");
}
else
{
da.RunSql("insert into tm_path (cn_name,id,barid,myparent,visible,ntype,realid,sequence,zlevel,showinleft,showintop) "
+ "values ('" + lei + "','" + leishu + "','" + leishu + "','0',1,'SinglePage',NULL," + leishu + "*10,1,1,1)");
this.Label1.Text = "<div class=\"boxdiv\">提交成功！</div>";
this.TextBox1.Text = null;
Bind();
}
//string sql = "insert into smn_lanmu_type (lei,leishu)values('" + lei + "','" + leishu + "')";
//da.RunSql(sql);
}
catch
{
this.Label1.Text = "<div class=\"boxdiv\">提交失败！</div>";
}
finally
{
}
}
}
protected void rp_main_ItemCommand(object source, RepeaterCommandEventArgs e)
{
SHUniversity.KPI.Model.Users currUser = Session["SHUUser"] as SHUniversity.KPI.Model.Users;
string parma = e.CommandArgument.ToString();
//0未提交1正在审核2审核通过3退回
if (e.CommandName == "pass")
{
bool r = kpiBll.ChangeStatus(parma, 2, currUser.Name, currUser.WorkID);
if (r)
{
Jscript.Alert("审核成功");
}
else
{
Jscript.Alert("审核失败，稍后再试");
}
}
if (e.CommandName == "back")
{
bool r = kpiBll.ChangeStatus(parma, 3, currUser.Name, currUser.WorkID);
if (r)
{
Jscript.Alert("审核成功");
}
else
{
Jscript.Alert("审核失败，稍后再试");
}
}
}
protected void DataList1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string id = e.CommandArgument.ToString();
if (e.CommandName == "edit")
{
Response.Redirect("PathConfig.aspx?id=" + id);
}
else if (e.CommandName == "Add")
{
Response.Redirect("Article_lanmu2_add.aspx?id=" + id);
}
else if (e.CommandName == "SetFirst")
{
Response.Redirect("Article_setfirst.aspx?type=" + id);
}
else if (e.CommandName == "Delete")
{
int count = int.Parse(da.GetSingeData("select count(*) from tm_path where myparent=" + id).ToString());
if (count > 0)
{
Jscript.Alert("该分类存在子类，不能被删除！");
}
else
{
string sql = "delete from tm_path where id=" + id;
da.RunSql(sql);
Bind();
}
//Response.Redirect("Article_setfirst.aspx?type=" + id);
}
}
protected void butSava_Click(object sender, EventArgs e)
{
FNEWS_TYPE dalNewsType = new FNEWS_TYPE();
string id = Request.QueryString["id"];
ENEWSType eNewsType = dalNewsType.GetDAL().GetModel(Convert.ToInt32(Hid.Value));
eNewsType.TypeName = txtTypeName.Text.Trim();
eNewsType.ParentID = Convert.ToInt32(DD_Type.SelectedValue);
if (isfabu.Checked == true)
{
eNewsType.ISFabu = 1;
}
else
{
eNewsType.ISFabu = 0;
}
if (islimit.Checked == true) //0全访问1会员访问
{
eNewsType.ISLimit = 1;
}
else
{
eNewsType.ISLimit = 0;
}
bool count = dalNewsType.GetDAL().Update(eNewsType);
if (count)
{
Jscript.RedirectToFrames("Admin_NewsType.aspx");
}
else
{
Jscript.Alert("异常错误，请重试！");
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void butSava_Click(object sender, EventArgs e)
{
SHUniversity.KPI.Model.Users u = new SHUniversity.KPI.Model.Users();
u.ID = int.Parse(hidid.Value);
u.BrithDay = SHUniversity.KPI.Common.ConvertDatetime(txt_birthday.Text.Trim());
u.CreatDate = DateTime.Now;
u.Email = txt_email.Text.Trim();
u.InDate = Common.ConvertDatetime(txt_indate.Text.Trim());
u.Moblie = txt_moblie.Text.Trim();
u.Name = txt_name.Text.Trim();
u.Password = txt_pwd.Text.Trim();
u.Ramerk = txt_common.Text.Trim();
u.Satat = 1;
u.Sex = int.Parse(rb_sex.SelectedValue);
u.Tel = txt_tell.Text.Trim();
u.UserType = int.Parse(rb_usertype.SelectedValue);
u.WorkID = txt_workID.Text.Trim();
u.Xueli = txt_xueli.Text.Trim();
u.Xuexiao = txt_xuexiao.Text.Trim();
u.Zhiwu = txt_zhiwu.Text.Trim();
bool result = uBll.Update(u);
if (result)
{
Jscript.RedirectToFrames("UserManage.aspx");
}
else
{
Jscript.Alert("修改异常，请重试");
Jscript.RedirectToFrames("UserManage.aspx");
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDel_Click(object sender, EventArgs e)
{
string ids = selInfo();
int num = 0;
if (ids.Length == 0)
{
Jscript.Alert("请选择要删除的记录！", this.Page);
return;
}
string[] arr = ids.TrimEnd(',').Split(',');
int newsId = 0;
for (int i = 0; i < arr.Length; i++)
{
int id = Convert.ToInt32(arr[i]);
newsId = TopNewsService.GetModel(id).newsId;
if (TopNewsService.Delete(id) > 0)
{
NewsService.UpdateTop(newsId, 0);
num++;
}
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('成功删除" + num + "条记录！');", true);
sp.InitBindData(Repeater1, pager1, "TopNews", "id", sear());
}
protected void Button1_Click(object sender, EventArgs e)
{
if (this.TextBox1.Text.Trim() == string.Empty)
{
Jscript.Alert("投票信息标题不能为空！", this.Page);
}
else if (this.Text1.Value.Trim() == string.Empty)
{
Jscript.Alert("到期时间不能为空！", this.Page);
}
else
{
HXD.SQLServerDAL.tb_U_TouPiao toupiaodal = new HXD.SQLServerDAL.tb_U_TouPiao(); //投票操作类
HXD.Model.tb_U_TouPiao toupiaomodel = new HXD.Model.tb_U_TouPiao(); //投票属性类
toupiaomodel.title = this.TextBox1.Text.Trim();
toupiaomodel.is_Examine = this.CheckBox1.Checked ? 1 : 0;
toupiaomodel.is_Recommendation = this.CheckBox2.Checked ? 1 : 0;
toupiaomodel.end_time = Convert.ToDateTime(this.Text1.Value);
toupiaomodel.VoteType = this.RadioButton1.Checked ? 1 : 2;
if (toupiaodal.Add(toupiaomodel))
{
Jscript.AlertAndRedirect("投票信息添加成功！", "TouPiaoList.aspx?Page=" + Pages);
}
else
{
Jscript.Alert("投票信息添加失败！", this.Page);
}
}
}
protected void btn_CreatTable_Click(object sender, EventArgs e)
{
SHUniversity.KPI.Model.Users u = (SHUniversity.KPI.Model.Users)Session["SHUUser"];
//lb_msg
bool r = kpiBll.Exists(u.WorkID, DateTime.Now.Year);
if (r)
{
Jscript.Alert("本年度已经创建了考核表，不能重复创建");
}
else
{
SHUniversity.KPI.Model.UserKPI kpi = new SHUniversity.KPI.Model.UserKPI();
kpi.CreatDate = DateTime.Now;
kpi.Creator = u.Name;
kpi.KPINumber = SHUniversity.KPI.Common.CreatRandom();
kpi.KPIYear = DateTime.Now.Year;
kpi.Status = 0;//0未审核1正在审核2审核通过3退回
kpi.WorkID = u.WorkID;
int result = kpiBll.Add(kpi);
if (result > 0)
{
Jscript.AlertAndRedirect("建表成功", "/Home.aspx");
}
else
{
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DataAccess da = new DataAccess();
string username = UserName.Text;
if (username == "")
{
Jscript.Alert("用户名不能为空");
return;
}
string realname = RealName.Text;
if (realname == "")
{
Jscript.Alert("姓名不能为空");
return;
}
string password = pwd.Text;
password = StringUtil.EncryptPassword(password, "MD5");
string youxiao = Youxiao.Checked ? "1" : "0";
string superType = Superman.Checked ? "1" : "0";
string quan = "," + Request.Form["innerc"] + ",";
if (ViewState["editmode"] != null)
{
da.RunSql("update tm_Admin set realname='" + realname + "',AdminPurview='" + quan + "',isused=" + youxiao + ",supertype=" + superType + " where username='******'");
if (pwd.Text.Trim() != "")
{
da.RunSql("update tm_Admin set pwd='" + password + "' where username='******'");
}
}
else
{
da.RunSql("insert into tm_Admin(username,realname,pwd,AdminPurview,isUsed,supertype) values('" + username + "','" + realname + "','" + password + "','" + quan + "'," + youxiao + "," + superType + ")");
}
Jscript.AlertAndRedirect("成功新增管理员！", "Adminlist.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (this.TextBox1.Text.Trim() == "")
{
Jscript.Alert("请填写广告名称！", this.Page);
}
else
{
insert();
}
}
/// <summary>
/// 更新指定分类
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button3_Click(object sender, EventArgs e)
{
if (this.ClassId.SelectedValue == "-1")
{
HXD.Common.HtmlDal.WToHtmlNewsUpData("", "html");
}
else
{
HXD.Common.HtmlDal.WToHtmlNewsUpData("where ClassId=" + this.ClassId.SelectedValue, "html");
}
Jscript.Alert("生成完毕", this.Page);
}
protected void btnCreateQR_Click(object sender, EventArgs e)
{
this.txtQRUrl.Text = string.Empty;
this.ImageQR.ImageUrl = "";
if (this.txtPassword.Text.Equals("createQRAdministrator"))
{
if (string.IsNullOrEmpty(this.txtSourceFrom.Text.Trim()) || this.txtSourceFrom.Text.Trim().Length > 59)
{
JavaScript.Alert("推广渠道填写错误，最多60个字，不能空白");
}
#region 先判断以前有没有，有就直接返回
const string querySql = "select * from [dbo].[WXQRInfos] where sourceFrom =@sourceFrom order by AddDate desc ";
var param = new DynamicParameters();
param.Add("@SourceFrom", this.txtSourceFrom.Text.Trim());
var wxQrInfos =PublicConn.QueryActivityBySql<WXQRInfo>(querySql,ref param);
if (wxQrInfos.Count >=1)
{
this.txtQRUrl.Text = wxQrInfos.FirstOrDefault().QrUrl;
this.ImageQR.ImageUrl = "http://s.jiathis.com/qrcode.php?url=" + wxQrInfos.FirstOrDefault().QrUrl;
JavaScript.Alert("已经生成过这样的推广二维码了哦！");
return;
}
#endregion
#region 调用接口获取
ThirdLoginSDK sdk = new ThirdLoginSDK();
sdk.InitSDK(ThirdLoginSDK.ThirdLoginType.WeiXin);
var wxQr = sdk.GetWXQrInfoBy(this.txtSourceFrom.Text);
if (wxQr != null)
{
this.txtQRUrl.Text = wxQr.url;
const string insertSql = @"insert into [dbo].[WXQRInfos]([Id],[SourceFrom],[AddDate],[QrUrl],[Ticket])
values (@Id,@SourceFrom,@AddDate,@QrUrl,@Ticket)";
var param2 = new DynamicParameters();
param2.Add("@Id", Guid.NewGuid());
param2.Add("@SourceFrom", this.txtSourceFrom.Text);
param2.Add("@AddDate", DateTime.Now);
param2.Add("@QrUrl", wxQr.url);
param2.Add("@Ticket", wxQr.ticket);
PublicConn.ExecuteActivity(insertSql,ref param2);
this.ImageQR.ImageUrl = "http://s.jiathis.com/qrcode.php?url=" + wxQr.url;
}
#endregion
}
else
{
Jscript.Alert("请输入正确的管理员密码");
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void butSava_Click(object sender, EventArgs e)
{
EPROType model = new EPROType();
if (con == "edit")
{
model = fpt.GetDAL().GetModel(Convert.ToInt32(id));
}
model.TypeName = txtProTypeName.Text.Trim();
model.ParentID = Convert.ToInt32(DD_Type.SelectedValue);
if (CB_ispub.Checked == true)
{
model.ISPub = "1";
}
else
{
model.ISPub = "0";
}
if (CB_isLimit.Checked == true) //0全访问1会员访问
{
model.ISLimit = "1";
}
else
{
model.ISLimit = "0";
}
bool result;
if (con == "add")
{
result = fpt.GetDAL().Add(model);
}
else
{
result = fpt.GetDAL().Update(model);
}
if (result)
{
Jscript.RedirectToFrames("Admin_PROTYPE.aspx");
}
else
{
Jscript.Alert("异常错误，请重试！");
}
}
/// <summary>
/// 删除图片
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button8_Click(object sender, EventArgs e)
{
if (ViewState["mod"] != null)
{
int id = Convert.ToInt32(ViewState["mod"]);
if (System.IO.File.Exists(Server.MapPath(lblUrl3.Text)))
{
System.IO.File.Delete(Server.MapPath(lblUrl3.Text));
}
if (ProductTypeService.DeleteTypeImg(id, 3))
{
Jscript.Alert("操作成功");
}
}
sp.InitBindData(repInfo, this.pager1, "ProductType", "id", sear());
}
/// <summary>
/// 保存顺序
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void OrderBy_Click(object sender, EventArgs e)
{
for (int i = 0; i < this.RP_con.Items.Count; i++)
{
string id = ((RP_con.Items[i].FindControl("HiddenField_")) as HiddenField).Value;
string orderby = ((RP_con.Items[i].FindControl("txtOrderBy")) as TextBox).Text;
if (SITED.COMMON.PageValidate.IsNumber(orderby))
{
EPRO epo = bll_fpo.GetDAL().GetModel(Convert.ToInt32(id));
epo.OrderBy = Convert.ToInt32(orderby);
bll_fpo.GetDAL().Update(epo);
}
else
{
Jscript.Alert("顺序只能为数字！");
}
}
Jscript.RedirectToFrames("Admin_PRO.aspx");
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
string ids = selInfo();
int num = 0;
if (ids.Length == 0)
{
Jscript.Alert("请选择要Delete的记录！", this.Page);
return;
}
string[] arr = ids.TrimEnd(',').Split(',');
for (int i = 0; i < arr.Length; i++)
{
if (CartTempService.Delete(Convert.ToInt32(arr[i])))
{
num++;
}
}
BindData();
}
protected void butSava_Click(object sender, EventArgs e)
{
try
{
if (ubll.Exists(txt_workID.Text.Trim()))
{
Jscript.Alert("已经存在的工号");
return;
}
//添加用户
SHUniversity.KPI.Model.Users u = new SHUniversity.KPI.Model.Users();
u.BrithDay = SHUniversity.KPI.Common.ConvertDatetime(txt_birthday.Text.Trim());
u.CreatDate = DateTime.Now;
u.Email = txt_email.Text.Trim();
u.InDate = Common.ConvertDatetime(txt_indate.Text.Trim());
u.Moblie = txt_moblie.Text.Trim();
u.Name = txt_name.Text.Trim();
u.Password = txt_pwd.Text.Trim();
u.Ramerk = txt_common.Text.Trim();
u.Satat = 1;
u.Sex = int.Parse(rb_sex.SelectedValue);
u.Tel = txt_tell.Text.Trim();
u.UserType = int.Parse(rb_usertype.SelectedValue);
u.WorkID = txt_workID.Text.Trim();
u.Xueli = txt_xueli.Text.Trim();
u.Xuexiao = txt_xuexiao.Text.Trim();
u.Zhiwu = txt_zhiwu.Text.Trim();
if (ubll.Add(u) > 0)
{
Jscript.AlertAndRedirect("添加成功！", "AddUser.aspx");
}
else
{
Jscript.Alert("添加失败请重试");
}
}
catch (Exception ex)
{
Jscript.Alert("异常信息：" + ex.Message);
}
}
/// <summary>
/// 热门新闻设置
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSetHot_Click(object sender, EventArgs e)
{
string ids = selInfo();
int num = 0;
if (ids.Length == 0)
{
Jscript.Alert("请选择要设置的记录！", this.Page);
return;
}
string[] arr = ids.TrimEnd(',').Split(',');
for (int i = 0; i < arr.Length; i++)
{
if (NewsService.UpdateOrderNum(Convert.ToInt32(arr[i])) > 0)
{
num++;
}
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('成功设置" + num + "条记录！');", true);
sp.InitBindData(Repeater1, pager1, "news", "id", sear());
}
protected void rp_table_ItemCommand(object source, RepeaterCommandEventArgs e)
{
SHUniversity.KPI.Model.UserKPI kpi = kpiBll.GetModel(int.Parse(e.CommandArgument.ToString()));
if (kpi.Status != 0)
{
Jscript.Alert("当前状态不可以提交");
return;
}
if (e.CommandName == "apply")
{
bool r = kpiBll.ChangeStatus(e.CommandArgument.ToString(), 1, u.Name, u.WorkID);
if (r)
{
Jscript.Alert("提交成功");
}
else
{
Jscript.Alert("提交失败");
}
}
}
/// <summary>
/// 删除所选项
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LB_DelSelect_Click(object sender, EventArgs e)
{
string sb = string.Empty;
for (int i = 0; i < this.RP_con.Items.Count; i++)
{
CheckBox cb = (RP_con.Items[i].FindControl("CheckBox1_")) as CheckBox;
if (cb.Checked == true)
{
string dd = ((RP_con.Items[i].FindControl("HiddenField_")) as HiddenField).Value;
sb += dd + ",";
}
}
if (ubll.DeleteList(sb))
{
Jscript.RedirectToFrames("UserManage.aspx");
}
else
{
Jscript.Alert("删除失败，请重试！！");
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDel_Click(object sender, EventArgs e)
{
string ids = selInfo();
int num = 0;
if (ids.Length == 0)
{
Jscript.Alert("请选择要删除的记录！", this.Page);
return;
}
string[] arr = ids.TrimEnd(',').Split(',');
for (int i = 0; i < arr.Length; i++)
{
if (SearchKeyWordService.Delete(Convert.ToInt32(arr[i])))
{
num++;
}
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('成功删除" + num + "条记录！');", true);
sp.InitBindData(this.repInfo, pager1, "SearchKeyWord", "id", sear());
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txtUserName.Text.Trim();
string pass = this.txtPassWord.Text.Trim();
if (name.Length == 0 || pass.Length == 0)
{
Jscript.Alert("各项不能为空");
return;
}
AdminUser item = AdminUserService.GetModel(name, pass);
if (item != null && item.status == 1)
{
Session["loginUser"] = item;
Response.Redirect("inok.aspx");
}
else
{
Jscript.AlertAndRedirect("无此账号或已被停用，请联系超级管理员！", this.Request.RawUrl);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (this.TextBox1.Text.Trim() == string.Empty)
{
Jscript.Alert("标签说明不能为空！", this.Page);
}
else if (this.TextBox2.Text.Trim() == string.Empty)
{
Jscript.Alert("标签名称不能为空！", this.Page);
}
else if (this.TextBox3.Text.Trim() == string.Empty)
{
Jscript.Alert("文件名称不能为空！", this.Page);
}
else if (this.Content.Value.Trim() == string.Empty)
{
Jscript.Alert("标签内容不能为空！", this.Page);
}
else
{
HXD.SQLServerDAL.tb_U_Template_Label DAL = new HXD.SQLServerDAL.tb_U_Template_Label();
HXD.Model.tb_U_Template_Label Model = new HXD.Model.tb_U_Template_Label();
Model.id = id;
Model.labelHelp = this.TextBox1.Text.Trim();
Model.labelname = this.TextBox2.Text.Trim();
Model.labelfile = this.TextBox3.Text.Trim();
Model.counts = this.Content.Value.Trim();
if (DAL.Update(Model))
{
HXD.Common.FilesManage.ReplaceFileNewContent("~/" + Model.labelfile, Model.labelname, Model.counts, Web.Model.PublicModel.EncodingUTF8);
Jscript.AlertAndRedirect("标签修改成功！", "TemplateLabelList.aspx?Page=" + Pages);
}
else
{
Jscript.Alert("标签修改失败！", this.Page);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (this.TextBox1.Text.Trim() == string.Empty)
{
Jscript.Alert("标签说明不能为空！", this.Page);
}
else if (this.TextBox2.Text.Trim() == string.Empty)
{
Jscript.Alert("标签名称不能为空！", this.Page);
}
else if (this.TextBox3.Text.Trim() == string.Empty)
{
Jscript.Alert("文件名称不能为空！", this.Page);
}
else if (this.Content.Value.Trim() == string.Empty)
{
Jscript.Alert("标签内容不能为空！", this.Page);
}
else
{
HXD.SQLServerDAL.tb_U_Template_Label DAL = new HXD.SQLServerDAL.tb_U_Template_Label();
HXD.Model.tb_U_Template_Label Model = new HXD.Model.tb_U_Template_Label();
Model.labelHelp = this.TextBox1.Text.Trim();
Model.labelname = this.TextBox2.Text.Trim();
Model.labelfile = this.TextBox3.Text.Trim();
Model.counts = this.Content.Value.Trim();
if (DAL.Add(Model))
{
//FilesManage.ReplaceFileNewContent(Server.MapPath("~/" + Model.labelfile), Model.labelname, Model.counts);//更新文件
Jscript.AlertAndRedirect("标签添加成功！", "TemplateLabelList.aspx?Page=" + Pages);
}
else
{
Jscript.Alert("标签添加失败！", this.Page);
}
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void butSava_Click(object sender, EventArgs e)
{
FNEWS_TYPE news_type = new FNEWS_TYPE();
ENEWSType Enewtype = new ENEWSType();
Enewtype.TypeName = Request.Form["newstypename"];
Enewtype.ParentID = Convert.ToInt32(DD_Type.SelectedValue);
if (Request.Form["isfabu"] == "on")
{
Enewtype.ISFabu = 1;
}
else
{
Enewtype.ISFabu = 0;
}
if (Request.Form["islimit"] == "on") //0全访问1会员访问
{
Enewtype.ISLimit = 1;
}
else
{
Enewtype.ISLimit = 0;
}
Enewtype.Lang = language;
bool result = news_type.GetDAL().Add(Enewtype);
if (result)
{
Jscript.RedirectToFrames("Admin_NewsType.aspx");
}
else
{
Jscript.Alert("异常错误，请重试！");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//CheckAuthority("|52,");
if (!IsPostBack)
{
string StrSQL = "select a.id,b.cn_name + '-' + a.cn_name as lei from tm_path a left join tm_path b on a.myparent=b.id where a.ntype='PhotoList-more' and a.myparent>0 and (a.id in (-1" + Session["AdminPurview"].ToString() + "-1) or a.myParent in (-1" + Session["AdminPurview"].ToString() + "-1)) order by a.sequence";
DataTable dt = da.GetTable(StrSQL);
if (dt == null || dt.Rows.Count == 0)
{
Jscript.Alert("对不起，目前系统没有配置教师分类，请先联系管理员");
Response.End();
}
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "lei";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
//修改页面复用
string id = QueryString.GetId;
if (id != null)
{
string sql = "select * from tm_teacher where id=" + id;
dt = da.GetTable(sql);
if (dt == null || dt.Rows.Count == 0)
{
Jscript.Alert("请检查该ID合法性！");
Response.End();
}
DropDownList1.Items.FindByValue(dt.Rows[0]["pathid"].ToString()).Selected = true;
Name_Cn.Text = dt.Rows[0]["Name_Cn"].ToString();
Name_En.Text = dt.Rows[0]["Name_En"].ToString();
Title_cn.Text = dt.Rows[0]["Title_cn"].ToString();
Title_en.Text = dt.Rows[0]["Title_en"].ToString();
Zy_Cn.Text = dt.Rows[0]["Zy_Cn"].ToString();
Zy_en.Text = dt.Rows[0]["Zy_en"].ToString();
Research_cn.Text = dt.Rows[0]["Research_cn"].ToString();
Research_en.Text = dt.Rows[0]["Research_en"].ToString();
Sequence.Text = dt.Rows[0]["Sequence"].ToString();
Editor1.Value = dt.Rows[0]["intro_cn"].ToString();
Editor2.Value = dt.Rows[0]["intro_en"].ToString();
User_name.Text = dt.Rows[0]["User_name"].ToString();
Photo.Text = dt.Rows[0]["Photo"].ToString();
if (dt.Rows[0]["Photo"] == null || dt.Rows[0]["Photo"].ToString() == "")
{
this.Image1.ImageUrl = "include/images/nonebig.gif";
}
else
{
this.Image1.ImageUrl = Photo.Text;
}
//Name_Cn.Text = dt.Rows[0]["Name_Cn"].ToString();
}
else
{
string typeid = QueryString.GetTypeid;
if (typeid != null)
{
DropDownList1.Items.FindByValue(id).Selected = true;
}
}
}
}
protected void btnImport_ServerClick(object sender, EventArgs e)
{
if (!fileImport.HasFile || fileImport.FileContent.Length == 0)
{
Jscript.Alert("请上传填写好内容的模板文件");
return;
}
string fileName = "~/uploads/file/" + DateTime.Now.ToString("yyyy-MM-ddHHmmss") + ".xls";
try
{
fileImport.SaveAs(Server.MapPath(fileName));
}
catch (Exception ex)
{
Response.Write("上传文件失败:" + ex.Message);
}
try
{
DataSet ds = TFXK.Common.ExcelImport.ExcelToDS(Server.MapPath(fileName));
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)
{
int recordCount = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
TFXK.Model.TestingStudent model = new TFXK.Model.TestingStudent();
model.UserName = dr[0].ToString();
model.UserNamePinyin = dr[1].ToString();
model.Sex = dr[2].ToString().Equals("男") ? 0 : 1;
model.IDNumber = dr[3].ToString();
DateTime birthday;
DateTime.TryParse(dr[4] + "", out birthday);
model.Birthday = birthday;
var cmodel = bllCategory.GetModelByName(dr[5] + "");
if (cmodel == null)
{
continue;
}
model.ClassID = cmodel.id;
model.LevelNum = dr[6] + "";
model.OrgLevel = dr[7] + "";
var countryModel = bllCategory.GetModelByName(dr[8] + "");
if (countryModel == null)
{
continue;
}
model.Country = countryModel.id + "";
var EthnicGroupModel = bllCategory.GetModelByName(dr[9] + "");
if (EthnicGroupModel == null)
{
continue;
}
model.EthnicGroup = EthnicGroupModel.id + "";
model.CreateTime = DateTime.Now;
model.IsPass = 0;
model.PlanID = Int32.Parse(Request.QueryString["id"]);
model.Score = 0;
model.UserHeadImage = "";
model.UserWorkImage = "";
recordCount++;
bllTestingStudent.Add(model);
}
Jscript.Alert("已提交数据" + recordCount + "条");
}
else
{
Jscript.Alert("没有读取到数据");
}
}
catch (Exception ex)
{
Jscript.Alert("读取导入数据错误:" + ex.Message);
}
}
