protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { var zjxm = Request["username"] == null ? "" : Request["username"]; var zjdh = Request["password"] == null ? "" : Request["password"]; Yawei.DataAccess.Database db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); DataSet dszj = db.ExecuteDataSet(" select * from tz_ProjectExpert where zjmc='" + zjxm + "' and lxdh='" + zjdh + "'"); if (dszj.Tables[0].Rows.Count > 0) { string zjmc = this.Server.UrlEncode(dszj.Tables[0].Rows[0]["zjmc"].ToString()); string Guid = this.Server.UrlEncode(dszj.Tables[0].Rows[0]["Guid"].ToString()); string username = "******"; string ps = "123456"; if (username != "" && ps != "") { if (ValidUser(username.Replace("@qingdao.gov.cn", ""), ps)) { //if (!string.IsNullOrWhiteSpace(Request["url"])) // Response.Redirect(Request.QueryString["url"]); //else Response.Redirect("../../DefaultZJ.aspx?zjmc=" + zjmc + "&zjguid=" + Guid); } else { jquery = "alert('用户名或密码错误');"; } } } else { jquery = "alert('姓名或电话错误');"; } } }
private void saveChange(string guid) { Yawei.DataAccess.Database db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); DataSet ds = db.ExecuteDataSet("select guid,xmguid,bglx,bgnr,bgyy,last_val from tz_xmgz where guid='" + guid + "'"); if (ds.Tables == null || ds.Tables.Count <= 0) { return; } if (ds.Tables[0].Rows.Count <= 0) { return; } DataRow row = ds.Tables[0].Rows[0]; string xmguid = row["xmguid"].ToString(); string bglx = row["bglx"].ToString(); string bgnr = row["bgnr"].ToString(); //为附件时refguid 为对应的变更数据guid string bgyy = row["bgyy"].ToString(); string last_val = row["last_val"].ToString(); //变更附件 if (bglx == "建设方案" || bglx == "项目申报表" || bglx == "云资源使用申请表") { string filesign = "tz_Project_Fa"; if (bglx == "建设方案") { filesign = "tz_Project_Fa"; } else if (bglx == "项目申报表") { filesign = "tz_Project_Sbb"; } else if (bglx == "云资源使用申请表") { filesign = "tz_Project_Yzy"; } db.ExecuteNonQuery("delete from Sys_FileBlob where guid in (select guid from Sys_FileInfo where fileSign='" + filesign + "' and refguid='" + xmguid + "');"); //删除以前的附件数据 db.ExecuteNonQuery("delete from Sys_FileInfo where fileSign='" + filesign + "' and refguid='" + xmguid + "'"); DataSet dsFile = db.ExecuteDataSet("select guid from sys_fileinfo where filesign='" + filesign + "' and refguid='" + bgnr + "'"); for (int fileindex = 0; fileindex < dsFile.Tables[0].Rows.Count; fileindex++) { string fileguid = dsFile.Tables[0].Rows[fileindex]["guid"].ToString(); string newfileguid = System.Guid.NewGuid().ToString(); string backFileInfo = " insert into Sys_FileBlob select '" + newfileguid + "','" + xmguid + "',content,neworold from Sys_FileBlob where guid='" + fileguid + "';"; backFileInfo += " insert into Sys_FileInfo(guid,refguid,OrginFileName,NewFileName,ExtName,FileSize,PhysicsPath,FileType,FileDesp,FileSign,Type,UploadDate,ProjGuid,SysStatus) select '"+ newfileguid + "','" + xmguid + "',OrginFileName,NewFileName,ExtName,FileSize,PhysicsPath,FileType,FileDesp,FileSign,Type,UploadDate,ProjGuid,SysStatus from Sys_FileInfo where guid='" + fileguid + "';"; database.ExecuteNonQuery(backFileInfo); } } else { string changesql = ""; if (bglx == "项目名称") { changesql = "proname" + "='" + bgnr + "'"; } else if (bglx == "项目简介") { changesql = "prosummary" + "='" + bgnr + "'"; } else if (bglx == "预估金额") { changesql = "quota" + "='" + bgnr + "'"; } else if (bglx == "资金来源") { changesql = "moneysource" + "='" + bgnr + "'"; } else if (bglx == "项目属性") { changesql = "proproperty" + "='" + bgnr + "'"; } else if (bglx == "项目类型") { changesql = "protype" + "='" + bgnr + "'"; } else if (bglx == "申报时间") { changesql = "startDate" + "='" + bgnr + "'"; } else if (bglx == "联系方式") { changesql = "contactname" + "='" + bgnr.Split(':')[0] + "',contacttel='" + bgnr.Split(':')[1]; //changesql="" } else if (bglx == "是否部署云平台") { changesql = "isincloudplat" + "='" + bgnr + "'"; } string updateProSql = "update tz_Project set " + changesql + " where proguid='" + xmguid + "'"; database.ExecuteNonQuery(updateProSql); } }