protected void btnSubmit_Click(object sender, EventArgs e)
{
if (filePhoto.HasFile)
{
string fileName = filePhoto.ShortFileName;
if (!ValidateFileType(fileName))
{
Alert.Show("无效的文件类型！");
return;
}
fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_");
fileName = DateTime.Now.Ticks.ToString() + "_" + fileName;
filePhoto.SaveAs(Server.MapPath("~/upload/" + fileName));
labResult.Text = "<p>用户名：" + tbxUseraName.Text + "</p>" +
"<p>头像：<br /><img src=\"" + ResolveUrl("~/upload/" + fileName) + "\" /></p>";
//// 清空表单字段（第一种方法）
//tbxUseraName.Reset();
//filePhoto.Reset();
// 清空表单字段（第三种方法）
SimpleForm1.Reset();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btnReset.OnClientClick = SimpleForm1.GetResetReference();
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
if (passwordIsOk(txb_origPsw.Text))
{
if (txb_password.Text == txb_password_confirm.Text)
{
string pswMd5 = PasswordUtil.CreateDbPassword(txb_password.Text.Trim());
string sqlCmd = "update OA_Sys_EmployeeInfo set password='******' where id=" + GetUser();
SqlSel.ExeSql(sqlCmd);
SimpleForm1.Reset();
Alert.Show("密码修改完成！");
}
else
{
Alert.ShowInTop("两次输入的密码不一致！请重新输入。");
return;
}
}
else
{
Alert.ShowInTop("原密码不匹配！");
return;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_PayMent_Main (reqMan,reqDte,payeeName,projId,FlowId,CurrentStepID,others,isAdvPay,payTotal) values ";
sqlCmd += "('" + GetUser() + "','" + DateTime.Now + "','" + txb_payeeName.Text + "','" + ddl_proj.SelectedValue + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "','" + rdb_payType.SelectedValue + "','" + numbbox_total.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_PayMent_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
//推送信息至相关审批人
pushMessage(stepId, "OA_PayMent_Main", formId, "付款申请");
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btn_sub_Click(object sender, EventArgs e)
{
try
{
if (Grid1.Rows.Count > 0)
{
for (int i = 0; i < Grid1.Rows.Count; i++)
{
GridRow grow = Grid1.Rows[i];
if (string.IsNullOrEmpty(((System.Web.UI.WebControls.TextBox)grow.FindControl("tbxWorkDtl")).Text))
{
Alert.ShowInTop("工作内容不可为空！");
return;
}
}
string sqlCmd = "";
sqlCmd = "insert into T_DailyWork (ReqDte,WorkDte,WorkNo,SelfGrade,Stat) values";
sqlCmd += "('" + DateTime.Now + "','" + label_date.Text + "','" + curUser + "'," + Convert.ToInt32(RadioButtonList_goal.SelectedValue) + ",11)";
SqlSel.ExeSql(sqlCmd);
sqlCmd = "select max(Id) from T_DailyWork where workno='" + curUser + "'";
int maxId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
for (int i = 0; i < Grid1.Rows.Count; i++)
{
GridRow grow = Grid1.Rows[i];
sqlCmd = "insert into T_Work_Detail_Record";
sqlCmd += "(MainID,WorkDetail,WorkProcess,Mark) values";
sqlCmd += "(" + maxId + ",'" + ((System.Web.UI.WebControls.TextBox)grow.FindControl("tbxWorkDtl")).Text + "',100,'" + Grid1.Rows[i].Values[0].ToString() + "')";
SqlSel.ExeSql(sqlCmd);
}
//推送相关提交信息
sqlCmd = "select CellPhone from x_user where name=(select rz_parentid from view_rs_employeeinfo where gh_id='" + curUser + "')";
string targetNum = SqlSel.GetSqlScale(sqlCmd).ToString();
string messageContent = string.Format("来自{0}的工作汇报", label_name.Text);
if (!string.IsNullOrEmpty(targetNum))
{
string url = string.Format("https://open.weixin.qq.com/connect/oauth2/authorize?appid=wxc1c3336a5eeb57ea&redirect_uri=http%3a%2f%2foa.mlily.com%3a30020%2fdailyWork%2fdailyWork_leaderView.aspx?mainId={0}&response_type=code&scope=SCOPE&state=STATE#wechat_redirect", maxId);
WX2HK.ReturnInfo.messagePushByNum(targetNum + ";", string.Format("{0}-工作汇报", label_date.Text), url, messageContent, "");
}
Alert.Show("提交成功！");
PageContext.RegisterStartupScript(SimpleForm1.GetResetReference());
Grid1.Reset();
btnSubmit.Hidden = true;
}
else
{
Alert.ShowInTop("请填写相关工作内容后再提交！");
return;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(numbbox_days.Text) & string.IsNullOrEmpty(numbbox_hours.Text))
{
Alert.ShowInTop("天数和小时至少填一项。");
return;
}
//if (string.IsNullOrEmpty(hidden_field.Value))
//{
// Alert.Show("请先添加相应的文件，若已添加则确认可用！");
// return;
//}
decimal days = 0;
decimal hours = 0;
if (!string.IsNullOrEmpty(numbbox_days.Text))
{
days = Convert.ToDecimal(numbbox_days.Text);
}
if (!string.IsNullOrEmpty(numbbox_hours.Text))
{
hours = Convert.ToDecimal(numbbox_hours.Text);
}
string stepId = getStepId(ddl_flow.SelectedValue);//获取步骤id
string sqlCmd = "insert into OA_Leave_Main ([reqMan],[reqDte],[strTime],[endTime],[lastDays],[leaveReason],[FlowId],[CurrentStepID],[workReplacer],[lastHours]) values ";
sqlCmd += "('" + curUserId + "','" + DateTime.Now + "','" + DatePicker1.Text + " " + TimePicker1.Text + "','" + DatePicker2.Text + " " + TimePicker2.Text + "','" + days + "',";
sqlCmd += "'" + TextArea_desc.Text.Trim() + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + txb_replacer.Text.Trim() + "','" + hours + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_Leave_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
PageContext.RegisterStartupScript("clearImg()");
//推送信息至相关审批人
pushMessage(stepId, "OA_Leave_Main", formId, "考勤申请");
}
else
{
Alert.Show("提交失败！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hidden_field.Value))
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_Bills_Main (reqMan,reqDte,billTotal,VoucherCount,FlowId,CurrentStepID,ReqReason,RelProj,ProveEmp) values ";
sqlCmd += "('" + curUserId + "','" + DateTime.Now + "','" + numbbox_total.Text.Trim() + "','" + numbbox_count.Text.Trim() + "',";
sqlCmd += "'" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "','" + ddl_proj.SelectedValue + "','" + txa_proveList.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_Bills_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
//插入关联费用项
string[] selectValueArray = ckbl_costItems.SelectedValueArray;
foreach (string item in selectValueArray)
{
sqlCmd = "insert into OA_Bills_RelCostItems ([formId],[CostItemId]) values (";
sqlCmd += "'" + formId + "','" + item + "')";
SqlSel.ExeSql(sqlCmd);
}
//插入证明人表
//if (!string.IsNullOrEmpty(txa_proveList.Text))
//{
// insertProveList(txa_proveList.Text, formId);
//}
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
PageContext.RegisterStartupScript("clearImg()");
//推送信息至相关审批人
pushMessage(stepId, "OA_Bills_Main", formId, "费用报销");
}
}
else
{
Alert.Show("请先添加相应的文件，若已添加则确认可用！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(recvId))
{
string sqlCmd = "insert into OA_Sys_Step_Emp (stepId,deptId,dutyId) values ( ";
sqlCmd += "'" + recvId + "','" + ddl_dept.SelectedValue + "','" + ddl_duty.SelectedValue + "')";
SqlSel.ExeSql(sqlCmd);
Alert.ShowInParent("保存成功，请关闭当前窗口查看。");
SimpleForm1.Reset();
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(recvId))
{
string sqlCmd = "insert into OA_Sys_Flow_Step (flowId,stepName,stepOrderNo) values (";
sqlCmd += "'" + recvId + "','" + txb_stepName.Text.Trim() + "','" + getMaxSort() + "')";
SqlSel.ExeSql(sqlCmd);
Alert.ShowInParent("编辑成功，请退出当前窗口！");
SimpleForm1.Reset();
//PageContext.RegisterStartupScript(ActiveWindow.GetHideReference());
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
if (newAddedList.Count > 0)
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_OfficeSupply_Main (reqMan,reqDte,FlowId,CurrentStepID,others) values ('" + GetUser() + "','" + DateTime.Now + "',";
sqlCmd += "'" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_OfficeSupply_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入申请明细
for (int i = 0; i < newAddedList.Count; i++)
{
string propertyName = newAddedList[i]["propertyName"].ToString();
string propertyNo = propertyName.Substring(0, propertyName.IndexOf("-"));
sqlCmd = "insert into OA_OfficeSupply_applyItem (officeSupplyId,propertyNo,applyCounts,applyUnit) values ('" + formId + "','" + propertyNo + "',";
sqlCmd += "'" + Convert.ToDecimal(newAddedList[i]["applyCounts"]) + "','" + newAddedList[i]["applyUnit"] + "')";
SqlSel.ExeSql(sqlCmd);
}
Alert.Show("提交成功！");
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
pushMessage(stepId, "OA_OfficeSupply_Main", formId, "办公用品申请");
}
else
{
Alert.ShowInTop("提交失败！");
return;
}
}
else
{
Alert.ShowInTop("尚未添加申领物品，不可提交！");
return;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hidden_field.Value))
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_Fines_Main (reqMan,reqDte,fineAmount,FlowId,CurrentStepID,ReqReason,projId,Objects,ProveEmp) values ";
sqlCmd += "('" + curUserId + "','" + DateTime.Now + "','" + numbbox_total.Text.Trim() + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "','" + ddl_proj.SelectedValue + "','" + txa_empList.Text + "','" + txa_proveList.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_Fines_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
//插入被处罚对象
//if (!string.IsNullOrEmpty(txa_empList.Text))
//{
// insertObjList(txa_empList.Text, formId);
//}
////插入证明人表
//if (!string.IsNullOrEmpty(txa_proveList.Text))
//{
// insertProveList(txa_proveList.Text, formId);
//}
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
PageContext.RegisterStartupScript("clearImg()");
//推送信息至相关审批人
pushMessage(stepId, "OA_Fines_Main", formId, "处罚流程");
}
}
else
{
Alert.Show("请先添加相应图片凭据！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadData();
btnReset.OnClientClick = SimpleForm1.GetResetReference();
JsObjectBuilder joBuilder = new JsObjectBuilder();
joBuilder.AddProperty("id", "grid_newtab_material_addnew");
joBuilder.AddProperty("title", "新增材料");
joBuilder.AddProperty("iframeUrl", "getNewWindowUrl()", true);
joBuilder.AddProperty("refreshWhenExist", true);
joBuilder.AddProperty("iconFont", "plus");
btnNew.OnClientClick = String.Format("parent.addTab({0});", joBuilder);
}
}
//插入附件信息
private void InsertFiles(string definedName)
{
string access_token = VerifyLegal.GetAccess_Token();//获取access_token
string sqlCmd = "";
string fileList = hidden_field.Value;
//解析明细Id
String[] str = fileList.Split(';');
int sortIndex = 0;//文件名后缀
foreach (string it in str)
{
if (it == "")
{
break;
}
sortIndex = sortIndex + 1;
string fileName = GetMultimedia(access_token, it, "/upload");
sqlCmd = "insert into OA_DocMgmt_DocList (docName,docTyp,docStat,subman,subDte,doc_leng,docPath) values ";
sqlCmd += "('" + definedName + "-" + sortIndex.ToString() + "','" + ddl_docType.SelectedValue + "',1,'" + curUserId + "','" + DateTime.Now + "',";
sqlCmd += "'" + ddl_proj.SelectedValue + "','" + fileName + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount == 0)
{
Alert.ShowInTop("上传出错！");
return;
}
else
{
//插入其他文件信息
sqlCmd = "select max(id) from OA_DocMgmt_DocList";
int docId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
sqlCmd = "insert into OA_DocMgmt_Propety (docId,docSN,AgreementPaty,SubjectMatter,AgreeAmount,AmountType,StartDate,EndDate,Remarks) values ";
sqlCmd += "('" + docId + "','" + txb_docSN.Text + "','" + txa_AgreementPaty.Text + "','" + txa_SubjectMatter.Text + "','" + numb_amount.Text + "',";
sqlCmd += "'" + txb_AmountType.Text + "','" + DatePicker1.Text + "','" + DatePicker2.Text + "','" + txa_Remarks.Text + "')";
SqlSel.ExeSql(sqlCmd);
}
}
Alert.Show("文件全部上传成功！");
//表单重置
SimpleForm1.Reset();
}
protected void btnSelectSecondRadio_Click(object sender, EventArgs e)
{
String[] radios = new String[] { "rbtnFirst", "rbtnSecond", "rbtnThird" };
for (int i = 0; i < radios.Length; i++)
{
if ((SimpleForm1.FindControl(radios[i]) as RadioButton).Checked)
{
int next = i + 1;
if (next >= radios.Length)
{
next = 0;
}
(SimpleForm1.FindControl(radios[next]) as RadioButton).Checked = true;
break;
}
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
string sqlCmd = "";
if (string.IsNullOrEmpty(recvId))
{
sqlCmd = "insert into OA_sys_Project (ProjName,FoundTime,ProjStatus,ProjDesc,workSpace,projItems,workFor,projAmount,workArea) values (";
sqlCmd += "'" + txb_ProjName.Text + "','" + DateTime.Now + "','" + rdbl_status.SelectedValue + "','" + txa_ProjDesc.Text + "',";
sqlCmd += "'" + txa_workSpace.Text + "','" + txa_projItems.Text + "','" + txb_WorkFor.Text + "','" + numb_amount.Text + "','" + Numb_workArea.Text + "')";
SimpleForm1.Reset();
}
else
{
sqlCmd = "update OA_sys_Project set ProjName='" + txb_ProjName.Text + "',ProjStatus='" + rdbl_status.SelectedValue + "',ProjDesc='" + txa_ProjDesc.Text + "',";
sqlCmd += "workSpace='" + txa_workSpace.Text + "',projItems='" + txa_projItems.Text + "',workFor='" + txb_WorkFor.Text + "',projAmount='" + numb_amount.Text + "',workArea='" + Numb_workArea.Text + "' where id=" + recvId;
}
SqlSel.ExeSql(sqlCmd);
Alert.Show("保存成功！请关闭当前窗口。");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hidden_field.Value))
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_PayMent_Main (reqMan,reqDte,payeeName,payTotal,projId,FlowId,CurrentStepID,others,isAdvPay) values ";
sqlCmd += "('" + curUserId + "','" + DateTime.Now + "','" + txb_payeeName.Text + "','" + numbbox_total.Text + "','" + ddl_proj.SelectedValue + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "','" + rdb_payType.SelectedValue + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_PayMent_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
PageContext.RegisterStartupScript("clearImg()");
//推送信息至相关审批人
pushMessage(stepId, "OA_PayMent_Main", formId, "付款申请");
}
}
else
{
Alert.ShowInTop("请先上传相应附件后再提交！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string stepId = getStepId(RadioButtonList1.SelectedValue);//获取步骤id
string sqlCmd = "insert into OA_UseStamp_Main ([reqMan],[reqDte],[useFor],[FlowId],[CurrentStepID],[stampType]) values ";
sqlCmd += "('" + GetUser() + "','" + DateTime.Now + "',";
sqlCmd += "'" + TextArea_desc.Text.Trim() + "','" + RadioButtonList1.SelectedValue + "','" + stepId + "','" + RadioButtonList1.SelectedValue + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_UseStamp_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
//推送信息至相关审批人
pushMessage(stepId, "OA_UseStamp_Main", formId, "用印申请");
}
else
{
Alert.Show("提交失败！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btnUpdateSelected_Click(object sender, EventArgs e)
{
// 在操作之前进行权限检查
if (!CheckPower("HcView"))
{
CheckPowerFailWithAlert();
return;
}
int ID = GetSelectedDataKeyID(Grid1);
if (ID != -1)
{
//保存工卡信息
Hc h = DB.Hcs.Where(u => u.ID == ID).FirstOrDefault();
h.part_name = tbx_part_name.Text;
h.pn = tbx_pn.Text;
h.sn = tbx_sn.Text;
h.part_type = DropDownList_Part_Type.SelectedValue;
h.condition = DropDownList_Condition.SelectedValue;
h.loc = tbx_loc.Text;
h.onhand = Convert.ToInt32(tbx_onhand.Text);
h.part_des = tbx_des.Text;
h.remark = tbx_remark.Text;
h.rec_date = Convert.ToDateTime(tbx_rec_date.Text);
DB.SaveChanges();
Alert.Show("航材数据更新成功！");
SimpleForm1.Reset();
BindGrid1();
}
else
{
Alert.Show("请选择要更新的航材！");
}
}
//
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//限当月提交
//int curMonth = DateTime.Now.Month;
//int subMonth = Convert.ToDateTime(DatePicker1.Text).Month;
//if (subMonth != curMonth)
//{
// Alert.ShowInTop("请假申请仅限当月提交");
// return;
//}
//补充说明不可超出数据库字段长度限制
if (TextArea_desc.Text.Length > 500)
{
Alert.ShowInTop("补充说明字符超限！");
return;
}
string date1 = DatePicker1.Text + " " + TimePicker1.Text;
string date2 = DatePicker2.Text + " " + TimePicker2.Text;
decimal days, hours;
string localImg = "";
//请假天数
if (string.IsNullOrEmpty(numbbox_days.Text))
{
days = 0;
}
else
{
days = Convert.ToDecimal(numbbox_days.Text);
}
//请假时间
if (string.IsNullOrEmpty(numbbox_hours.Text))
{
hours = 0;
}
else
{
hours = Convert.ToDecimal(numbbox_hours.Text);
}
//将图片保存至本地服务器
if (!string.IsNullOrEmpty(hidden_field.Value))
{
string access_token = VerifyLegal.GetAccess_Token();
localImg = GetMultimedia(access_token, hidden_field.Value);
}
string sqlCmd = "insert into T_LeaveReq (Typ,ReqMan,ReqDte,LeaveReason,LeaveDt1,LeaveDt2,Stat,Days,Hours,AddFunc,wxImgServId,localImgUrl) values ";
sqlCmd += "('" + RadioButtonList_goal.SelectedValue + "','" + workNo + "','" + DateTime.Now + "','" + TextArea_desc.Text + "','" + date1 + "','" + date2 + "',0,";
sqlCmd += "'" + days + "','" + hours + "',3,'" + hidden_field.Value + "','" + localImg + "')";
if (SqlSel.ExeSql(sqlCmd) == 0)
{
Alert.ShowInTop(sqlCmd, "执行出错！");
return;
}
else
{
sqlCmd = "select max(Id) from T_LeaveReq where reqman='" + workNo + "'";
int mainId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
sqlCmd = "insert into Rs_QjAndJb_Subdtl (yhbh,Typ,MainId) values ('" + workNo + "','2'," + mainId + ")";
SqlSel.ExeSql(sqlCmd);
//插入审批表
sqlCmd = "select parent_Gh from View_Rs_employeeinfo where Gh_id = '" + workNo + "'";
if (string.IsNullOrEmpty(SqlSel.GetSqlScale(sqlCmd).ToString()))
{
sqlCmd = "update T_LeaveReq set stat=-1 where id=" + mainId;
SqlSel.ExeSql(sqlCmd);
Alert.ShowInTop("您的直属上级没有设置，无法填写请假申请，请联系人事部门。");
return;
}
String spMan = SqlSel.GetSqlScale(sqlCmd).ToString();
sqlCmd = "insert into T_SpFollow (spTyp,tabId,WorkNo,Checked,Sort) values ('2'," + mainId + ",'" + spMan + "','0','1')";
SqlSel.ExeSql(sqlCmd);
//超过5天的请假多层审批
//if (days > 5)
//{
// sqlCmd = "select parent_Gh from View_Rs_employeeinfo where Gh_id = '" + spMan + "'";
// if (string.IsNullOrEmpty(SqlSel.GetSqlScale(sqlCmd).ToString()))
// {
// //无上上级领导直接跳过
// }
// else
// {
// String spMan2 = SqlSel.GetSqlScale(sqlCmd).ToString();
// sqlCmd = "insert into T_SpFollow (spTyp,tabId,WorkNo,Checked,Sort) values ('2'," + mainId + ",'" + spMan2 + "','0','2')";
// SqlSel.ExeSql(sqlCmd);
// }
//}
//向对象推送相关消息
sqlCmd = "select CellPhone from x_user where name='" + spMan + "'";
string targetNum = SqlSel.GetSqlScale(sqlCmd).ToString();
if (!string.IsNullOrEmpty(targetNum))
{
string url = string.Format("https://open.weixin.qq.com/connect/oauth2/authorize?appid=wxc1c3336a5eeb57ea&redirect_uri=http%3a%2f%2foa.mlily.com%3a30020%2fCheckOut%2fLeaveOut_leaderView.aspx?mainId={0}&response_type=code&scope=SCOPE&state=STATE#wechat_redirect", mainId);
WX2HK.ReturnInfo.messagePushByNum(targetNum + ";", "请假单", url, string.Format("来自 {0}的请假申请", label_name.Text), "");
}
Alert.ShowInTop("提交成功！");
//提交按钮隐藏
btnSubmit.Hidden = true;
//表单重置
PageContext.RegisterStartupScript(SimpleForm1.GetResetReference());
//Image1.ImageUrl = null;
hidden_field.Value = null;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}
protected void btnRest_Click(object sender, EventArgs e)
{
SimpleForm1.Reset();
BindGrid();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string stepId = getStepId(ddl_flow.SelectedValue); //获取步骤id
string sqlCmd = "";
if (checkBox_personal.Checked == true) //个人用车
{
sqlCmd = "insert into OA_Car_Main ([reqMan],[reqDte],[carNumb],[curMileage],[withWho],[useReason],[FlowId],[CurrentStepID],[useDate],[backTime],[toWhere],[projId]) values ";
sqlCmd += "('" + GetUser() + "','" + DateTime.Now + "','" + txb_carNumb.Text.Trim() + "','" + numbbox_curMileage.Text + "','" + txb_withWho.Text + "',";
sqlCmd += "'" + TextArea_desc.Text.Trim() + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + DatePicker1.Text + " " + TimePicker1.Text + "',";
sqlCmd += "'" + DatePicker2.Text + " " + TimePicker2.Text + "','" + txb_toWhere.Text + "','" + ddl_proj.SelectedValue + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_Car_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
//推送信息至相关审批人
pushMessage(stepId, "OA_Car_Main", formId, "用车申请");
}
else
{
Alert.Show("提交失败！");
return;
}
}
else //单位用车
{
sqlCmd = "insert into OA_Car_Main ([reqMan],[reqDte],[deptCarId],[curMileage],[withWho],[useReason],[FlowId],[CurrentStepID],[useDate],[backTime],[toWhere],[projId]) values ";
sqlCmd += "('" + GetUser() + "','" + DateTime.Now + "','" + ddl_carList.SelectedValue + "','" + numbbox_curMileage.Text + "','" + txb_withWho.Text + "',";
sqlCmd += "'" + TextArea_desc.Text.Trim() + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + DatePicker1.Text + " " + TimePicker1.Text + "',";
sqlCmd += "'" + DatePicker2.Text + " " + TimePicker2.Text + "','" + txb_toWhere.Text + "','" + ddl_proj.SelectedValue + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//更新单位车辆征用状态
sqlCmd = "update OA_Property_Register set OnUsing='1' where id='" + ddl_carList.SelectedValue + "'";
SqlSel.ExeSql(sqlCmd);
//取当前单据id
sqlCmd = "select max(id) from OA_Car_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
//推送信息至相关审批人
pushMessage(stepId, "OA_Car_Main", formId, "用车申请");
}
else
{
Alert.Show("提交失败！");
return;
}
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
