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