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) { 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 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 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); } }
//插入附件信息 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 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 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); } }