protected void btnOK_Click(object sender, EventArgs e)
{
if (txtREASON.Text == "")
{
JScript.Alert(GetGlobalResourceObject("WebGlobalResource", "ItemNotNull").ToString()); //某项不允许为空
return;
}
//先保存操作记录
string re = CustomControlSave.CustomControlSaveByTableNameReturnS(this.Page, "DMIS_SYS_WK_OPT_HISTORY");
if (re != "")
{
JScript.Alert(re);
return;
}
//再设置业务的状态
string sql;
if (txtOPT_TYPE.Text == "挂起")
{
sql = "update dmis_sys_pack set f_status='3' where f_no=" + txtPACKNO.Text;
}
else
{
sql = "update dmis_sys_pack set f_status='1' where f_no=" + txtPACKNO.Text;
}
if (DBOpt.dbHelper.ExecuteSql(sql) > 0)
{
JScript.CloseWin("refreshPage");
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
StringBuilder sorts = new StringBuilder();
for (int i = 0; i < ((DataTable)ViewState["dtSelect"]).Rows.Count; i++)
{
if (((DataTable)ViewState["dtSelect"]).Rows[i]["ORDER_TYPE"].ToString() == GetGlobalResourceObject("WebGlobalResource", "ComSetSort001").ToString())//要翻译
{
sorts.Append(((DataTable)ViewState["dtSelect"]).Rows[i]["NAME"].ToString() + " ASC,");
}
else
{
sorts.Append(((DataTable)ViewState["dtSelect"]).Rows[i]["NAME"].ToString() + " DESC,");
}
}
if (sorts.Length < 1)
{
JScript.Alert(this.Page, GetGlobalResourceObject("WebGlobalResource", "ComSetSort003").ToString());//要翻译
return;
}
else
{
sorts.Remove(sorts.Length - 1, 1); //除去最后一个,
//refreshPage
Session["CustomOrder"] = sorts.ToString();
JScript.CloseWin("refreshPage");
//JScript.RefreshParent(Session["Url"].ToString());
//sorts.Remove(sorts.Length - 1, 1); //除去最后一个,
//Session["SortBackURL"] = Session["SortBackURL"].ToString() + "&SortOrders=" + sorts.ToString(); //利用此传递参数在返回页中确定是从左边的树形菜单找开的页面，还是从排序返回的页面。
//Response.Redirect(Session["SortBackURL"].ToString());
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
if (grvList.SelectedIndex < 0)
{
//JScript.Alert("请先选择某一典型票!");
return;
}
int no = 1;
uint maxTid, maxBodyTid;
_sql = "select count(*) from T_DD_TERMWISE_OPT_HEAD where to_char(DATEM,'YYYY')='" + DateTime.Now.ToString("yyyy") + "'";
int counts = Convert.ToInt16(DBOpt.dbHelper.ExecuteScalar(_sql)) + 1;
string ph = DateTime.Now.ToString("yyyy") + counts.ToString("0000");
maxTid = DBOpt.dbHelper.GetMaxNum("T_DD_TERMWISE_OPT_HEAD", "TID");
maxBodyTid = DBOpt.dbHelper.GetMaxNum("T_DD_TERMWISE_OPT_BODY", "TID");
_sql = "insert into T_DD_TERMWISE_OPT_HEAD(TID,TASK,DATEM,YPR,PH,STATION) values(" + maxTid.ToString() + ",'" + grvList.SelectedRow.Cells[2].Text + "'," +
"TO_DATE('" + DateTime.Now.ToString("yyyy-MM-dd") + "','YYYY-MM-DD'),'" + Session["MemberName"].ToString() + "','" + ph + "','" + ddlStation.SelectedItem.Text + "')";
if (DBOpt.dbHelper.ExecuteSql(_sql) > 0)
{
DataTable dt = DBOpt.dbHelper.GetDataTable("select * from T_DD_TYPICAL_OPT_BODY where HEAD_TID=" + grvList.SelectedDataKey[0].ToString());
for (int i = 0; i < dt.Rows.Count; i++)
{
_sql = "insert into T_DD_TERMWISE_OPT_BODY(HEAD_TID,TID,UNIT,XH,CONTENT) values(" + maxTid.ToString() + "," + maxBodyTid.ToString() + ",'" +
dt.Rows[i]["UNIT"].ToString() + "'," + no.ToString() + ",'" + dt.Rows[i]["CONTENT"].ToString() + "')";
if (DBOpt.dbHelper.ExecuteSql(_sql) > 0)
{
maxBodyTid++;
no++;
}
}
}
////从界面上无法知道是否从典型票中，只能从数据库中来判断
////如果选择了典型票，则T_DD_TERMWISE_OPT_HEAD有一条新记录，但PACK_NO没有值。
////需要取值此票，马上把相应的PACK_NO赋上，再显示此票
//string tid, pack_no;
//_sql = "select max(TID) from T_DD_TERMWISE_OPT_HEAD";
//object obj = DBOpt.dbHelper.ExecuteScalar(_sql);
//if (obj == null) return;
//tid = obj.ToString();
//_sql = "select PACK_NO from T_DD_TERMWISE_OPT_HEAD where TID=" + tid;
//obj = DBOpt.dbHelper.ExecuteScalar(_sql);
//if (obj != null) return; //有业务编号，则不处理。
//显示票内容
Session["RecNo"] = maxTid;
//CustomControlFill.CustomControlFillByTableAndWhere(this.Page, "T_DD_TERMWISE_OPT_HEAD", "TID=" + ViewState["RecNo"].ToString());
//initGridView();//取操作步骤
JScript.CloseWin("refreshPage");
}
protected void btnOK_Click(object sender, EventArgs e)
{
if (txtREASON.Text == "")
{
tdMessage.InnerText = "请填写退回理由！";
return;
}
if (WebWorkFlow.Withdraw(ViewState["PackNo"].ToString(), ViewState["CurWorkFlowNo"].ToString(), txtREASON.Text, Session["MemberName"].ToString()))
{
Session["sended"] = 1;
JScript.CloseWin("refreshPage");
}
else
{
tdMessage.InnerText = "退回不成功，请联系管理员！";
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
if (rblMember.SelectedItem == null)
{
tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "ItemNotNull").ToString(); // "请选择要改派的人员！";
return;
}
string packTypeNo, packTypeName;
packTypeNo = DBOpt.dbHelper.ExecuteScalar("select f_packtypeno from dmis_sys_pack where f_no=" + ViewState["InstanceID"]).ToString();
packTypeName = DBOpt.dbHelper.ExecuteScalar("select f_packname from dmis_sys_pack where f_no=" + ViewState["InstanceID"]).ToString();
string[] sqls = new string[2];
sqls[0] = "update dmis_sys_workflow set f_receiver ='" + rblMember.SelectedItem.Text + "',f_receivedate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' where f_no=" + ViewState["CurWorkFlowNo"].ToString();
sqls[1] = "update dmis_sys_memberstatus set f_receiver='" + rblMember.SelectedItem.Text + "',f_receivedate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' where f_packno="
+ ViewState["InstanceID"].ToString() + " and f_workflowno=" + ViewState["CurWorkFlowNo"] + " and f_receiver='" + txtMEMBER_NAME.Text + "'";
if (DBOpt.dbHelper.ExecuteSqlWithTransaction(sqls) > 0)
{
uint maxTid = DBOpt.dbHelper.GetMaxNum("DMIS_SYS_WK_OPT_HISTORY", "tid");
string reason = "将任务：" + tdPackDesc.InnerText + " 由 " + txtMEMBER_NAME.Text + " 改派给 " + rblMember.SelectedItem.Text;
_sql = "insert into DMIS_SYS_WK_OPT_HISTORY(tid,packno,opt_type,datem,member_name,reason,F_PACKTYPENO,F_PACKTYPENAME) values("
+ maxTid + "," + ViewState["InstanceID"].ToString() + ",'改派',TO_DATE('" + DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss") + "','DD-MM-YYYY HH24:MI:SS'),'"
+ Session["MemberName"].ToString() + "','" + reason + "'," + packTypeNo + ",'" + packTypeName + "')";
DBOpt.dbHelper.ExecuteSql(_sql);
//如果改派的主办人也是从办者之中，则删除从办
_sql = "delete from dmis_sys_memberstatus where f_packno="
+ ViewState["InstanceID"].ToString() + " and f_workflowno=" + ViewState["CurWorkFlowNo"] + " and f_receiver='" + rblMember.SelectedItem.Text + "'";
DBOpt.dbHelper.ExecuteSql(_sql);
JScript.CloseWin("refreshPage");
}
else
{
tdMessage.InnerText = GetGlobalResourceObject("WebGlobalResource", "SaveFailMessage").ToString();//"更改状态失败！请联系管理员！";
}
}