//领导不同意批示保存
private string SaveBTYPS()
{
string GUID = "";
if (ViewState["Number"] != null && ViewState["Number"].ToString() != "") //得到前面生成的GUID
{
GUID = ViewState["Number"].ToString();
}
string TelNotion = txtTelNotion.Text.Trim(); //领导意见
string[] Insert = new string[2];
Insert[0] = "insert into STelAuditing(GUID,Tel_ID,TelNotion,PerNumber,IsPer,CreatedBy,CreatedDate,StatusId) " +
" values('" + GUID + "','" + Tel_ID + "','" + TelNotion + "','" + ViewState["Satff_Id"].ToString() + "',1,'" + ViewState["Satff_Id"].ToString() + "',getdate(),0)";
Insert[1] = "update STelFlow set OperateStep = '2' where PFunction = '3' and Tel_ID = '" + Tel_ID + "'";
try
{
db.runTransaction(Insert);
return("保存成功");
}
catch (Exception er)
{
return(er.Message);
}
}
private bool AddGridArticle(DataGrid DGrid, string sql, string KBaseTreeGuid)
{
string[] sqlTmp1 = new string[DGrid.Items.Count + 2];
sqlTmp1[0] = sql;
sqlTmp1[1] = "update SKbsArticle set KBaseTree_Guid='' where KBaseTree_Guid='" + KBaseTreeGuid + "'";
int haveSelected = 2;
for (int i = 0; i < DGrid.Items.Count; i++)
{
CheckBox myCheck = (CheckBox)DGrid.Items[i].FindControl("CheckBox1");
if (myCheck.Checked == true)
{
//sqlTmp[haveSelected] = "insert into SCtiRoleMenu(Role_Id,Menu_Id) values('" + Role_Id + "','" + mySelected + "')";
sqlTmp1[haveSelected] = "update SKbsArticle set KBaseTree_Guid='" + KBaseTreeGuid + "' where KBaseArticle_Guid='" + DGrid.Items[i].Cells[2].Text.Trim() + "'";
haveSelected++;
}
}
string[] sqlOne = new string[haveSelected];
for (int i = 0; i < haveSelected; i++)
{
sqlOne[i] = sqlTmp1[i];
}
bool blnReturnCode = db.runTransaction(sqlOne);
return(blnReturnCode);
}
protected void btnOK_Click(object sender, EventArgs e)
{
txt1.Value = hfStaffId.Value.TrimEnd(',');
string Order_ID = "";
string Number = "";
if (Request.QueryString["Order_ID"] == null || Request.QueryString["Order_ID"].ToString() == "") //编码
{
Response.Redirect("error2.htm");
}
else
{
Order_ID = Request.QueryString["Order_ID"].ToString();
}
if (Request.QueryString["Number"] == null || Request.QueryString["Number"].ToString() == "") //编码
{
Response.Redirect("error2.htm");
}
else
{
Number = Request.QueryString["Number"].ToString();
}
string NFunction = DropDownList1.SelectedItem.Value.Trim(); //下步骤功能
string NExecute = txt1.Value.Trim(); //下步骤执行人
if (NFunction == "")
{
WebWindow.alert("请选择下步骤功能");
return;
}
if (NExecute == "")
{
WebWindow.alert("请选择下步骤执行人");
return;
}
string[] splitNExecute = NExecute.Split(',');
string[] Update = new string[splitNExecute.Length + 1]; //定义保存数据库的数组
string ZCompereGUID = Guid.NewGuid().ToString();
Update[0] = "update SOrdFlow set NFunction ='" + NFunction + "' , NExecute ='" + ZCompereGUID + "' , OperateStep = '2'" +
" where Order_ID = '" + Order_ID + "' and Number = '" + Number + "' and (NFunction is null or NFunction = '')";
for (int i = 0; i < splitNExecute.Length; i++)
{
Update[i + 1] = "insert into SOrdArrangeMan (Arrange_Guid,Guid,Man) values('" + Guid.NewGuid().ToString() + "','" + ZCompereGUID + "','" + splitNExecute[i] + "')";
}
if (db.runTransaction(Update) == true)
{
WebWindow.alert("下送成功");
btnOK.Visible = false;
}
}
//勤务安排
private string SaveAP()
{
string type = "";
if (ViewState["type"].ToString() == "1")
{
type = "随卫勤务";
}
else if (ViewState["type"].ToString() == "2")
{
type = "现场勤务";
}
else if (ViewState["type"].ToString() == "3")
{
type = "住地勤务";
}
//日期时间从
if (txtFromFTime.Text == "")
{
txtFromFTime.Text = "00";
}
string timeFrom = txtFromRTime.Text + " " + drpFromSTime.SelectedValue + ":" + txtFromFTime.Text + ":00";
//日期时间到
if (txtToFTime.Text == "")
{
txtToFTime.Text = "00";
}
string timeTo = txtToRTime.Text + " " + drpToSTime.SelectedValue + ":" + txtToFTime.Text + ":00";
//勤务地点
string Order_locus = txtOrder_locus.Text.Trim();
//接待单位
string ReceiveUnit = txtReceiveUnit.Text.Trim();
//活动日程
string Order_Calendar = txtOrder_Calendar.Text.Trim();
//工作要求
string work_Request = txtwork_Request.Text.Trim();
//附件：AAA
string GVAbjunctOne = "";
if (ViewState["AttachmentBatch_Guid"] == null || ViewState["AttachmentBatch_Guid"].ToString() == "")
{
}
else
{
GVAbjunctOne = ViewState["AttachmentBatch_Guid"].ToString(); //要改的
}
//联系方式
string LinkFashion = txtLinkFashion.Text.Trim();
//总指挥
string ZCompere = txtZCompere.Value.Trim();
string[] ZCompere1 = ZCompere.Split(',');
//副指挥
string FCompere = txtFCompere.Value.Trim();
string[] FCompere1 = FCompere.Split(',');
//负责人
string Principal = txtPrincipal.Value.Trim();
string[] Principal1 = Principal.Split(',');
//随卫人员
string XGMan = txtXGMan.Value.Trim();
string[] XGMan1 = XGMan.Split(',');
int Length = ZCompere1.Length + FCompere1.Length + FCompere1.Length + XGMan1.Length;
string[] InterSql = new string[Length + 1];
//总指挥
string ZCompereGUID = Guid.NewGuid().ToString();
//副指挥
string FCompereGUID = Guid.NewGuid().ToString();
//负责人
string PrincipalGUID = Guid.NewGuid().ToString();
//相关人员
string XGManGUID = Guid.NewGuid().ToString();
string Archives = "";
string Badge = "";
string Gun = "";
string Car = "";
if (this.CheckBox1.Checked == true)
{
Archives = "1";
}
if (this.CheckBox2.Checked == true)
{
Badge = "1";
}
if (this.CheckBox3.Checked == true)
{
Gun = "1";
}
if (this.CheckBox4.Checked == true)
{
Car = "1";
}
InterSql[0] = "INSERT INTO SOrdCArrange(OrderArrange_Guid,Order_ID,DutyPlan,FromTime,FromTo,Order_locus,ReceiveUnit,Order_Calendar,work_Request," +
" Abjunct,LinkFashion,ZCompere,FCompere,Principal,XGMan,Archives,Badge,Gun,Car,CreatedBy,CreatedDate,StatusId,Approve" +
")VALUES('" + Guid.NewGuid().ToString() + "','" + ViewState["Order_ID"].ToString() + "','" + type + "','" +
timeFrom + "','" + timeTo + "','" + Order_locus + "','" + ReceiveUnit + "','" +
Order_Calendar + "','" + work_Request + "','" + GVAbjunctOne + "','" + LinkFashion + "','" + ZCompereGUID + "','" + FCompereGUID + "','" +
PrincipalGUID + "','" + XGManGUID + "','" + Archives + "','" + Badge + "','" + Gun + "','" + Car + "','" + ViewState["Satff_Id"].ToString() + "',getdate(),0,0)";
for (int i = 1; i <= ZCompere1.Length; i++)
{
InterSql[i] = "insert into SOrdArrangeMan (Arrange_Guid,Guid,Man) values('" + Guid.NewGuid().ToString() + "','" + ZCompereGUID + "','" + ZCompere1[i - 1] + "')";
}
for (int i = 0; i < FCompere1.Length; i++)
{
InterSql[ZCompere1.Length + 1 + i] = "insert into SOrdArrangeMan (Arrange_Guid,Guid,Man) values('" + Guid.NewGuid().ToString() + "','" + FCompereGUID + "','" + FCompere1[i] + "')";
}
for (int i = 0; i < Principal1.Length; i++)
{
InterSql[ZCompere1.Length + 1 + FCompere1.Length + i] = "insert into SOrdArrangeMan (Arrange_Guid,Guid,Man) values('" + Guid.NewGuid().ToString() + "','" + FCompereGUID + "','" + Principal1[i] + "')";
}
for (int i = 0; i < XGMan1.Length; i++)
{
InterSql[ZCompere1.Length + 1 + FCompere1.Length + Principal1.Length + i] = "insert into SOrdArrangeMan (Arrange_Guid,Guid,Man) values('" + Guid.NewGuid().ToString() + "','" + XGManGUID + "','" + XGMan1[i] + "')";
}
try
{
if (db.runTransaction(InterSql))
{
return("保存成功");
}
else
{
return("保存失败");
}
}
catch (Exception er)
{
return(er.Message);
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
MDataBase db = new MDataBase(ConfigurationManager.ConnectionStrings["OA"].ToString());
txt1.Value = hfStaffId.Value.TrimEnd(',');
string state = "";
string Order_ID = "";
string Net_Guid = "";
if (Request.QueryString["state"] == null || Request.QueryString["state"].ToString() == "") //得到状态
{
Response.Redirect("error2.htm");
}
else
{
state = Request.QueryString["state"].ToString();
}
if (Request.QueryString["Order_ID"] == null || Request.QueryString["Order_ID"].ToString() == "") //得到勤务编号
{
Response.Redirect("error2.htm");
}
else
{
Order_ID = Request.QueryString["Order_ID"].ToString();
}
if (Request.QueryString["Net_Guid"] == null || Request.QueryString["Net_Guid"].ToString() == "") //得到单子编号
{
Response.Redirect("error2.htm");
}
else
{
Net_Guid = Request.QueryString["Net_Guid"].ToString();
}
string NExecute = txt1.Value.Trim(); //下步骤执行人
if (NExecute == "")
{
WebWindow.alert("请选择下步骤执行人");
return;
}
string[] splitNExecute = NExecute.Split(',');
string[] Update = new string[splitNExecute.Length + 1]; //定义保存数据库的数组
string ZCompereGUID = Guid.NewGuid().ToString();
state = Request.QueryString["state"].ToString(); //得到状态
if (state == "2") //在办公室审批状态的，改为领导状态
{
Update[0] = "update SOrdNet set StatusId = '3',nextPer = '" + ZCompereGUID +
"' where Order_ID = '" + Order_ID + "'"; //状态改成2
}
else if (state == "3")
{
Update[0] = "update SOrdNetAuditing set StatusId = '2', nextPer = '" + ZCompereGUID +
"'where Net_Guid = '" + Net_Guid + "' and StatusId = '1'";
}
for (int i = 0; i < splitNExecute.Length; i++)
{
Update[i + 1] = "insert into SOrdArrangeMan (Arrange_Guid,Guid,Man) values('" + Guid.NewGuid().ToString() + "','" + ZCompereGUID + "','" + splitNExecute[i] + "')";
}
if (db.runTransaction(Update) == true)
{
WebWindow.alert("下送成功");
btnOK.Visible = false;
}
}
