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