/// <summary> /// 同步数据库 /// </summary> /// <param name="context"></param> private void UpdateFromBase(HttpContext context) { Dictionary <string, object> sqlparams = new Dictionary <string, object>(); string sql = ""; string where = context.Request["num"] == null ? "" : context.Request["num"].ToString(); if (where == "") { sql = "update fv_projectbrand p ,fv_sys_brand v set p.brandLogo=v.sys_logo,p.brandDesc=v.sys_desc where p.brandName=v.sys_nane and p.lastChangeTime=p.createTime and p.projectid=" + int.Parse(context.Request["id"].ToString()); } else { sql = "update fv_projectbrand p ,fv_sys_brand v set p.brandLogo=v.sys_logo,p.brandDesc=v.sys_desc where p.brandName=v.sys_nane and p.projectid=" + int.Parse(context.Request["id"].ToString()) + " and p.id in (" + where + ")"; } bool w = SqlManage.OpRecord(sql, sqlparams); string msg = ""; if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }
private void RecordAdd(HttpContext context) { string areaPoints = context.Request.Form["txtArea"].ToString(); string floorLevel = context.Request.Form["hidFloorId"].ToString(); string projectBrandId = context.Request.Form["projectBrandId"].ToString(); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@floorLevel", floorLevel); sqlparams.Add("@areaPoints", areaPoints); string sql = ""; sql = "update fv_projectbrand set floorLevel=@floorLevel,areaPoints=@areaPoints,lastchangetime=now() where id=" + projectBrandId; bool w = SqlManage.OpRecord(sql, sqlparams); string msg = ""; if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }
private void updateEmployeeButton_Click(object sender, RoutedEventArgs e) { String firstName = inputFirstNameBox.Text; String lastName = inputLastNameBox.Text; try { int ID = Convert.ToInt32(inputEmployeeIdBox.Text); SqlManage.UpdateEmployee(ID, firstName, lastName); ClearAll(); outputTextBlock.Text = String.Format("Updated employee {0}, {1} {2}", ID, firstName, lastName); } catch (FormatException) { ClearAll(); outputTextBlock.Text = "Employee id must be a number"; } catch (OverflowException) { ClearAll(); outputTextBlock.Text = "Employee id cannot be that large"; } catch (SqlException ex) { ClearAll(); outputTextBlock.Text = ex.Message; } catch (IOException ex) { ClearAll(); outputTextBlock.Text = ex.Message; } }
/// <summary> /// 删除数据库记录 /// </summary> /// <param name="context"></param> private void DelRecord(HttpContext context) { string where = context.Request["id"] == null ? "" : context.Request["id"].ToString(); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); string sql = ""; string msg = ""; bool w = false; if (where == "") { msg = "数据库网络延迟"; } else { sql = "delete from fv_floor where id in (" + where + ")"; w = SqlManage.OpRecord(sql, sqlparams); } if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }
private void disableEmployeeButton_Click(object sender, RoutedEventArgs e) { String firstName = inputFirstNameBox.Text; String lastName = inputLastNameBox.Text; // verify valid name fields if (String.IsNullOrEmpty(firstName) || String.IsNullOrEmpty(lastName)) { ClearAll(); outputTextBlock.Text = "Please enter both first and last names"; return; } try { SqlManage.DisableEmployee(firstName, lastName); } catch (SqlException ex) { ClearAll(); outputTextBlock.Text = ex.Message; } catch (IOException ex) { ClearAll(); outputTextBlock.Text = ex.Message; } ClearAll(); outputTextBlock.Text = String.Format("Disabled {0} {1}", firstName, lastName); }
private void listAllEmployeesButton_Click(object sender, RoutedEventArgs e) { ClearAll(); String output = SqlManage.ListAllEmployees(); outputTextBlock.Text = output; }
protected void Page_Load(object sender, EventArgs e) { projectId = Request.QueryString["projectId"]; projectBrandId = Request.QueryString["projectBrandId"]; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); string sql = string.Format("select areapoints,floorlevel from fv_projectbrand where id={0} limit 1 ", projectBrandId); DataTable dt = SqlManage.Query(sql, sqlparams).Tables[0]; if (dt != null && dt.Rows.Count > 0) { string spoints = dt.Rows[0][0].ToString(); floorLevelId = dt.Rows[0][1].ToString(); string[] arrayPoints = spoints.Split(';'); if (spoints != "") { foreach (string item in arrayPoints) { strForShow += string.Format("drawPt3{0};", item); } } if (floorLevelId == "") { floorLevelId = "1"; } } if (!IsPostBack) { LoadControl(); } }
protected void btnExport_Click(object sender, EventArgs e) { if (!Directory.Exists(Server.MapPath(@"~/release/" + Label2.Text + "/images"))) { //Directory.CreateDirectory(Server.MapPath(@"~/release/" + txtName.Value));//创建项目根文件夹 Directory.CreateDirectory(Server.MapPath(@"~/release/" + Label2.Text + "/images")); } //Dictionary<string, object> sqlparams = new Dictionary<string, object>(); string logo = ""; if (txtlogo.HasFile) { string timeSign = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); logo = "../images/" + timeSign + txtlogo.FileName; txtlogo.SaveAs(Server.MapPath(@"~/release/" + Label2.Text + "/images/") + timeSign + txtlogo.FileName); } Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@projectId", int.Parse(Label2.Text)); sqlparams.Add("@brandTypeName", txtName.Value); sqlparams.Add("@brandTypeOrder", btOrder.Value); sqlparams.Add("@brandTypeImg", logo); sqlparams.Add("@brandTypeBackColor", ""); sqlparams.Add("@btIsShow", "1"); string sql = ""; if (int.Parse(hidpro.Value) == 0) { sql = "insert into fv_projectbrandtype (projectId,brandTypeName,brandTypeOrder,brandTypeImg,isShow,brandTypeBackColor,createTime,lastChangeTime)" + "values(@projectId,@brandTypeName,@brandTypeOrder,@brandTypeImg,@btIsShow,@brandTypeBackColor,now(),now())"; } else if (logo == "") { sql = "update fv_projectbrandtype set brandTypeName=@brandTypeName,brandTypeOrder=@brandTypeOrder,isShow=@btIsShow,brandTypeBackColor=@brandTypeBackColor,lastChangeTime=NOW() where id=" + int.Parse(hidpro.Value); } else { sql = "update fv_projectbrandtype set brandTypeName=@brandTypeName,brandTypeOrder=@brandTypeOrder,brandTypeImg=@brandTypeImg,isShow=@btIsShow,brandTypeBackColor=@brandTypeBackColor,lastChangeTime=NOW() where id=" + int.Parse(hidpro.Value); } bool w = SqlManage.OpRecord(sql, sqlparams); if (w) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "success", "alert('您操作成功!稍后自动跳转到列表页'); window.location='projectBrandType_query.aspx?projectId=" + Label2.Text + "&projectName=" + Label1.Text + "'", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "error", "alert('数据库连接异常!');", true); } }
private void LoadInfo(int id) { string sql = "select * from fv_projectbrand where id= " + id; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); //sqlparams.Add("@id", id); DataTable table = SqlManage.Query(sql, sqlparams).Tables[0]; if (table.Rows.Count > 0) { txtName.Value = table.Rows[0]["brandName"].ToString(); txtdesc.Value = table.Rows[0]["brandDesc"].ToString(); ddltype.SelectedValue = table.Rows[0]["brandTypeId"].ToString(); hidurl.Value = table.Rows[0]["fvUrl"].ToString(); fvUrl.Value = table.Rows[0]["fvUrl"].ToString(); string imgUrl = table.Rows[0]["brandLogo"].ToString(); if (imgUrl.Contains("..")) { ImageLogo.ImageUrl = Server.MapPath(@"~/release/" + ViewState["proId"].ToString()) + @"/" + imgUrl.Substring(2); } else { ImageLogo.ImageUrl = table.Rows[0]["brandLogo"].ToString(); } string qrcodeUrl = table.Rows[0]["qrcode"].ToString(); if (qrcodeUrl.Contains("..")) { ImageQrcode.ImageUrl = @"~/release/" + ViewState["proId"].ToString() + @"/" + qrcodeUrl.Substring(2); } else { ImageQrcode.ImageUrl = table.Rows[0]["qrcode"].ToString(); } string spurl = table.Rows[0]["sphone"].ToString(); if (spurl.Contains("..")) { Image1.ImageUrl = @"~/release/" + ViewState["proId"].ToString() + @"/" + spurl.Substring(2); } else { Image1.ImageUrl = table.Rows[0]["qrcode"].ToString(); } hidPhone.Value = table.Rows[0]["sphone"].ToString(); ddlisShow.SelectedValue = table.Rows[0]["isShow"].ToString(); localpath.Value = table.Rows[0]["localvpath"].ToString(); sphoneurl.Value = table.Rows[0]["sphoneurl"].ToString(); Text1.Value = table.Rows[0]["floorlevel"].ToString(); telephone.Value = table.Rows[0]["telephone"].ToString(); address.Value = table.Rows[0]["address"].ToString(); brandOrder.Value = table.Rows[0]["brandOrder"].ToString(); // Image1.ImageUrl = table.Rows[0]["sphone"].ToString(); } }
public void ProcessRequest(HttpContext context)//登录验证方法 { context.Response.ContentType = "text/plain"; string uname = context.Request.Form["username"].ToString(); string upwd = context.Request.Form["pwd"].ToString(); //string code = context.Request.Form["yzm"].ToString(); LoginContent login = new LoginContent(); //if (code == (context.Session["randomcode"] == null ? "nulltext" : context.Session["randomcode"].ToString())) //{ string sql = "select count(*) from fv_users where uname=@uname and upwd=@upwd"; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@uname", uname); sqlparams.Add("@upwd", upwd); if (Convert.ToInt32(SqlManage.Exists(sql, sqlparams)) > 0) { context.Session["person"] = uname; login.msg = "suc"; login.url = "/sys/index.aspx"; } else { login.msg = "用户不存在或用户名、密码错误"; login.url = "/login.aspx"; } //SqlManage manage = new SqlManage(); //DataTable dt = manage.GetDataSet(sql, parameter).Tables[0]; //string type = dt.Rows[0]["visible"].ToString(); //if (dt.Rows.Count > 0) //{ // CAS.Model.UserModel model = new CAS.Model.UserModel(); // model.uloginid = dt.Rows[0]["uloginid"].ToString(); // //model.office = dt.Rows[0]["office"].ToString(); // model.utype = dt.Rows[0]["utype"].ToString(); // context.Session["person"] = model; // login.msg = "suc"; // login.url = "validateuser.aspx"; //} //else //{ // login.msg = "用户不存在或用户名、密码错误"; // login.url = "/index.aspx"; //} //} //else //{ // login.msg = "验证码错误"; // login.url = "/index.aspx"; // } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(login)); }
/// <summary> /// 获得列表数据 /// </summary> /// <param name="context"></param> private void LoadMsg(HttpContext context) { int page = context.Request["page"] != "" ? Convert.ToInt32(context.Request.Form["page"]) : 1; int size = context.Request["rows"] != "" ? Convert.ToInt32(context.Request.Form["rows"]) : 1; System.Text.StringBuilder builder = new System.Text.StringBuilder(); builder.Append(@"SELECT a.id,a.brandName ,a.brandImg,a.brandDesc ,a.brandLogo, a.brandVideo ,a.brandOrder, a.brandTypeId ,a.brandTypeName , a.projectId, a.isShow, a.isStar ,a.isShowWay ,a.fvUrl ,a.createTime, a.lastChangeTime,a.floorLevel,a.areaPoints,isnull(a.areaPoints) as hasArea,sum( case isnull(b.walkWay) when 0 then 1 else 0 end) as hasPath " + " FROM fv_projectBrand a left join fv_walkway b on a.id=b.projectBrandId where a.brandTypeId= " + context.Request["projectBtId"].ToString()); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); int total = 0; if (context.Request["cul"] == null && context.Request["where"] == null) { total = SqlManage.Query(@"SELECT a.id,a.brandName ,a.brandImg,a.brandDesc ,a.brandLogo, a.brandVideo ,a.brandOrder, a.brandTypeId ,a.brandTypeName , a.projectId, a.isShow, a.isStar ,a.isShowWay ,a.fvUrl ,a.createTime, a.lastChangeTime,a.floorLevel,a.areaPoints,isnull(a.areaPoints) as hasArea,sum( case isnull(b.walkWay) when 0 then 1 else 0 end) as hasPath " + " FROM fv_projectBrand a left join fv_walkway b on a.id=b.projectBrandId where a.brandTypeId= " + context.Request["projectBtId"].ToString() + " GROUP BY a.id,a.brandName ,a.brandImg,a.brandDesc ,a.brandLogo, a.brandVideo ,a.brandOrder, a.brandTypeId ,a.brandTypeName , a.projectId, a.isShow, a.isStar ,a.isShowWay ,a.fvUrl ,a.createTime, a.lastChangeTime,a.floorLevel,a.areaPoints ", sqlparams).Tables[0].Rows.Count; //return; } else { string where = context.Request["cul"].ToString() + " LIKE '%" + context.Request["where"].ToString() + "%'"; total = SqlManage.Query(@"SELECT a.id,a.brandName ,a.brandImg,a.brandDesc ,a.brandLogo, a.brandVideo ,a.brandOrder, a.brandTypeId ,a.brandTypeName , a.projectId, a.isShow, a.isStar ,a.isShowWay ,a.fvUrl ,a.createTime, a.lastChangeTime,a.floorLevel,a.areaPoints,isnull(a.areaPoints) as hasArea,sum( case isnull(b.walkWay) when 0 then 1 else 0 end) as hasPath " + " FROM fv_projectBrand a left join fv_walkway b on a.id=b.projectBrandId where a.brandTypeId= " + context.Request["projectBtId"].ToString() + " and " + where + " GROUP BY a.id,a.brandName ,a.brandImg,a.brandDesc ,a.brandLogo, a.brandVideo ,a.brandOrder, a.brandTypeId ,a.brandTypeName , a.projectId, a.isShow, a.isStar ,a.isShowWay ,a.fvUrl ,a.createTime, a.lastChangeTime,a.floorLevel,a.areaPoints ", sqlparams).Tables[0].Rows.Count; builder.Append(" and " + where); } builder.Append(" GROUP BY a.id,a.brandName ,a.brandImg,a.brandDesc ,a.brandLogo, a.brandVideo ,a.brandOrder, a.brandTypeId ,a.brandTypeName , a.projectId, a.isShow, a.isStar ,a.isShowWay ,a.fvUrl ,a.createTime, a.lastChangeTime,a.floorLevel,a.areaPoints "); builder.Append(" order by a.brandOrder,lastChangeTime desc LIMIT " + (page - 1) * size + "," + size); DataTable dt = SqlManage.Query(builder.ToString(), sqlparams).Tables[0]; Dictionary <string, object> dictionary = new Dictionary <string, object>(); //List<SOA.MODEL.DocumentModel> list = docmanage.DataTableToList(dt); dictionary.Add("total", total); List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); foreach (DataRow dr in dt.Rows)//每一行信息,新建一个Dictionary<string,object>,将该行的每列信息加入到字典 { Dictionary <string, object> result = new Dictionary <string, object>(); foreach (DataColumn dc in dt.Columns) { result.Add(dc.ColumnName, dr[dc].ToString()); } list.Add(result); } dictionary.Add("rows", list); dt.Dispose(); JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(dictionary)); }
protected void btnExport_Click(object sender, EventArgs e) { //if (!Directory.Exists(Server.MapPath(@"~/release" + txtName.Value))) //{ // Directory.CreateDirectory(Server.MapPath(@"~/release" + txtName.Value));//创建项目根文件夹 // Directory.CreateDirectory(Server.MapPath(@"~/release" + txtName.Value + "/images")); //} Dictionary <string, object> sqlparams = new Dictionary <string, object>(); string logo = ""; if (txtlogo.HasFile) { string timeSign = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); logo = @"/release/" + hidpro.Value + "/images/" + timeSign + txtlogo.FileName; txtlogo.SaveAs(Server.MapPath(@"~/release/" + hidpro.Value + "/images/") + timeSign + txtlogo.FileName); } sqlparams.Add("@projectName", txtName.Value); sqlparams.Add("@projectLogo", logo); sqlparams.Add("@projectDesc", txtdesc.Value); //sqlparams.Add("@projectImg", bImg); //sqlparams.Add("@projectVideo", bVideo); sqlparams.Add("@projectCity", txtcity.Value); //sqlparams.Add("@projectFirstShow", bFirst); string sql = ""; if (int.Parse(hidpro.Value) == 0) { sql = "insert into fv_project (projectName,projectLogo,projectDesc,projectCity,createTime,lastChangeTime) values(@projectName,@projectLogo,@projectDesc,@projectCity,now(),now())"; } else if (logo == "") { sql = "update fv_project set projectName=@projectName,projectDesc=@projectDesc,projectCity=@projectCity,lastChangeTime=NOW() where id=" + int.Parse(hidpro.Value); } else { sql = "update fv_project set projectName=@projectName,projectLogo=@projectLogo,projectDesc=@projectDesc,projectCity=@projectCity,lastChangeTime=NOW() where id=" + int.Parse(hidpro.Value); } bool w = SqlManage.OpRecord(sql, sqlparams); if (w) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "success", "alert('您操作成功!稍后自动跳转到列表页'); window.location='cityProject_query.aspx'", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "error", "alert('数据库连接异常!');", true); } }
protected void btnExport_Click(object sender, EventArgs e) { if (!Directory.Exists(Server.MapPath(@"~/brandTemplate"))) { Directory.CreateDirectory(Server.MapPath(@"~/brandTemplate")); } string bName = txtName.Value; //string bImg = ""; string bDesc = txtdesc.Value; string bLogo = txtlogo.FileName; string bVideo = txtvideo.FileName; int id = hidpro.Value == "0" ? 0 : int.Parse(hidpro.Value); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@sys_nane", bName); //sqlparams.Add("@brandImg", bImg); sqlparams.Add("@sys_desc", bDesc); sqlparams.Add("@sys_logo", @"/brandTemplate/" + bLogo); sqlparams.Add("@sys_video", bVideo); sqlparams.Add("@sys_type", ""); sqlparams.Add("@sys_typeName", ""); if (txtlogo.HasFile) { txtlogo.SaveAs(Server.MapPath(@"~/brandTemplate/" + txtlogo.FileName)); } //else if (txtvideo.HasFile) //{ // txtvideo.SaveAs(Server.MapPath(@"~/brandTemplate/" + txtvideo.FileName)); //} string sql = ""; if (id == 0) { sql = "insert into fv_sys_brand (sys_nane,sys_desc,sys_logo,sys_video,sys_type,sys_typeName,createTime,lastChangeTime) values(@sys_nane,@sys_desc,@sys_logo,@sys_video,@sys_type,@sys_typeName,now(),now())"; } else { sql = "update fv_sys_brand set sys_nane=@sys_nane,sys_desc=@sys_desc,sys_logo=@sys_logo,sys_video=@sys_video,sys_type=@sys_type,sys_typeName=@sys_typeName,lastChangeTime=NOW() where id=" + id; } bool w = SqlManage.OpRecord(sql, sqlparams); if (w) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "success", "alert('您操作成功!稍后自动跳转到列表页'); window.location='sysRecord.aspx'", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "error", "alert('数据库连接异常!');", true); } }
private void LoadInfo(int id) { string sql = "select * from fv_sysbrand where id= " + id; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); //sqlparams.Add("@id", id); DataTable table = SqlManage.Query(sql, sqlparams).Tables[0]; if (table.Rows.Count > 0) { txtName.Value = table.Rows[0]["brandName"].ToString(); txtdesc.Value = table.Rows[0]["brandDesc"].ToString(); } }
private void LoadControl(int pid) { string sql = "select id,brandTypeName from fv_projectbrandType where projectId=" + pid; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); //sqlparams.Add("@id", id); DataTable table = SqlManage.Query(sql, sqlparams).Tables[0]; ddltype.DataSource = table; ddltype.DataTextField = "brandTypeName"; ddltype.DataValueField = "id"; ddltype.DataBind(); ddltype.SelectedValue = Request.QueryString["projectBtId"]; }
private void RecordAdd(HttpContext context) { string floorId = context.Request.Form["floorId"].ToString(); string areaPoints = context.Request.Form["txtArea"].ToString(); string[] arrS = areaPoints.Split(';'); string clientPoint = arrS[0]; //第一个点是C string liftPoint = arrS[arrS.Length - 1]; // 第二个点是L string floorLevel = context.Request.Form["floorLevel"].ToString(); string projectId = context.Request.Form["projectId"].ToString(); int id = string.IsNullOrEmpty(context.Request.Form["clientId"].ToString()) ? 0 : int.Parse(context.Request.Form["clientId"].ToString()); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@floorLevel", floorLevel); sqlparams.Add("@liftPoint", liftPoint); sqlparams.Add("@projectId", projectId); sqlparams.Add("@floorId", floorId); sqlparams.Add("@clientPoint", clientPoint); sqlparams.Add("@nextPointName", areaPoints); string sql = ""; if (id == 0) { //插入client sql = "insert into fv_client (clientPoint,clientName,projectId,floorLevel,floorId,nextPointId,nextPointName,isClient) values(@clientPoint,@clientPoint,@projectId,@floorLevel,@floorId,0,@nextPointName,1);"; //插入lift sql += "insert into fv_client (clientPoint,clientName,projectId,floorLevel,floorId,nextPointId,nextPointName,isClient) values(@liftPoint,@liftPoint,@projectId,@floorLevel,@floorId,0,'',0);"; } else { //c有nextName l没有 sql = "update fv_client set clientPoint=@clientPoint,clientName=@clientPoint,nextPointName=@nextPointName where id=" + id; sql += string.Format("; update fv_client set clientPoint=@liftPoint,clientName=@liftPoint where floorLevel={0} and projectId={1} and isClient=0", floorLevel, projectId); } bool w = SqlManage.OpRecord(sql, sqlparams); string msg = ""; if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }
private void LoadInfo(int id) { string sql = "select * from fv_floor where id= " + id; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); //sqlparams.Add("@id", id); DataTable table = SqlManage.Query(sql, sqlparams).Tables[0]; if (table.Rows.Count > 0) { floorLevel.Value = table.Rows[0]["floorLevel"].ToString(); //txtdesc.Value = table.Rows[0]["sys_desc"].ToString(); //ddltype.SelectedValue = table.Rows[0]["sys_type"].ToString(); } }
private void LoadInfo(int id) { string sql = "select * from fv_project where id= " + id; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); //sqlparams.Add("@id", id); DataTable table = SqlManage.Query(sql, sqlparams).Tables[0]; if (table.Rows.Count > 0) { txtName.Value = table.Rows[0]["projectName"].ToString(); txtdesc.Value = table.Rows[0]["projectDesc"].ToString(); txtcity.Value = table.Rows[0]["projectCity"].ToString(); // ddltype.SelectedValue = table.Rows[0]["sys_type"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { floorId = Request.QueryString["floorId"]; projectId = Request.QueryString["projectId"]; floorLevel = Request.QueryString["floorLevel"]; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); string sql = string.Format("select id,clientPoint from fv_client where isClient=1 and floorId={0} and projectId={1} and floorLevel={2} limit 1 ", floorId, projectId, floorLevel); DataTable dt = SqlManage.Query(sql, sqlparams).Tables[0]; if (dt != null && dt.Rows.Count > 0) { strForShow = string.Format("drawPt3{0};", dt.Rows[0][1].ToString()); clientId = dt.Rows[0][0].ToString(); } }
protected void btnExport_Click(object sender, EventArgs e) { if (!Directory.Exists(Server.MapPath("~/release/" + ViewState["proId"].ToString() + "/images")))//创建项目楼层图片目录 { Directory.CreateDirectory(Server.MapPath("~/release/" + ViewState["proId"].ToString() + "/images")); } string img = ""; if (floorImg.HasFile) { img = @"/release/" + ViewState["proId"].ToString() + "/images/" + floorLevel.Value + "F" + GetExtension(floorImg.FileName); floorImg.SaveAs(Server.MapPath("~/release/" + ViewState["proId"].ToString() + "/images/" + floorLevel.Value + floorImg.FileName)); } Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@floorLevel", floorLevel.Value); sqlparams.Add("@hidProId", ViewState["proId"]); sqlparams.Add("@floorImg", img); string sql = ""; if (int.Parse(hidpro.Value) == 0) { sql = "insert into fv_floor (projectId,floorLevel,floorImg,createTime,lastChangeTime) values(@hidProId,@floorLevel,@floorImg,now(),now())"; } else if (img != "") { sql = "update fv_floor set projectId=@hidProId,floorLevel=@floorLevel,floorImg=@floorImg,lastChangeTime=now() where id=" + int.Parse(hidpro.Value); } else { sqlparams.Remove("@floorImg"); sql = "update fv_floor set projectId=@hidProId,floorLevel=@floorLevel,lastChangeTime=now() where id=" + int.Parse(hidpro.Value); } bool w = SqlManage.OpRecord(sql, sqlparams); if (w) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "success", "alert('您操作成功!稍后自动跳转到列表页'); window.location='setFloor.aspx?projectId=" + ViewState["proId"].ToString() + "&projectName=" + Label1.Text + "'", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "error", "alert('数据库连接异常!');", true); } }
/// <summary> /// 获得列表数据 /// </summary> /// <param name="context"></param> private void LoadMsg(HttpContext context) { int page = context.Request["page"] != "" ? Convert.ToInt32(context.Request.Form["page"]) : 1; int size = context.Request["rows"] != "" ? Convert.ToInt32(context.Request.Form["rows"]) : 1; System.Text.StringBuilder builder = new System.Text.StringBuilder(); builder.Append(@"SELECT * FROM fv_projectbrandtype where projectId=" + context.Request["projectId"].ToString()); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); int total = 0; if (context.Request["cul"] == null && context.Request["where"] == null) { total = SqlManage.Query(@"select * from fv_projectbrandtype where projectId=" + context.Request["projectId"].ToString(), sqlparams).Tables[0].Rows.Count; //return; } else { string where = context.Request["cul"].ToString() + " LIKE '%" + context.Request["where"].ToString() + "%'"; total = SqlManage.Query(@"select * from fv_projectbrandtype where " + where + " and projectId=" + context.Request["projectId"].ToString(), sqlparams).Tables[0].Rows.Count; builder.Append(" and " + where); } builder.Append(" order by brandTypeOrder LIMIT " + (page - 1) * size + "," + size); DataTable dt = SqlManage.Query(builder.ToString(), sqlparams).Tables[0]; Dictionary <string, object> dictionary = new Dictionary <string, object>(); //List<SOA.MODEL.DocumentModel> list = docmanage.DataTableToList(dt); dictionary.Add("total", total); List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); foreach (DataRow dr in dt.Rows)//每一行信息,新建一个Dictionary<string,object>,将该行的每列信息加入到字典 { Dictionary <string, object> result = new Dictionary <string, object>(); foreach (DataColumn dc in dt.Columns) { result.Add(dc.ColumnName, dr[dc].ToString()); } list.Add(result); } dictionary.Add("rows", list); dt.Dispose(); JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(dictionary)); }
protected void Page_Load(object sender, EventArgs e) { floorId = Request.QueryString["floorId"]; projectId = Request.QueryString["projectId"]; projectBrandId = Request.QueryString["projectBrandId"]; //无用 floorLevel = Request.QueryString["floorLevel"]; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); //客户端的点 b.isClient=1 nextPointName对应C TO 电梯的路径 string sql = string.Format("select id,clientPoint,nextPointName from fv_client where isClient=1 and floorId={0} and projectId={1} and floorLevel={2} limit 1 ", floorId, projectId, floorLevel); DataTable dt = SqlManage.Query(sql, sqlparams).Tables[0]; if (dt != null && dt.Rows.Count > 0) { clientId = dt.Rows[0][0].ToString(); string ctoLPath = dt.Rows[0][2].ToString(); if (!string.IsNullOrEmpty(ctoLPath)) { string[] arrS = ctoLPath.Split(';'); foreach (string item in arrS) { strForShow += string.Format("drawPt3{0};", item); } //strForClient = string.Format("drawPt3{0};", dt.Rows[0][1].ToString()); //strForShow += strForClient; } //floorLevel = dt.Rows[0][2].ToString(); } // //路径的点 // sql = string.Format("select c.walkWay from fv_projectbrand a,fv_client b,fv_walkway c " + //"where a.projectId=b.projectId and a.floorLevel=b.floorLevel and a.id=c.projectBrandId and b.id=c.fromClientId and b.isClient=1 and a.id={0} limit 1 ", projectBrandId); // dt = SqlManage.Query(sql, sqlparams).Tables[0]; // if (dt != null && dt.Rows.Count > 0) // { // strForShow = ""; // string paths = dt.Rows[0][0].ToString(); // string[] arrayPaths = paths.Split(';'); // foreach (string item in arrayPaths) // { // strForShow += string.Format("drawPt3{0};", item); // } }
protected void Page_Load(object sender, EventArgs e) { projectId = Request.QueryString["projectId"]; projectBrandId = Request.QueryString["projectBrandId"]; floorLevel = Request.QueryString["floorLevel"]; Dictionary <string, object> sqlparams = new Dictionary <string, object>(); //客户端的点 b.isClient=1 string sql = string.Format("select b.id,b.clientPoint,a.floorLevel from fv_projectbrand a,fv_client b " + "where a.projectId=b.projectId and a.floorLevel=b.floorLevel and b.isClient=1 and a.id={0}", projectBrandId); DataTable dt = SqlManage.Query(sql, sqlparams).Tables[0]; if (dt != null && dt.Rows.Count > 0) { clientId = dt.Rows[0][0].ToString(); strForClient = string.Format("drawPt3{0};", dt.Rows[0][1].ToString()); strForShow += strForClient; floorLevel = dt.Rows[0][2].ToString(); //重新获取一下,免得数据不准确 } else { Response.Write("<script>alert('请先设置该楼层客户端位置和该品牌区域信息!');window.close();</script>"); } //路径的点 sql = string.Format("select c.walkWay from fv_projectbrand a,fv_client b,fv_walkway c " + "where a.projectId=b.projectId and a.floorLevel=b.floorLevel and a.id=c.projectBrandId and b.id=c.fromClientId and b.isClient=1 and a.id={0} limit 1 ", projectBrandId); dt = SqlManage.Query(sql, sqlparams).Tables[0]; if (dt != null && dt.Rows.Count > 0) { strForShow = ""; string paths = dt.Rows[0][0].ToString(); string[] arrayPaths = paths.Split(';'); foreach (string item in arrayPaths) { strForShow += string.Format("drawPt3{0};", item); } } //if (!IsPostBack) //{ // LoadControl(); //} }
/// <summary> /// 增更数据库 /// </summary> /// <param name="context"></param> private void RecordAdd(HttpContext context) { string bName = context.Request.Form["txtName"].ToString(); string bImg = context.Request.Form["txtImg"].ToString(); string bDesc = context.Request.Form["txtdsc"].ToString(); string bLogo = context.Request.Form["txtlogo"].ToString(); string bVideo = context.Request.Form["txtvideo"].ToString(); string bCity = context.Request.Form["txtcity"].ToString(); string bFirst = context.Request.Form["txtfirst"].ToString(); int id = context.Request.Form["hid"].ToString() == "" ? 0 : int.Parse(context.Request.Form["hid"].ToString()); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@projectName", bName); sqlparams.Add("@projectLogo", bLogo); sqlparams.Add("@projectDesc", bDesc); sqlparams.Add("@projectImg", bImg); sqlparams.Add("@projectVideo", bVideo); sqlparams.Add("@projectCity", bCity); sqlparams.Add("@projectFirstShow", bFirst); string sql = ""; if (id == 0) { sql = "insert into fv_project (projectName,projectLogo,projectDesc,projectImg,projectVideo,projectCity,projectFirstShow,createTime,lastChangeTime) values(@projectName,@projectLogo,@projectDesc,@projectImg,@projectVideo,@projectCity,@projectFirstShow,now(),now())"; } else { sql = "update fv_project set projectName=@projectName,projectLogo=@projectLogo,projectDesc=@projectDesc,projectImg=@projectImg,projectVideo=@projectVideo,projectCity=@projectCity,projectFirstShow=@projectFirstShow,lastChangeTime=NOW() where id=" + id; } bool w = SqlManage.OpRecord(sql, sqlparams); string msg = ""; if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }
/// <summary> /// 同步数据库 /// </summary> /// <param name="context"></param> private void UpdateFromBase(HttpContext context) { Dictionary <string, object> sqlparams = new Dictionary <string, object>(); string sql = "update fv_projectbrandtype p ,fv_sysbrand v set p.brandTypeImg=v.brandLogo where brandTypeName=v.brandName and p.projectid=" + int.Parse(context.Request["id"].ToString()); bool w = SqlManage.OpRecord(sql, sqlparams); string msg = ""; if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }
private void LoadControl() { Dictionary <string, object> sqlparams = new Dictionary <string, object>(); DataTable dt = SqlManage.Query("select id,floorlevel from fv_floor where projectId=" + projectId, sqlparams).Tables[0]; floorLevel.DataSource = dt; floorLevel.DataValueField = "floorlevel"; floorLevel.DataTextField = "floorlevel"; floorLevel.DataBind(); if (dt.Rows.Count > 0) { floorLevel.Value = floorLevelId; hidFloorId.Value = floorLevelId; } else { Response.Write("<script>alert('请先设置该楼层信息!');window.close();</script>"); } }
/// <summary> /// 增更数据库 /// </summary> /// <param name="context"></param> private void RecordAdd(HttpContext context) { string bName = context.Request.Form["txtName"].ToString(); string bImg = context.Request.Form["txtImg"].ToString(); string bDesc = context.Request.Form["txtdsc"].ToString(); string bLogo = context.Request.Form["txtlogo"].ToString(); string bVideo = context.Request.Form["txtvideo"].ToString(); int id = context.Request.Form["hid"].ToString() == "" ? 0 : int.Parse(context.Request.Form["hid"].ToString()); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@brandName", bName); sqlparams.Add("@brandImg", bImg); sqlparams.Add("@brandDesc", bDesc); sqlparams.Add("@brandLogo", bLogo); sqlparams.Add("@brandVideo", bVideo); string sql = ""; if (id == 0) { sql = "insert into fv_sysbrand (brandName,brandImg,brandDesc,brandLogo,brandVideo,createTime,lastChangeTime) values(@brandName,@brandImg,@brandDesc,@brandLogo,@brandVideo,now(),now())"; } else { sql = "update fv_sysbrand set brandName=@brandName,brandImg=@brandImg,brandDesc=@brandDesc,brandLogo=@brandLogo,brandVideo=@brandVideo,lastChangeTime=NOW() where id=" + id; } bool w = SqlManage.OpRecord(sql, sqlparams); string msg = ""; if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }
private void RecordAdd(HttpContext context) { string floorLevel = context.Request.Form["floorLevel"].ToString(); string projectId = context.Request.Form["projectId"].ToString(); string floorId = context.Request.Form["floorId"].ToString(); string clientPoint = context.Request.Form["clientPoint"].ToString(); int id = context.Request.Form["hid"].ToString() == "" ? 0 : int.Parse(context.Request.Form["hid"].ToString()); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@floorLevel", floorLevel); sqlparams.Add("@projectId", projectId); sqlparams.Add("@floorId", floorId); sqlparams.Add("@clientPoint", clientPoint); string sql = ""; if (id == 0) { sql = "insert into fv_client (clientPoint,clientName,projectId,floorLevel,floorId,nextPointId,nextPointName,isclient) values(@clientPoint,@clientPoint,@projectId,@floorLevel,@floorId,0,'',0)"; } else { sql = "update fv_client set clientPoint=@clientPoint,clientName=@clientPoint where id=" + id; } bool w = SqlManage.OpRecord(sql, sqlparams); string msg = ""; if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }
private void createEmployeeButton_Click(object sender, RoutedEventArgs e) { try { String firstName = inputFirstNameBox.Text; String lastName = inputLastNameBox.Text; SqlManage.CreateEmployee(nextEmployeeIdNum, firstName, lastName); nextEmployeeIdNum++; ClearAll(); outputTextBlock.Text = firstName + " " + lastName + " added."; } catch (SqlException ex) { ClearAll(); outputTextBlock.Text = ex.Message; } catch (IOException ex) { ClearAll(); outputTextBlock.Text = ex.Message; } }
private void RecordAdd(HttpContext context) { string clientId = context.Request.Form["clientId"].ToString(); string areaPoints = context.Request.Form["txtArea"].ToString(); string floorLevel = context.Request.Form["floorLevel"].ToString(); string projectBrandId = context.Request.Form["projectBrandId"].ToString(); Dictionary <string, object> sqlparams = new Dictionary <string, object>(); sqlparams.Add("@walkWay", areaPoints); string sql = ""; sql = string.Format("select count(*) from fv_walkway where projectBrandId={0} and fromClientId={1}", projectBrandId, clientId); int rtn = Convert.ToInt32(SqlManage.Exists(sql, sqlparams)); if (rtn > 0) { sql = string.Format("update fv_walkway set walkWay=@walkWay where projectBrandId={0} and fromClientId={1}", projectBrandId, clientId); } else { sql = string.Format("insert into fv_walkway (projectBrandId,walkWay,fromClientId) values ({0},@walkWay,{1})", projectBrandId, clientId); } bool w = SqlManage.OpRecord(sql, sqlparams); string msg = ""; if (w) { msg = "suc"; } else { msg = "数据库连接超时或出现未知错误"; } JavaScriptSerializer javascriptSerializer = new JavaScriptSerializer(); context.Response.Write(javascriptSerializer.Serialize(msg)); }