/// <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));
}
