/// <summary>
/// 保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string ysmm = Security.Encode(this.GetRequestStr("txtysmm")); //原密码
string xmm = Security.Encode(this.GetRequestStr("txtxmm")); //新密码
string zsyc = Security.Encode(this.GetRequestStr("txtzsyc")); //确认密码
if (xmm != zsyc)
{
new MessageBox(this).Show("两次密码输入不一致！");
return;
}
//更新密码
int line = dal.UpdateUserPwd(xmm, LoginUser.GetUserId);
if (line > 0)
{
//Alert("编辑成功", "UserListList.aspx");
new MessageBox(Page).ShowAndJump("密码修改成功!", "../../Manage_Center.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "用户密码修改成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("修改密码失败！");
}
}
//档案归档
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.drop_FileLibraryName.SelectedItem.Text == "")
{
new MessageBox(this.Page).Show("请选择档案库室！");
return;
}
ArrayList alsql = new ArrayList();
string sqlStr = ""; //移交记录归档
sqlStr = " update FileTransfer set sjzt=3,Gdr='" + LoginUser.GetUserName + "',Gdsj='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id='" + HiddenFieldyj.Value + "' ";
alsql.Add(sqlStr);
string strupdate = ""; //移交档案归档
strupdate = " update FileEnter set FileLibraryID='" + this.drop_FileLibraryName.SelectedValue + "',FileLibraryName='" + this.drop_FileLibraryName.SelectedItem.Text + "',FileLibraryData='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',FileTransferSJLX=2 where id='" + HiddenFieldda.Value + "' ";
alsql.Add(strupdate);
Boolean flag = TSQLServer.execTriggerAll(alsql);
if (flag == true)
{
new MessageBox(Page).ShowAndJump("执法档案归档成功!", "Manage_Center.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "归档执法档案" + this.HiddenFieldda.Value + "", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(Page).ShowAndJump("执法档案归档失败!", "Manage_Center.aspx");
}
}
/// <summary>
/// 保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
//获取界面数值赋值给model对象
int id = this.GetRequestInt("id");
string txtFileDirName = this.txtFileDirName.Text.Trim();// this.GetRequestStr("txtFileDirName").Trim();
if (txtFileDirName == "")
{
new MessageBox(this).Show("请输入档案目录名称！");
return;
}
int line = 0; //定义增加受影响的行数
//判断是否存在数据信息
if (this.GetRequestInt("id") > 0)
{
line = dal.Update(
txtFileDirName, LoginUser.GetUserId, LoginUser.GetUserName, DateTime.Now.ToString(), id);
if (line > 0)
{
//Alert("编辑成功", "FileClassList.aspx");
new MessageBox(Page).ShowAndJump("编辑成功!", "FileDirectoryList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "档案目录编辑成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("编辑失败！");
}
//Alert("编辑失败", true);
}
else
{
if (dal.GetDataTable(" and FileDirName='" + txtFileDirName + "'").Rows.Count > 0)
{
new MessageBox(this).Show("档案目录名称已存在！");
return;
}
line = dal.Insert(
txtFileDirName, LoginUser.GetUserId, LoginUser.GetUserName, DateTime.Now.ToString());
if (line > 0)
{
//Alert("增加成功", "FileClassList.aspx");
new MessageBox(Page).ShowAndJump("增加成功!", "FileDirectoryList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "档案目录增加成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("增加失败！");
}
//Alert("增加失败", true);
}
}
//单个删除
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
Label cb_id = (Label)e.Item.FindControl("lb_id");
switch (e.CommandName.ToLower())
{
case "del":
dal.Delete(cb_id.Text);
new MessageBox(Page).ShowAndJump("删除成功!", "UserListList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "用户删除", LoginUser.GetUserId, LoginUser.GetUserName);
this.BindDaSource();
break;
}
}
//批量接收
protected void btnCheckSave_Click(object sender, EventArgs e)
{
string ids = "0";
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = ((Label)rptList.Items[i].FindControl("lb_id")).Text.ToInt32();
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("cb_id");
if (cb.Checked)
{
ids += "," + id;
}
}
DataTable dttf = daltf.GetDataTable(" and id in (" + ids + ") ");
ArrayList alsql = new ArrayList();
Boolean flag = false;
if (AccessDataSet.HasDataTable(dttf))
{
foreach (DataRow item in dttf.Rows)
{
string sqlStr = ""; //接收移交记录
sqlStr = " update FileTransfer set sjzt=2,Jssj='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',AcceptPeople='" + LoginUser.GetUserName + "',AcceptUnit='" + LoginUser.OrganizerName + "' where id='" + item["id"] + "' ";
alsql.Add(sqlStr);
string strupdate = ""; //接收更新档案状态
DataRow drdg = fedal.GetRow(item["FileEnterID"]);
if (drdg != null)
{
strupdate = " update FileEnter set ReceiptTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',oldEnteCountyId='" + drdg["EnteCountyId"] + "',oldEnteUserName='******',EnteCountyId='" + LoginUser.CountyId + "',EnteUserName='******',EnforcementID_new='" + LoginUser.OrganizerId + "',EnforcementName_new='" + LoginUser.OrganizerName + "',FileLibraryID_old='" + drdg["FileLibraryID"] + "',FileLibraryName_old='" + drdg["FileLibraryName"] + "',FileLibraryID='',FileLibraryName='',FileTransferSJLX=1,FileTransferID='" + item["id"] + "' where id='" + item["FileEnterID"] + "' ";
}
alsql.Add(strupdate);
}
flag = TSQLServer.execTriggerAll(alsql);
}
if (flag == true)
{
new MessageBox(Page).ShowAndJump("批量移交支队成功!", "Manage_Center.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "案卷档案[" + ids + "]批量移交支队", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(Page).ShowAndJump("批量移交支队失败!", "Manage_Center.aspx");
}
this.BindDaSource();
}
//批量删除
protected void lbtnDel_Click(object sender, EventArgs e)
{
string ids = "0";
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = ((Label)rptList.Items[i].FindControl("lb_id")).Text.ToInt32();
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("cb_id");
if (cb.Checked)
{
ids += "," + id;
}
}
dal.DeleteAllIn(ids);
new MessageBox(Page).ShowAndJump("批量删除成功!", "UserListList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "用户删除", LoginUser.GetUserId, LoginUser.GetUserName);
this.BindDaSource();
}
//批量移交支队
protected void lbtnFileTransfer_Click(object sender, EventArgs e)
{
string ids = "0";
for (int i = 0; i < rptyjzdList.Items.Count; i++)
{
int id = ((Label)rptyjzdList.Items[i].FindControl("lb_id")).Text.ToInt32();
CheckBox cb = (CheckBox)rptyjzdList.Items[i].FindControl("cb_id");
if (cb.Checked)
{
ids += "," + id;
}
}
DataTable dttf = dal.GetDataTableyjzd(" and id in (" + ids + ") ");
ArrayList alsql = new ArrayList();
Boolean flag = false;
if (AccessDataSet.HasDataTable(dttf))
{
foreach (DataRow item in dttf.Rows)
{
string sqlStr = ""; //添加移交记录
sqlStr = " insert into FileTransfer(FileEnterID,FileClassID,FileClassName,FileEnterName,TransferPeople,TransferUnit,AcceptSzqxdm,TransferDate,OperateTime,Remark,UserID,Username,sjzt,SZQXDM,Yjlx) values ('" + item["id"].ToString() + "','" + item["FileClassID"].ToString() + "','" + item["FName"].ToString() + "','" + item["FilesName"].ToString() + "','" + LoginUser.GetUserName + "','" + LoginUser.OrganizerName + "','420100','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','','" + LoginUser.GetUserId + "','" + LoginUser.GetUserName + "',0,'" + LoginUser.CountyId + "',1) ";
alsql.Add(sqlStr);
string strupdate = ""; //更新移交时间
strupdate = " update FileEnter set FileTransferDate='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',sjlx=3 where id='" + item["id"].ToString() + "' ";
alsql.Add(strupdate);
}
flag = TSQLServer.execTriggerAll(alsql);
}
if (flag == true)
{
new MessageBox(Page).ShowAndJump("批量移交支队成功!", "FileTransferyjzd.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "案卷档案[" + ids + "]批量移交支队", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(Page).ShowAndJump("批量移交支队失败!", "FileTransferyjzd.aspx");
}
this.BindDaSource();
}
//单个删除
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
Label cb_id = (Label)e.Item.FindControl("lb_id");
switch (e.CommandName.ToLower())
{
case "del":
//dal.Delete(cb_id.Text);
dal.DeleteUpdate("8", cb_id.Text);
//Alert("删除成功", "FileClassList.aspx");
new MessageBox(Page).ShowAndJump("删除成功!", "FileEnterList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "案卷档案删除", LoginUser.GetUserId, LoginUser.GetUserName);
this.BindDaSource();
break;
case "edit":
Response.Redirect("FileEnterEdit.aspx?id=" + cb_id.Text + "");
break;
}
}
//单个移交支队
protected void rptyjzdList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
Label cb_id = (Label)e.Item.FindControl("lb_id");
switch (e.CommandName.ToLower())
{
case "transfer":
DataRow drdg = dal.GetRow(cb_id.Text);
if (drdg != null)
{
ArrayList alsql = new ArrayList();
string sqlStr = ""; //添加移交记录
sqlStr = " insert into FileTransfer(FileEnterID,FileClassID,FileClassName,FileEnterName,TransferPeople,TransferUnit,AcceptSzqxdm,TransferDate,OperateTime,Remark,UserID,Username,sjzt,SZQXDM,Yjlx) values ('" + drdg["id"].ToString() + "','" + drdg["FileClassID"].ToString() + "','" + drdg["FName"].ToString() + "','" + drdg["FilesName"].ToString() + "','" + LoginUser.GetUserName + "','" + LoginUser.OrganizerName + "','420100','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','','" + LoginUser.GetUserId + "','" + LoginUser.GetUserName + "',0,'" + LoginUser.CountyId + "',1) ";
alsql.Add(sqlStr);
string strupdate = ""; //更新移交时间
strupdate = " update FileEnter set FileTransferDate='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',sjlx=3 where id='" + drdg["id"].ToString() + "' ";
alsql.Add(strupdate);
Boolean flag = TSQLServer.execTriggerAll(alsql);
if (flag == true)
{
new MessageBox(Page).ShowAndJump("执法档案" + drdg["FilesName"].ToString() + "移交支队成功!", "FileTransferyjzd.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "执法档案" + drdg["id"].ToString() + "+" + drdg["FilesName"].ToString() + "移交支队", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(Page).ShowAndJump("执法档案" + drdg["FilesName"].ToString() + "移交支队失败!", "FileTransferyjzd.aspx");
}
}
else
{
new MessageBox(Page).ShowAndJump("执法档案" + drdg["FilesName"].ToString() + "移交支队失败!", "FileTransferyjzd.aspx");
}
this.BindDaSource();
break;
}
}
//操作事件--接收档案
protected void LinkButtonALL_Command(object sender, CommandEventArgs e)
{
string CommandName;
string[] CurrentValueId;
CurrentValueId = e.CommandArgument.ToString().Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
CommandName = e.CommandName;
//接收档案
if (CommandName.ToString() == "FileTransfer")
{
DataRow drdg = fedal.GetRow(CurrentValueId[1]);
if (drdg != null)
{
ArrayList alsql = new ArrayList();
string sqlStr = ""; //接收移交记录
sqlStr = " update FileTransfer set sjzt=2,Jssj='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',AcceptPeople='" + LoginUser.GetUserName + "',AcceptUnit='" + LoginUser.OrganizerName + "' where id='" + CurrentValueId[0] + "' ";
alsql.Add(sqlStr);
string strupdate = ""; //接收更新档案状态
strupdate = " update FileEnter set ReceiptTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',oldEnteCountyId='" + drdg["EnteCountyId"] + "',oldEnteUserName='******',EnteCountyId='" + LoginUser.CountyId + "',EnteUserName='******',EnforcementID_new='" + LoginUser.OrganizerId + "',EnforcementName_new='" + LoginUser.OrganizerName + "',FileLibraryID_old='" + drdg["FileLibraryID"] + "',FileLibraryName_old='" + drdg["FileLibraryName"] + "',FileLibraryID='',FileLibraryName='',FileTransferSJLX=1,FileTransferID='" + CurrentValueId[0] + "' where id='" + CurrentValueId[1] + "' ";
alsql.Add(strupdate);
Boolean flag = TSQLServer.execTriggerAll(alsql);
if (flag == true)
{
new MessageBox(Page).ShowAndJump("执法档案接收成功!", "Manage_Center.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "接收执法档案" + CurrentValueId[0] + "", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(Page).ShowAndJump("执法档案接收失败!", "Manage_Center.aspx");
}
}
else
{
new MessageBox(Page).ShowAndJump("执法档案接收失败!", "Manage_Center.aspx");
}
}
}
//拒收
protected void btnCheckSavejs_Click(object sender, EventArgs e)
{
ArrayList alsql = new ArrayList();
string sqlStr = ""; //拒收移交记录
sqlStr = " update FileTransfer set sjzt=1,Jsyy='" + this.txt_jsyy.Text + "',AcceptPeople='" + LoginUser.GetUserId + "',AcceptUnit='" + LoginUser.OrganizerName + "' where id='" + this.HiddenFieldjs.Value + "' ";
alsql.Add(sqlStr);
string strupdate = ""; //拒收更新档案状态
strupdate = " update FileEnter set sjlx=0 where id='" + this.HiddenFieldjsda.Value + "' ";
alsql.Add(strupdate);
Boolean flag = TSQLServer.execTriggerAll(alsql);
if (flag == true)
{
new MessageBox(Page).ShowAndJump("执法档案拒收成功!", "Manage_Center.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "拒收执法档案" + this.HiddenFieldjsda.Value + "", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(Page).ShowAndJump("执法档案拒收失败!", "Manage_Center.aspx");
}
}
/// <summary>
/// 保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
//获取界面数值赋值给model对象
int id = this.GetRequestInt("id");
//string txtPunishTypeName = this.GetRequestStr("txtPunishTypeName");
string txtPunishTypeName = this.txtPunishTypeName.Text.Trim();
if (txtPunishTypeName == "")
{
new MessageBox(this).Show("请输入处罚类型名称！");
return;
}
string drop_FileClassName = this.drop_FileClassName.SelectedValue;
if (drop_FileClassName == "")
{
new MessageBox(this).Show("请选择档案类别！");
return;
}
int line = 0; //定义增加受影响的行数
if (this.GetRequestInt("id") > 0)
{
line = dal.Update(
txtPunishTypeName, this.drop_FileClassName.SelectedItem.Text, drop_FileClassName, LoginUser.GetUserId, LoginUser.GetUserName, DateTime.Now.ToString(), id);
if (line > 0)
{
//Alert("编辑成功", "FileClassList.aspx");
new MessageBox(Page).ShowAndJump("编辑成功!", "PunishTypeList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "处罚类型编辑成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("编辑失败！");
}
//Alert("编辑失败", true);
}
else
{
//判断是否存在数据信息
if (dal.GetDataTable(" and PunishTypeName='" + txtPunishTypeName + "'").Rows.Count > 0)
{
new MessageBox(this).Show("处罚类型名称已存在！");
return;
}
line = dal.Insert(
txtPunishTypeName, this.drop_FileClassName.SelectedItem.Text, drop_FileClassName, LoginUser.GetUserId, LoginUser.GetUserName, DateTime.Now.ToString());
if (line > 0)
{
//Alert("增加成功", "FileClassList.aspx");
new MessageBox(Page).ShowAndJump("增加成功!", "PunishTypeList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "处罚类型增加成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("增加失败！");
}
//Alert("增加失败", true);
}
}
/// <summary>
/// 保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
//获取界面数值赋值给model对象
int id = this.GetRequestInt("id");
string userName = this.txtuserName.Text.Trim(); //this.GetRequestStr("txtuserName");
string passWord = Security.Encode(this.GetRequestStr("txtpassWord").Trim());
string userRealName = this.GetRequestStr("txtuserRealName");
string userTel = this.GetRequestStr("txtuserTel");
int userState = this.GetRequestInt("txtuserState");
string userMail = this.GetRequestStr("txtuserMail");
string userPost = this.txtuserPost.SelectedValue;
string userqxdm = this.drop_qxdm.SelectedValue;
if (userqxdm == "")
{
new MessageBox(this).Show("请选择所属支队或大队！");
return;
}
DateTime userLastLogin = DateTime.Now;
int line = 0; //定义增加受影响的行数
//判断是否存在数据信息
if (this.GetRequestInt("id") > 0)
{
line = dal.Update(
userName,
passWord,
userRealName,
userTel,
userState,
userMail,
userLastLogin,
userPost, userqxdm, LoginUser.GetUserId, LoginUser.GetUserName, DateTime.Now.ToString(), id);
if (line > 0)
{
//Alert("编辑成功", "UserListList.aspx");
new MessageBox(Page).ShowAndJump("编辑成功!", "UserListList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "用户编辑成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("编辑失败！");
}
//Alert("编辑失败", true);
}
else
{
line = dal.Insert(
userName,
passWord,
userRealName,
userTel,
userState,
userMail,
userLastLogin,
userPost,
userqxdm, LoginUser.GetUserId, LoginUser.GetUserName, DateTime.Now.ToString());
if (line > 0)
{
//Alert("增加成功", "UserListList.aspx");
new MessageBox(Page).ShowAndJump("增加成功!", "UserListList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "用户增加成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
//Alert("增加失败", true);
new MessageBox(this.Page).Show("增加失败！");
}
}
}
/// <summary>
/// 保存档案管理录入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int FileClassID = 0;
for (int i = 0; i < rptList.Items.Count; i++)
{
int fid = ((Label)rptList.Items[i].FindControl("FileClassID")).Text.ToInt32();
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("cl1_000");
if (cb.Checked)
{
FileClassID = fid;
}
}
int FileDirectoryID = this.GetRequestInt("FileDirectoryID");
int SaveDeadlineID = this.GetRequestInt("SaveDeadlineID");
//获取界面数值赋值给model对象
string FileFondsNo = this.GetRequestStr("FileFondsNo"); //"QZH-" + DateTime.Now.ToStr("yyyyMMddhhmmss") + "01";
string FilesNum = this.GetRequestStr("FilesNum");
string EnterPeople = this.GetRequestStr("txtEnterPeople"); //档案录入人
DateTime EnterDate = Convert.ToDateTime(this.GetRequestStr("fStarttime")); //档案录入时间自动生成
string BuildAds = this.GetRequestStr("BuildAds");
string BuildCheckT = this.GetRequestStr("BuildCheckT");
string BuildFilingT = this.GetRequestStr("BuildFilingT");
string BuildArea = this.GetRequestStr("BuildArea");
int BuildALicense = this.GetRequestInt("BuildALicense");
string CheckAds = this.GetRequestStr("CheckAds");
string CheckNature = this.GetRequestStr("CheckNature");
int CheckResult = this.GetRequestInt("CheckResult");
string ComplainAds = this.GetRequestStr("ComplainAds");
int ComplainResult = this.GetRequestInt("ComplainResult");
string FireNature = this.GetRequestStr("FireNature");
string FireArea = this.GetRequestStr("FireArea");
string FireEstateLoss = this.GetRequestStr("FireEstateLoss");
int FireHPeople = this.GetRequestInt("FireHPeople");
int FireDPeople = this.GetRequestInt("FireDPeople");
string MassSportsAds = this.GetRequestStr("MassSportsAds");
int MassSportsResult = this.GetRequestInt("MassSportsResult");
//string PunishTypeID = this.GetRequestStr("PunishTypeID");
string PunishTypeID = "|";
if (PunishTypeID0.Checked == true)
{
PunishTypeID += "0|";
}
if (PunishTypeID1.Checked == true)
{
PunishTypeID += "1|";
}
if (PunishTypeID2.Checked == true)
{
PunishTypeID += "2|";
}
if (PunishTypeID3.Checked == true)
{
PunishTypeID += "3|";
}
if (PunishTypeID4.Checked == true)
{
PunishTypeID += "4|";
}
double PunishFinePay = this.GetRequestDouble("PunishFinePay");
string PunishParts = this.GetRequestStr("PunishParts");
string TempClose = this.GetRequestStr("TempClose");
int TempDay = this.GetRequestInt("TempDay");
string ForceRunAds = this.GetRequestStr("ForceRunAds");
string ForcePunish = this.GetRequestStr("ForcePunish");
string ApplyReviewPeople = this.GetRequestStr("ApplyReviewPeople");
string CountryPayAds = this.GetRequestStr("CountryPayAds");
string PenalDocSex = this.GetRequestStr("PenalDocSex");
string PenalDocBirthday = this.GetRequestStr("PenalDocBirthday");
string PenalDocNation = this.GetRequestStr("PenalDocNation");
string PenalDocAds = this.GetRequestStr("PenalDocAds");
string PenalDocCrimeAds = this.GetRequestStr("PenalDocCrimeAds");
int EnforcementID = Convert.ToInt32(this.drop_EnforcementName.SelectedItem.Value);
string EnforcementName = this.drop_EnforcementName.SelectedItem.Text;
string EnforcementPeople = this.GetRequestStr("txt_EnforcementPeople");
string EnforcementPeople2 = this.GetRequestStr("txt_EnforcementPeople2");
string EnforcementDate = this.GetRequestStr("txt_EnforcementDate");
string EnforcementDate2 = this.GetRequestStr("txt_EnforcementDate2");
string BuildUnitName = this.GetRequestStr("BuildUnitName");
string BuildItemName = this.GetRequestStr("BuildItemName");
string CheckUnitName = this.GetRequestStr("CheckUnitName");
string ComplainPeople = this.GetRequestStr("ComplainPeople");
string ComplainNPeople = this.GetRequestStr("ComplainNPeople");
string CompainN = this.GetRequestStr("CompainN");
string MassSportsPeople = this.GetRequestStr("MassSportsPeople");
string MassSportName = this.GetRequestStr("MassSportName");
string FireAds = this.GetRequestStr("FireAds");
string FireUnitName = this.GetRequestStr("FireUnitName");
string FireDateTime = this.GetRequestStr("FireDateTime");
string FireN = this.GetRequestStr("FireN");
string PunishMain = this.GetRequestStr("PunishMain");
string PunishWhy = string.Empty; //= this.GetRequestStr("PunishWhy");
for (int i = 0; i < rxwhy.Items.Count; i++)
{
string fid2 = ((Label)rxwhy.Items[i].FindControl("PunishWhy")).Text;
CheckBox cb2 = (CheckBox)rxwhy.Items[i].FindControl("ckb6");
if (cb2.Checked)
{
PunishWhy = fid2;
}
}
string TempUintName = this.GetRequestStr("TempUintName");
string TempN = this.GetRequestStr("TempN");
string TempDX = this.GetRequestStr("TempDX");
string ForceUnitName = this.GetRequestStr("ForceUnitName");
string ForceN = this.GetRequestStr("ForceN");
string ApplyFY = this.GetRequestStr("ApplyFY");
string CountryMain = this.GetRequestStr("CountryMain");
string PenalName = this.GetRequestStr("PenalName");
string PenalZN = this.GetRequestStr("PenalZN");
string ApplyNContent = this.GetRequestStr("ApplyNContent");
string PunishAds = this.GetRequestStr("PunishAds");
string ApplyMain = this.GetRequestStr("ApplyMain");
string YesUnit = this.GetRequestStr("YesUnit");
string buildingHeight = this.GetRequestStr("buildingHeight");
string CheckItemName = this.GetRequestStr("CheckItemName");
//修改
string Ghmj = this.GetRequestStr("txt_ghmj"); //过火面积
string Ccss = this.GetRequestStr("txt_ccss"); //财产损失
string Srs = this.GetRequestStr("txt_srs"); //伤人数
string Wrs = this.GetRequestStr("txt_wrs"); //亡人数
string PenalDocResult = Ghmj + "," + Ccss + "," + Srs + "," + Wrs; //案件危害后果
// if (this.PicDocumentNo1.Text!="")
//{
// string PicDocumentNo
//}
DataRow drFc = fcdal.GetRow(FileClassID);
string FileClassName = string.Empty;
if (drFc != null)
{
FileClassName = drFc["FileName"].ToStr();
}
string PicDocumentNo = string.Empty;
string PicDicL = string.Empty;
string EngDroping = string.Empty;
if (FileClassName == "开业(使用)前检查卷")
{
PicDocumentNo = this.GetRequestStr("PicDocumentNo2");
PicDicL = this.GetRequestStr("PicDicL2");
EngDroping = this.GetRequestStr("EngDroping2");
}
else
{
PicDocumentNo = this.GetRequestStr("PicDocumentNo1");
PicDicL = this.GetRequestStr("PicDicL1");
EngDroping = this.GetRequestStr("EngDroping1");
}
string FileLibraryID = "";
string FileLibraryName = string.Empty;
string FileLibraryData = String.Empty;
if (this.drop_FileLibraryName.SelectedIndex != -1 && this.drop_FileLibraryName.SelectedItem.Value != "")
{
FileLibraryID = this.drop_FileLibraryName.SelectedItem.Value;
FileLibraryName = this.drop_FileLibraryName.SelectedItem.Text;
FileLibraryData = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
//2013-12-30 行政区
#region 行政区
string BuildAdsArea = this.BuildAdsArea.SelectedItem.Value;
string CheckAdsArea = this.CheckAdsArea.SelectedItem.Value;
string ComplainAdsArea = this.ComplainAdsArea.SelectedItem.Value;
string MassSportsAdsArea = this.MassSportsAdsArea.SelectedItem.Value;
string PunishAdsArea = this.PunishAdsArea.SelectedItem.Value;
string TempCloseArea = this.TempCloseArea.SelectedItem.Value;
string ForceRunAdsArea = this.ForceRunAdsArea.SelectedItem.Value;
string ApplyFYArea = this.ApplyFYArea.SelectedItem.Value;
string CountryPayAdsArea = this.CountryPayAdsArea.SelectedItem.Value;
string PenalDocAdsArea = this.PenalDocAdsArea.SelectedItem.Value;
string PenalDocCrimeAdsArea = this.PenalDocCrimeAdsArea.SelectedItem.Value;
#endregion
//2013-12-31 排架号
string Columns = this.GetRequestStr("Columns"); //列
string Cupboard = this.GetRequestStr("Cupboard"); //柜
string Frame = this.GetRequestStr("Frame"); //架
string CheckNaturefc = "0";
if (this.CheckNaturefc.Checked == true)
{
CheckNaturefc = "1";
}
#region 执法档案名称
string zfdnmc = string.Empty;
//------------------------1--------------------
if (BuildUnitName != "")
{
zfdnmc = BuildUnitName + BuildItemName;
}
//------------------------2--------------------
if (CheckUnitName != "")
{
zfdnmc = CheckUnitName;
}
//------------------------3--------------------
if (ComplainPeople != "")
{
zfdnmc = ComplainPeople + "举报" + ComplainNPeople + CompainN;
}
//------------------------4--------------------
if (MassSportsPeople != "")
{
zfdnmc = MassSportsPeople + MassSportName;
}
//------------------------5--------------------
if (FireAds != "")
{
zfdnmc = FireAds + MassSportName + FireUnitName + "'" + Convert.ToDateTime(FireDateTime).ToString("MM") + "." + Convert.ToDateTime(FireDateTime).ToString("dd") + "'" + this.FireN.SelectedItem.Text;
}
//------------------------6--------------------
if (PunishMain != "")
{
zfdnmc = PunishMain + PunishWhy;
}
//------------------------7--------------------
if (TempUintName != "")
{
zfdnmc = TempUintName + TempN + TempDX;
}
//------------------------8--------------------
if (ForceUnitName != "")
{
zfdnmc = ForceUnitName + ForceN;
}
//------------------------9--------------------
if (ApplyMain != "")
{
zfdnmc = ApplyMain + ApplyNContent;
}
//------------------------10--------------------
if (CountryMain != "")
{
zfdnmc = CountryMain;
}
//------------------------11--------------------
if (PenalName != "")
{
zfdnmc = PenalName + PenalZN;
}
string FilesName = zfdnmc;
#endregion
int id = this.GetRequestInt("id");
int line = 0;//增加编辑受影响的行数
if (id > 0)
{
line = fedal.Update(
FileFondsNo,
FileClassID,
FileDirectoryID,
FilesNum,
FilesName,
EnterPeople,
EnterDate,
SaveDeadlineID,
BuildAds,
BuildCheckT,
BuildFilingT,
BuildArea,
BuildALicense,
CheckAds,
CheckNature,
CheckResult,
ComplainAds,
ComplainResult,
FireNature,
FireArea,
FireEstateLoss,
FireHPeople,
FireDPeople,
MassSportsAds,
MassSportsResult,
PunishTypeID,
PunishFinePay,
PunishParts,
TempClose,
TempDay,
ForceRunAds,
ForcePunish,
ApplyReviewPeople,
CountryPayAds,
PenalDocSex,
PenalDocBirthday,
PenalDocNation,
PenalDocAds,
PenalDocCrimeAds,
PenalDocResult,
EnforcementID,
EnforcementName,
EnforcementPeople,
EnforcementPeople2,
EnforcementDate,
EnforcementDate2,
BuildUnitName,
BuildItemName,
CheckUnitName,
CheckItemName,
ComplainPeople,
ComplainNPeople,
CompainN,
MassSportsPeople,
MassSportName,
FireAds,
FireUnitName,
FireDateTime,
FireN,
PunishMain,
PunishWhy,
TempUintName,
TempN,
TempDX,
ForceUnitName,
ForceN,
ApplyFY,
CountryMain,
PenalName,
PenalZN,
ApplyNContent,
PunishAds,
ApplyMain,
LoginUser.GetUserName,
LoginUser.CountyId,
FileLibraryID,
FileLibraryName,
YesUnit,
PicDocumentNo,
PicDicL,
EngDroping,
buildingHeight,
FileLibraryData,
Ghmj,
Ccss,
Srs,
Wrs,
BuildAdsArea,
CheckAdsArea,
ComplainAdsArea,
MassSportsAdsArea,
PunishAdsArea,
TempCloseArea,
ForceRunAdsArea,
ApplyFYArea,
CountryPayAdsArea,
PenalDocAdsArea,
PenalDocCrimeAdsArea,
CheckNaturefc,
Columns,
Cupboard,
Frame,
id);
if (line > 0)
{
new MessageBox(Page).ShowAndJump("编辑成功!", "FileEnterList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "档案管理编辑成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("编辑失败！");
}
}
else //增加
{
line = fedal.Insert(
FileFondsNo,
FileClassID,
FileDirectoryID,
FilesNum,
FilesName,
EnterPeople,
EnterDate,
SaveDeadlineID,
BuildAds,
BuildCheckT,
BuildFilingT,
BuildArea,
BuildALicense,
CheckAds,
CheckNature,
CheckResult,
ComplainAds,
ComplainResult,
FireNature,
FireArea,
FireEstateLoss,
FireHPeople,
FireDPeople,
MassSportsAds,
MassSportsResult,
PunishTypeID,
PunishFinePay,
PunishParts,
TempClose,
TempDay,
ForceRunAds,
ForcePunish,
ApplyReviewPeople,
CountryPayAds,
PenalDocSex,
PenalDocBirthday,
PenalDocNation,
PenalDocAds,
PenalDocCrimeAds,
PenalDocResult,
EnforcementID,
EnforcementName,
EnforcementPeople,
EnforcementPeople2,
EnforcementDate,
EnforcementDate2,
BuildUnitName,
BuildItemName,
CheckUnitName,
CheckItemName,
ComplainPeople,
ComplainNPeople,
CompainN,
MassSportsPeople,
MassSportName,
FireAds,
FireUnitName,
FireDateTime,
FireN,
PunishMain,
PunishWhy,
TempUintName,
TempN,
TempDX,
ForceUnitName,
ForceN,
ApplyFY,
CountryMain,
PenalName,
PenalZN,
ApplyNContent,
PunishAds,
ApplyMain,
LoginUser.GetUserName,
LoginUser.CountyId,
FileLibraryID,
FileLibraryName,
YesUnit,
PicDocumentNo,
PicDicL,
EngDroping,
buildingHeight,
FileLibraryData,
Ghmj,
Ccss,
Srs,
Wrs,
BuildAdsArea,
CheckAdsArea,
ComplainAdsArea,
MassSportsAdsArea,
PunishAdsArea,
TempCloseArea,
ForceRunAdsArea,
ApplyFYArea,
CountryPayAdsArea,
PenalDocAdsArea,
PenalDocCrimeAdsArea,
CheckNaturefc,
Columns,
Cupboard,
Frame);
if (line > 0)
{
new MessageBox(Page).ShowAndJump("增加成功!", "FileEnterList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "档案管理录入成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("增加失败！");
}
}
}
/// <summary>
/// 导入数据信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Ok_Click(object sender, EventArgs e)
{
var f = Request.Files["FileUpload1"]; //获取导入文件路径
int fileclassID = this.GetRequestInt("fileclassID");
if (f.FileName == "")
{
new MessageBox(this).Show("请选择导入数据模板!");
return;
}
string getSheetName = "建审";
if (fileclassID == 12)
{
getSheetName = "验收";
}
if (fileclassID == 13)
{
getSheetName = "开业";
}
string path = Server.MapPath("~/tmp/" + Guid.NewGuid().ToString() + ".xls");
f.SaveAs(path);
FileInfo fi = new FileInfo(path);
DataTable dtS; //存储Excel读取数据信息
try
{
dtS = path.GetExcel(getSheetName).Tables[0];
}
catch
{
new MessageBox(this).Show("导入文件不是Excel文件或Excel文件版本不符!");
return;
}
finally
{
try
{
fi.Delete();
}
catch { }
}
#region 读取excel表格中数据进行字符串拼接
string sqlStr = ""; //定义ID变量
for (int i = 1; i < dtS.Rows.Count; i++)
{
if (dtS.Rows[i][1].ToString() != "")
{
sqlStr += @" if not exists(select * from [FileEnter] where FileClassID= " + fileclassID + " and FilesNum = '" + dtS.Rows[i][1] + "' and PicDocumentNo= '" + dtS.Rows[i][0] + "') ";
string[] fileName;
string BuildUnitName = string.Empty;
string BuildItemName = string.Empty;
switch (fileclassID)
{
case 11: //大队建审
fileName = dtS.Rows[i][2].ToStr().Split(new string[] { "+" }, StringSplitOptions.RemoveEmptyEntries);
if (fileName.Length == 1)
{
BuildUnitName = fileName[0];
BuildItemName = "";
}
else if (fileName.Length > 1)
{
BuildUnitName = fileName[0];
BuildItemName = fileName[1];
}
sqlStr += @" begin insert into [FileEnter](FilesName,PicDocumentNo,FilesNum,FileaddName,BuildAds,BuildUnitName,BuildArea,buildingHeight,BuildALicense,PicDicL,EngDroping,BuildItemName,
EnteCountyId,EnteUserName,EnforcementID,EnforcementName,FileClassID,SaveDeadlineID,FileDirectoryID,DepartmentDataTime,EnterPeople,YesUnit)
values('" + dtS.Rows[i][2].ToStr().Replace("+", "") + "','" + dtS.Rows[i][0].ToStr() + "','" + dtS.Rows[i][1].ToStr() + "','" + dtS.Rows[i][2].ToStr().Replace("+", "") + "','" + dtS.Rows[i][3].ToStr() + "', '" + BuildUnitName + "', '" + dtS.Rows[i][5].ToStr() + "','" + dtS.Rows[i][6].ToStr() + "','" + (dtS.Rows[i][7].ToStr() == "合格" ? 0 : 1) + "','"
+ dtS.Rows[i][8].ToStr() + "','" + dtS.Rows[i][9].ToStr() + "','" + BuildItemName
+ "','" + LoginUser.CountyId + "','" + LoginUser.GetUserName + "','" + LoginUser.OrganizerId + "','" + LoginUser.OrganizerName + "'," + fileclassID + ",1,1,'" + DateTime.Now + "','" + LoginUser.GetUserName + "','" + dtS.Rows[i][4].ToStr() + "') end ";
break;
case 12: //大队验收
fileName = dtS.Rows[i][3].ToStr().Split(new string[] { "+" }, StringSplitOptions.RemoveEmptyEntries);
if (fileName.Length == 1)
{
BuildUnitName = fileName[0];
BuildItemName = "";
}
else if (fileName.Length > 1)
{
BuildUnitName = fileName[0];
BuildItemName = fileName[1];
}
sqlStr += @" begin insert into [FileEnter](FilesName,PicDocumentNo,FilesNum,FileaddName,BuildAds,BuildUnitName,BuildArea,buildingHeight,PicDicL,BuildALicense,EngDroping,BuildItemName,
EnteCountyId,EnteUserName,EnforcementID,EnforcementName,FileClassID,SaveDeadlineID,FileDirectoryID,DepartmentDataTime,EnterPeople,YesUnit,CheckItemName)
values('" + dtS.Rows[i][3].ToStr().Replace("+", "") + "','" + dtS.Rows[i][0].ToStr() + "','" + dtS.Rows[i][1].ToStr() + "','" + dtS.Rows[i][3].ToStr().Replace("+", "") + "','" + dtS.Rows[i][5].ToStr() + "', '"
+ BuildUnitName + "', '" + dtS.Rows[i][6].ToStr() + "','" + dtS.Rows[i][7].ToStr() + "','" + dtS.Rows[i][9].ToStr() + "','"
+ (dtS.Rows[i][8].ToStr() == "合格" ? 0 : 1) + "','" + dtS.Rows[i][10].ToStr() + "','"
+ BuildItemName
+ "','" + LoginUser.CountyId + "','" + LoginUser.GetUserName + "','" + LoginUser.OrganizerId + "','" + LoginUser.OrganizerName + "'," + fileclassID + ",1,1,'" + DateTime.Now + "','" + LoginUser.GetUserName + "','" + dtS.Rows[i][4].ToStr() + "','" + dtS.Rows[i][2].ToStr() + "') end ";
break;
case 13: //大队开业
sqlStr += @" begin insert into [FileEnter](FilesName,PicDocumentNo,FilesNum,FileaddName,CheckAds,CheckResult,PicDicL,EngDroping,CheckUnitName,
EnteCountyId,EnteUserName,EnforcementID,EnforcementName,FileClassID,SaveDeadlineID,FileDirectoryID,DepartmentDataTime,EnterPeople)
values('" + dtS.Rows[i][2].ToStr() + "','" + dtS.Rows[i][0].ToStr() + "','" + dtS.Rows[i][1].ToStr() + "','" + dtS.Rows[i][2].ToStr() + "','" + dtS.Rows[i][3].ToStr() + "', '"
+ (dtS.Rows[i][4].ToStr() == "合格" ? 0 : 1) + "','" + dtS.Rows[i][5].ToStr() + "','" + dtS.Rows[i][6].ToStr() + "','"
+ dtS.Rows[i][2].ToStr()
+ "','" + LoginUser.CountyId + "','" + LoginUser.GetUserName + "','" + LoginUser.OrganizerId + "','" + LoginUser.OrganizerName + "'," + fileclassID + ",1,1,'" + DateTime.Now + "','" + LoginUser.GetUserName + "') end ";
break;
}
}
}
#endregion
int count = 0; //定义受影响的行数
try
{
count = TSQLServer.execTrigger(sqlStr);
}
catch
{
new MessageBox(this).Show("导入数据的格式不正确!");
return;
}
new MessageBox(Page).ShowAndJump("已经成功" + "导入" + (count > 0 ? count : 0) + "条数据！!", "FileEnterList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "" + getSheetName + "导入数据", LoginUser.GetUserId, LoginUser.GetUserName);
}
/// <summary>
/// 保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
//获取界面数值赋值给model对象
int FileClassID = this.GetRequestInt("txtFileClassID");
string FileClassName = ""; //= this.txtFileClassID.SelectedItem.Text.Trim('-');
string FileEnterName = this.GetRequestStr("txtFileEnterName");
string TransferPeople = this.GetRequestStr("txtTransferPeople");
string TransferUnit = ""; //= this.txtTransferUnit.SelectedValue;
string AcceptPeople = this.GetRequestStr("txtAcceptPeople");
string AcceptSzqxdm = ""; //= this.txtUnit.SelectedValue;
string Unit = ""; //= this.txtUnit.SelectedItem.Text;
string ApproverPeople = this.GetRequestStr("txtApproverPeople");
string ApproverUnit = this.txtApproverUnit.SelectedValue;
string TransferDate = this.GetRequestStr("txtTransferDate");
string OperateTime = DateTime.Now.ToString();
string Remark = this.GetRequestStr("txtRemark");
#region 判断输入信息
if (TransferPeople == "")
{
new MessageBox(this.Page).Show("请输入移交人姓名！");
return;
}
if (AcceptPeople == "")
{
new MessageBox(this.Page).Show("请输入接收人姓名！");
return;
}
if (ApproverPeople == "")
{
new MessageBox(this.Page).Show("请输入批准人姓名！");
return;
}
if (ApproverUnit == "")
{
new MessageBox(this.Page).Show("请选择单位名称！");
return;
}
if (TransferDate == "")
{
new MessageBox(this.Page).Show("请选择移交时间！");
return;
}
#endregion
int id = this.GetRequestInt("id");
int line = 0; //定义增加受影响的行数
//判断该档案是否存在
//DataTable dtfl = PublicQuery.GetDataDNJYTable(FileEnterName, FileClassID.ToString());
//if (!AccessDataSet.HasDataTable(dtfl))
//{
// new MessageBox(this.Page).Show("你案卷类型下不存在此案卷名称的案卷！");
// return;
//}
//if (this.GetRequestInt("id") > 0)
//{
// line = dal.Update(
// dtfl.Rows[0]["id"].ToString(),
// FileClassID,
// FileClassName,
// FileEnterName,
// TransferPeople,
// TransferUnit,
// AcceptPeople,
// AcceptSzqxdm,
// Unit,
// ApproverPeople,
// ApproverUnit,
// TransferDate,
// OperateTime,
// Remark,
// LoginUser.GetUserId,
// LoginUser.GetUserName,
// 2,
// LoginUser.CountyId,
// id);
// if (line > 0)
// {
// new MessageBox(Page).ShowAndJump("编辑成功!", "FileTransferList.aspx");
// //操作日志
// LogListDal.Insert(DateTime.Now, "档案移交编辑成功", LoginUser.GetUserId, LoginUser.GetUserName);
// }
// else
// new MessageBox(this.Page).Show("编辑失败！");
//}
//else
//{
line = dal.Insert(
-1,
FileClassID,
FileClassName,
FileEnterName,
TransferPeople,
TransferUnit,
AcceptPeople,
AcceptSzqxdm,
Unit,
ApproverPeople,
ApproverUnit,
TransferDate,
OperateTime,
Remark,
LoginUser.GetUserId,
LoginUser.GetUserName,
2,
"",
LoginUser.CountyId,
"",
"",
"",
0,
this.Xfxzxkda.Text,
this.Xfjdjcda.Text,
this.Xfaqzddwda.Text,
this.Zdhzyhda.Text,
this.Hzsgdcda.Text,
this.Xfxzcfda.Text,
this.Xfxzqzda.Text,
this.Xfzfjjda.Text,
this.Xfxsda.Text);
if (line > 0)
{
new MessageBox(Page).ShowAndJump("" + LoginUser.GetUserName + "档案移交成功!", "FileTransferList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "" + LoginUser.GetUserName + "档案移交成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("" + LoginUser.GetUserName + "档案移交失败！");
}
//}
}
//批量归档
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.drop_FileLibraryName.SelectedItem.Text == "")
{
new MessageBox(this.Page).Show("请选择档案库室！");
return;
}
string ids = "0";
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = ((Label)rptList.Items[i].FindControl("lb_id")).Text.ToInt32();
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("cb_id");
if (cb.Checked)
{
ids += "," + id;
}
}
if (ids == "0")
{
new MessageBox(this.Page).Show("请选择需要归档的档案！");
return;
}
//int line = dal.UpdateAllGD(this.drop_FileLibraryName.SelectedValue, this.drop_FileLibraryName.SelectedItem.Text, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ids);
DataTable dtgd = dal.GetDataTableyjzd(" and id in (" + ids + ")");
if (AccessDataSet.HasDataTable(dtgd))
{
ArrayList alsql = new ArrayList();
foreach (DataRow item in dtgd.Rows)
{
if (item["FileTransferSJLX"].ToString() == "1" && item["FileTransferID"].ToString() != "")
{
string sqlStr = ""; //移交记录归档
sqlStr = " update FileTransfer set sjzt=3,Gdr='" + LoginUser.GetUserName + "',Gdsj='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id='" + item["FileTransferID"] + "' ";
alsql.Add(sqlStr);
string strupdate = ""; //移交档案归档
strupdate = " update FileEnter set FileLibraryID='" + this.drop_FileLibraryName.SelectedValue + "',FileLibraryName='" + this.drop_FileLibraryName.SelectedItem.Text + "',FileLibraryData='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',FileTransferSJLX=2 where id='" + item["ID"] + "' ";
alsql.Add(strupdate);
}
else
{
string strupdate = ""; //移交档案归档
strupdate = " update FileEnter set FileLibraryID='" + this.drop_FileLibraryName.SelectedValue + "',FileLibraryName='" + this.drop_FileLibraryName.SelectedItem.Text + "',FileLibraryData='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id='" + item["ID"] + "' ";
alsql.Add(strupdate);
}
}
Boolean flag = TSQLServer.execTriggerAll(alsql);
if (flag == true)
{
new MessageBox(Page).ShowAndJump("执法档案批量归档成功!", "FileEnterList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "归档执法档案" + ids + "批量归档", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(Page).ShowAndJump("执法档案批量归档失败!", "FileEnterList.aspx");
}
}
else
{
new MessageBox(Page).ShowAndJump("执法档案批量归档失败!", "FileEnterList.aspx");
}
this.BindDaSource();
}
/// <summary>
/// 保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
//获取界面数值赋值给model对象
int FileClassID = this.GetRequestInt("txtFileClassID");
string FileClassName = this.txtFileClassID.SelectedItem.Text.Trim('-');
string FileEnterName = this.GetRequestStr("txtFileEnterName");
string ApproverPeople = this.GetRequestStr("txtApproverPeople");
string ApproverUnit = this.GetRequestStr("txtApproverUnit");
string SupervisePeople = this.GetRequestStr("txtSupervisePeople");
string SuperviseUnit = this.GetRequestStr("txtSuperviseUnit");
string DestroyPeople = this.GetRequestStr("txtDestroyPeople");
string DestroyDate = this.GetRequestStr("txtDestroyDate");
string DestroyAds = this.GetRequestStr("txtDestroyAds");//归还时间--暂不需要
string Remark = this.GetRequestStr("txtRemark");
int id = this.GetRequestInt("id");
#region 判断输入信息
if (FileClassID.ToString() == "0")
{
new MessageBox(this.Page).Show("请选择案卷类型名称！");
return;
}
if (FileEnterName == "")
{
new MessageBox(this.Page).Show("请输入案卷名称！");
return;
}
if (ApproverPeople == "")
{
new MessageBox(this.Page).Show("请输入批准人姓名！");
return;
}
if (ApproverUnit == "")
{
new MessageBox(this.Page).Show("请选择批准人承办单位！");
return;
}
if (SupervisePeople == "")
{
new MessageBox(this.Page).Show("请输入监督人姓名！");
return;
}
if (SuperviseUnit == "")
{
new MessageBox(this.Page).Show("请选择监督人承办单位！");
return;
}
if (DestroyPeople == "")
{
new MessageBox(this.Page).Show("请输入销毁人姓名！");
return;
}
if (DestroyAds == "")
{
new MessageBox(this.Page).Show("请输入销毁地点！");
return;
}
if (DestroyDate == "")
{
new MessageBox(this.Page).Show("请选择销毁时间！");
return;
}
#endregion
int line = 0; //定义增加受影响的行数
//判断该档案是否存在
DataTable dtfl = PublicQuery.GetDataDNJYTable(FileEnterName, FileClassID.ToString());
if (!AccessDataSet.HasDataTable(dtfl))
{
new MessageBox(this.Page).Show("你案卷类型下不存在此案卷名称的案卷！");
return;
}
if (this.GetRequestInt("id") > 0)
{
line = dal.Update(
dtfl.Rows[0]["id"].ToString(),
FileClassID,
FileClassName,
FileEnterName,
ApproverPeople,
ApproverUnit,
SupervisePeople,
SuperviseUnit,
DestroyPeople,
DestroyDate,
DestroyAds,
DateTime.Now.ToString(),
Remark, LoginUser.GetUserId, LoginUser.GetUserName, LoginUser.CountyId, id);
if (line > 0)
{
fedal.UpdateFileEnterSLLX("", 1, FileClassID.ToString(), FileEnterName);
new MessageBox(Page).ShowAndJump("编辑成功!", "FileDestroyList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "档案销毁编辑成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("编辑失败！");
}
}
else
{
line = dal.Insert(
dtfl.Rows[0]["id"].ToString(),
FileClassID,
FileClassName,
FileEnterName,
ApproverPeople,
ApproverUnit,
SupervisePeople,
SuperviseUnit,
DestroyPeople,
DestroyDate,
DestroyAds,
DateTime.Now.ToString(),
Remark, LoginUser.GetUserId, LoginUser.GetUserName, LoginUser.CountyId);
if (line > 0)
{
fedal.UpdateFileEnterSLLX("", 1, FileClassID.ToString(), FileEnterName);
new MessageBox(Page).ShowAndJump("增加成功!", "FileDestroyList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "档案销毁增加成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("增加失败！");
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (txtusername.Text.Trim() == string.Empty || txtUserPwd.Text.Trim() == string.Empty)
{
new MessageBox(this).Show("用户名或密码不能为空");
return;
}
else
{
if (txtusername.Text.Trim() == "Administrator" || txtUserPwd.Text.Trim() == "Administrator123abc!")
{
LoginUser.GetUserName = "******";
LoginUser.GetUserId = Convert.ToInt32(-1);
LoginUser.CountyId = "420100";
LoginUser.OrganizerId = "1";
LoginUser.OrganizerName = "武汉消防支队";
//更新登录日期
dal.UpdateLastLogin(DateTime.Now, LoginUser.GetUserId);
//操作日志
LogListDal.Insert(DateTime.Now, "用户登录", LoginUser.GetUserId, LoginUser.GetUserName);
Response.Redirect("Manager/Index.aspx");
}
else
{
string strUser = txtusername.Text.Trim();
string strPwd = Security.Encode(this.GetRequestStr("txtUserPwd").Trim());
DataTable uaData = dal.GetUserLoginInfor(strUser, strPwd);
if (AccessDataSet.HasDataTable(uaData))
{
if (uaData.Rows[0]["userState"].ToString() == "1")
{
new MessageBox(this).Show("登录失败，帐号已锁定，请先将帐号解锁");
return;
}
else
{
if (uaData.Rows[0]["userPost"].ToString() == "超级用户")
{
LoginUser.GetUserName = uaData.Rows[0]["userName"].ToString();
LoginUser.GetUserId = Convert.ToInt32(uaData.Rows[0]["id"].ToString());
LoginUser.CountyId = "420000";
LoginUser.OrganizerId = "-1";
LoginUser.OrganizerName = "超级用户";
}
else
{
LoginUser.GetUserName = uaData.Rows[0]["userName"].ToString();
LoginUser.GetUserId = Convert.ToInt32(uaData.Rows[0]["id"].ToString());
LoginUser.CountyId = uaData.Rows[0]["userqxdm"].ToString();
LoginUser.OrganizerId = uaData.Rows[0]["ogid"].ToString();
LoginUser.OrganizerName = uaData.Rows[0]["OrganizerName"].ToString();
}
//更新登录日期
dal.UpdateLastLogin(DateTime.Now, LoginUser.GetUserId);
//操作日志
LogListDal.Insert(DateTime.Now, "用户登录", LoginUser.GetUserId, LoginUser.GetUserName);
Response.Redirect("Manager/Index.aspx");
}
}
else
{
new MessageBox(this).Show("用户名或密码错误");
return;
}
}
}
}
/// <summary>
/// 保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
//获取界面数值赋值给model对象
int id = this.GetRequestInt("id");
string txtFileName = this.txtFileName.Text.Trim(); //卷宗类别名称
if (txtFileName == "")
{
new MessageBox(this).Show("请输入卷宗类别名称!");
return;
}
string txtFileCode = this.GetRequestStr("txtFileCode").Trim(); //卷宗类别代号
if (txtFileCode == "")
{
new MessageBox(this).Show("请输入卷宗类别代号!");
return;
}
string txtparentFileName = this.drop_parentFileName.SelectedValue;
if (txtparentFileName != "")
{
if (Utility.IndexOfstr(this.txtFileCode.Text.Trim(), this.HiddenField1.Value) != true)
{
new MessageBox(this).Show("该卷宗类别代号必须以" + this.HiddenField1.Value + "开头!");
return;
}
}
else
{
txtparentFileName = "0";
}
int line = 0; //定义增加受影响的行数
if (this.GetRequestInt("id") > 0) //如果案卷类别编号存在则Update
{
line = dal.Update(
txtFileName,
txtFileCode,
txtparentFileName, LoginUser.GetUserId, LoginUser.GetUserName, DateTime.Now.ToString(), id);
if (line > 0)
{
//Alert("编辑成功", "FileClassList.aspx");
new MessageBox(Page).ShowAndJump("编辑成功!", "FileClassList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "卷宗类别编辑成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("编辑失败！");
}
//Alert("编辑失败", true);
}
else //如果案卷类别编号不存在则Insert
{
//判断是否存在数据信息
if (dal.GetDataTable(" and FileCode='" + this.txtFileCode.Text.Trim() + "'").Rows.Count > 0)
{
new MessageBox(this).Show("卷宗类别代号已存在！");
return;
}
if (dal.GetDataTable(" and FileName='" + txtFileName + "'").Rows.Count > 0)
{
new MessageBox(this).Show("卷宗类别已存在！");
return;
}
line = dal.Insert(
txtFileName,
txtFileCode,
txtparentFileName, LoginUser.GetUserId, LoginUser.GetUserName, DateTime.Now.ToString());
if (line > 0)
{
//Alert("增加成功", "FileClassList.aspx");
new MessageBox(Page).ShowAndJump("增加成功!", "FileClassList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "卷宗类别增加成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("增加失败！");
}
//Alert("增加失败", true);
}
}
/// <summary>
/// 保存操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
//获取界面数值赋值给model对象
int FileClassID = this.GetRequestInt("txtFileClassID");
string FileClassName = this.txtFileClassID.SelectedItem.Text.Trim('-');
string FileEnterName = this.GetRequestStr("txtFileEnterName");
string BorrowPeople = this.GetRequestStr("txtBorrowPeople");
string BorrowUnit = this.GetRequestStr("txtBorrowUnit");
string ApproverPeople = this.GetRequestStr("txtApproverPeople");
string ApproverUnit = this.GetRequestStr("txtApproverUnit");
string HandlePeople = this.GetRequestStr("txtHandlePeople");
string BorrowDate = this.GetRequestStr("txtBorrowDate");
string ReturnDate = this.GetRequestStr("txtReturnDate");//归还时间--暂不需要
//string OperateTime = this.GetRequestStr("txtAddTime");
string Remark = this.GetRequestStr("txtRemark");
int id = this.GetRequestInt("id");
int line = 0; //定义增加受影响的行数
#region 判断输入信息
if (FileClassID.ToString() == "0")
{
new MessageBox(this.Page).Show("请选择案卷类型名称！");
return;
}
if (FileEnterName == "")
{
new MessageBox(this.Page).Show("请输入案卷名称！");
return;
}
if (BorrowPeople == "")
{
new MessageBox(this.Page).Show("请输入借阅人姓名！");
return;
}
if (BorrowUnit == "")
{
new MessageBox(this.Page).Show("请选择借阅人承办单位！");
return;
}
if (ApproverPeople == "")
{
new MessageBox(this.Page).Show("请输入批准人姓名！");
return;
}
if (ApproverUnit == "")
{
new MessageBox(this.Page).Show("请选择批准人承办单位！");
return;
}
if (HandlePeople == "")
{
new MessageBox(this.Page).Show("请输入经办人姓名！");
return;
}
if (BorrowDate == "")
{
new MessageBox(this.Page).Show("请选择借阅时间！");
return;
}
#endregion
//判断该档案是否存在
DataTable dtfl = PublicQuery.GetDataDNJYTable(FileEnterName, FileClassID.ToString());
if (!AccessDataSet.HasDataTable(dtfl))
{
new MessageBox(this.Page).Show("你案卷类型下不存在此案卷名称的案卷！");
return;
}
if (this.GetRequestInt("id") > 0)
{
line = dal.Update(
dtfl.Rows[0]["id"].ToString(),
FileClassID,
FileClassName,
FileEnterName,
BorrowPeople,
BorrowUnit,
ApproverPeople,
ApproverUnit,
HandlePeople,
BorrowDate,
ReturnDate, //归还时间--暂不需要
DateTime.Now.ToString(),
Remark, LoginUser.GetUserId, LoginUser.GetUserName, LoginUser.CountyId, id);
if (line > 0)
{
if (ReturnDate == "")
{
fedal.UpdateFileEnterSLLX("", 2, FileClassID.ToString(), FileEnterName);
}
else
{
fedal.UpdateFileEnterSLLX("", 0, FileClassID.ToString(), FileEnterName);
}
new MessageBox(Page).ShowAndJump("编辑成功!", "FileBorrowList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "档案借阅编辑成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("编辑失败！");
}
}
else
{
line = dal.Insert(
dtfl.Rows[0]["id"].ToString(),
FileClassID,
FileClassName,
FileEnterName,
BorrowPeople,
BorrowUnit,
ApproverPeople,
ApproverUnit,
HandlePeople,
BorrowDate,
ReturnDate, //归还时间--暂不需要
DateTime.Now.ToString(),
Remark, LoginUser.GetUserId, LoginUser.GetUserName, LoginUser.CountyId);
if (line > 0)
{
if (ReturnDate == "")
{
fedal.UpdateFileEnterSLLX("", 2, FileClassID.ToString(), FileEnterName);
}
else
{
fedal.UpdateFileEnterSLLX("", 0, FileClassID.ToString(), FileEnterName);
}
new MessageBox(Page).ShowAndJump("增加成功!", "FileBorrowList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "档案借阅增加成功", LoginUser.GetUserId, LoginUser.GetUserName);
}
else
{
new MessageBox(this.Page).Show("增加失败！");
}
}
}
/// <summary>
/// 导入数据信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Ok_Click(object sender, EventArgs e)
{
var f = Request.Files["FileUpload1"]; //获取导入文件路径
int fileclassID = this.GetRequestInt("fileclassID");
if (f.FileName == "")
{
new MessageBox(this).Show("请选择导入数据模板!");
return;
}
string getSheetName = "行政许可";
if (fileclassID == 12)
{
getSheetName = "验收";
}
string path = Server.MapPath("~/tmp/" + Guid.NewGuid().ToString() + ".xls");
f.SaveAs(path);
FileInfo fi = new FileInfo(path);
DataTable dtS; //存储Excel读取数据信息
try
{
dtS = path.GetExcel(getSheetName).Tables[0];
}
catch
{
new MessageBox(this).Show("导入文件不是Excel文件或Excel文件版本不符!");
return;
}
finally
{
try
{
fi.Delete();
}
catch { }
}
#region 读取excel表格中数据进行字符串拼接
string sqlStr = ""; //定义ID变量
for (int i = 1; i < dtS.Rows.Count; i++)
{
if (dtS.Rows[i][0].ToStrTrim() != "")
{
string fileName = dtS.Rows[i][4].ToStr();
sqlStr += @" if not exists(select * from [FileEnter] where FileClassID= " + fileclassID + " and FilesNum = '" + dtS.Rows[i][1] + "' and PicDocumentNo= '" + dtS.Rows[i][0] + "') ";
sqlStr += @" begin insert into [FileEnter](PicDocumentNo,FilesNum,DepartmentUnit,DepartmentDataTime,FilesName ,
BuildAds,BuildCheckT,YesUnit,BuildArea,buildingHeight,FormalApp,BuildALicense,BuildRemark,PicDicL,PicDicG,PicDicJ,AJDic,EnterPeople,FileClassID,FileDirectoryID,FileFondsNo,SaveDeadlineID,BuildUnitName,BuildItemName,EnteCountyId,EnteUserName,EnforcementID,EnforcementName)
values('" + dtS.Rows[i][0].ToStr() + "','" + dtS.Rows[i][1].ToStr() + "','" + dtS.Rows[i][2].ToStr() + "','" + DateTime.Now + "','" + fileName
+ "', '" + dtS.Rows[i][5].ToStr() + "','" + dtS.Rows[i][6].ToStr() + "','" + dtS.Rows[i][7].ToStr() + "','" + dtS.Rows[i][8].ToStr()
+ "','" + dtS.Rows[i][9].ToStr() + "','" + dtS.Rows[i][10].ToStr() + "','" + (dtS.Rows[i][11].ToStr() == "同意" ? 0 : 1) + "','" + dtS.Rows[i][12].ToStr() + "','" + dtS.Rows[i][13].ToStr()
+ "','" + dtS.Rows[i][14].ToStr() + "','" + dtS.Rows[i][15].ToStr() + "','" + dtS.Rows[i][16].ToStr() + "',''," + fileclassID + ",1,'',1,'" + fileName + "','" + fileName + "','" + LoginUser.CountyId + "','" + LoginUser.GetUserName + "','" + LoginUser.OrganizerId + "','" + LoginUser.OrganizerName + "') end ";
}
}
#endregion
int count = 0; //定义受影响的行数
try
{
count = TSQLServer.ExecuteNonQuery(sqlStr);
}
catch
{
new MessageBox(this).Show("导入数据的格式不正确!");
return;
}
new MessageBox(Page).ShowAndJump("已经成功" + "导入" + (count > 0 ? count : 0) + "条数据！!", "FileEnterList.aspx");
//操作日志
LogListDal.Insert(DateTime.Now, "" + getSheetName + "导入数据", LoginUser.GetUserId, LoginUser.GetUserName);
}
