protected void BtnSaveEditCity_Click(object sender, EventArgs e) { string id = Request.QueryString["id"]; int idd = Convert.ToInt32(id); if (string.IsNullOrEmpty(TxtEditCity.Text.Trim())) { Response.Write("<script>alert('不能为空!');window.history.go(-1);</script>"); } else { SqlServerProvider conn = new SqlServerProvider(); conn.Open(); string proId = conn.GetItem("select c.provinceId from Y_City c left outer join Y_Area a on a.cityId=c.cityId where a.areaId='" + idd + "'", "0"); string sql = "select * from Y_City where cityName='" + TxtEditCity.Text.ToString().Trim() + "' and provinceId='"+Convert.ToInt32(proId)+"'"; if (proId != "0") { if (conn.ExistData(sql)) { Response.Write("<script>alert('该市已存在!请重新输入');window.history.go(-1);</script>"); } else { string cityId = conn.GetItem("select cityId from Y_Area where areaId='"+idd+"'", "0"); if (cityId != "0") { conn.Execute("update Y_City set cityName='" + TxtEditCity.Text.Trim() + "' where cityId='" + Convert.ToInt32(cityId) + "'"); conn.Execute("insert into Y_LogOperation (actionInfo,changeTime,userName) values('修改市," + TxtEditPro.Text.Trim() + "','" + DateTime.Now + "','" + Session["userName"] + "')"); Response.Write("<script>alert('修改市成功!');window.history.go(-1);</script>"); } else { Response.Write("<script>alert('修改失败!');window.history.go(-1);</script>"); } } } else { Response.Write("<script>alert('修改失败!');window.history.go(-1);</script>"); } conn.Close(); } }
/// <summary> /// 更新登陆操作日志 /// </summary> protected void UpdateLogin(string username) { SqlServerProvider conn = new SqlServerProvider(); conn.Open(); conn.Execute("insert into Y_LogOperation (actionInfo,changeTime,userName) values('登录系统~~','" + DateTime.Now + "','" + username + "')"); conn.Close(); }
protected void BtnSaveArea_Click(object sender, EventArgs e) { if (DropDownListProvince2.SelectedValue == "0") { Response.Write("<script>alert('请先选择省!');window.history.go(-1);</script>"); } else if (DropDownListCity.SelectedValue == "0") { Response.Write("<script>alert('请先选择市!');window.history.go(-1);</script>"); } else if (string.IsNullOrEmpty(TxtArea.Text.Trim())) { Response.Write("<script>alert('请输入地区名或县名!');window.history.go(-1);</script>"); return; } else { SqlServerProvider conn = new SqlServerProvider(); conn.Open(); string sql = "select * from Y_Area where areaName='" + TxtArea.Text.Trim() + "' and cityId='" + DropDownListCity.SelectedValue + "'"; if (conn.ExistData(sql)) { Response.Write("<script>alert('该地区已存在!请重新输入');window.history.go(-1);</script>"); } else { conn.Execute("insert into Y_Area (areaName,cityId) values('" + TxtArea.Text.Trim() + "'," + DropDownListCity.SelectedValue + ")"); conn.Execute("insert into Y_LogOperation (actionInfo,changeTime,userName) values('添加地区," + TxtArea.Text.Trim() + "','" + DateTime.Now + "','" + Session["userName"] + "')"); Response.Write("<script>alert('添加地区成功!');window.history.go(-1);</script>"); } conn.Close(); } }
protected void BtnEditSave_Click(object sender, EventArgs e) { //if (string.IsNullOrEmpty(TxtEditPro.Text.Trim())) //{ // Response.Write("<script>alert('省不能为空!');window.history.go(-1);</script>"); //} //else if (string.IsNullOrEmpty(TxtEditCity.Text.Trim())) //{ // Response.Write("<script>alert('市不能为空!');window.history.go(-1);</script>"); //} //else string id = Request.QueryString["id"]; int idd = Convert.ToInt32(id); if(string.IsNullOrEmpty(TxtEditArea.Text.Trim())) { Response.Write("<script>alert('地区不能为空!');window.history.go(-1);</script>"); } else { SqlServerProvider conn = new SqlServerProvider(); conn.Open(); string sql = "select * from Y_Area a left outer join Y_City c on c.cityId=a.areaId where cityName='"+TxtEditCity.Text.ToString().Trim()+"'"; if (conn.ExistData(sql)) { Response.Write("<script>alert('该地区已存在!请重新输入');window.history.go(-1);</script>"); } else { conn.Execute("update Y_Area set areaName='" + TxtEditArea.Text.Trim() + "' where areaId='"+idd+"'"); conn.Execute("insert into Y_LogOperation (actionInfo,changeTime,userName) values('修改地区," + TxtEditArea.Text.Trim() + "','" + DateTime.Now + "','" + Session["userName"] + "')"); Response.Write("<script>alert('修改地区成功!');window.history.go(-1);</script>"); } conn.Close(); } }
protected void BtnSavePro_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(TxtProvince.Text.Trim())) { Response.Write("<script>alert('请输入省份!');window.history.go(-1);</script>"); return; } else { SqlServerProvider conn = new SqlServerProvider(); conn.Open(); string sql="select * from Y_Province where provinceName='"+TxtProvince.Text.Trim()+"'"; if (conn.ExistData(sql)) { Response.Write("<script>alert('该省份已存在!请重新输入');window.history.go(-1);</script>"); } else { conn.Execute("insert into Y_Province (provinceName) values ('" + TxtProvince.Text.Trim() + "')"); conn.Execute("insert into Y_LogOperation (actionInfo,changeTime,userName) values('添加省份,"+TxtProvince.Text.Trim()+"','" + DateTime.Now + "','" + Session["userName"] + "')"); Response.Write("<script>alert('添加省份成功!');window.history.go(-1);</script>"); } conn.Close(); } }
protected void BtnReceive_Click(object sender, EventArgs e) { string str = Request["subBox"];//获得选中的checkbox的value,多个会用","隔开 if (string.IsNullOrEmpty(str)) { Response.Write("<script>alert('请先选择!');window.history.go(-1)</script>"); return; } string[] checkbox_id = str.Split(','); SqlServerProvider conn = new SqlServerProvider(); conn.Open(); for (int i = 0; i < checkbox_id.Length; i++) { conn.Execute("update Y_Order set conditionId=2 where orderId='"+checkbox_id[i]+"'"); conn.Execute("insert into Y_OrderChange (orderChangeTypeId,changeTime,userName,orderId) values(3,'"+DateTime.Now+"','"+Session["userName"]+"','"+checkbox_id[i]+"')"); } Response.Write("<script>alert('确认成功,请在未派工单中查看已确认的工单!')</script>"); }
//删除 protected void BtnDelete_Click(object sender, EventArgs e) { string str = Request["subBox"];//获得选中的checkbox的value,多个会用","隔开 if (string.IsNullOrEmpty(str)) { Response.Write("<script>alert('请先选择!')</script>"); return; } string[] checkbox_id = str.Split(','); SqlServerProvider conn = new SqlServerProvider(); conn.Open(); for (int i = 0; i < checkbox_id.Length; i++) { try { conn.Execute("delete from Y_Order where orderId='"+checkbox_id[i]+"'"); conn.Execute("delete from Y_OrderChange where orderId='"+checkbox_id[i]+"'"); conn.Execute("insert into Y_LogOperation (actionInfo,changeTime,userName)values('删除一张工单。','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','"+Session["userName"]+"')");//写操作日志 } catch { Response.Write("<script>alert('删除工单失败!')</script>"); } } Response.Write("<script>alert('删除工单成功!')</script>"); }