protected void bindGrid() { try { DataTable dt = new DataTable(); string sqlCmd = "select * from OA_Bills_costLists where [bStatus]='1' order by id"; SqlSel.GetSqlSel(ref dt, sqlCmd); Grid1.DataSource = dt; Grid1.DataBind(); sqlCmd = "select max(id) from OA_Bills_costLists"; string curMaxId = SqlSel.GetSqlScale(sqlCmd).ToString(); if (string.IsNullOrEmpty(curMaxId)) { label_hidden.Text = "0"; } else { label_hidden.Text = curMaxId; } } catch (Exception ex) { Alert.ShowInTop(ex.Message); 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 bindGrid() { try { DataTable dt = new DataTable(); string sqlCmd = "select * from OA_Property_Register order by BuyDate desc"; SqlSel.GetSqlSel(ref dt, sqlCmd); Grid1.DataSource = dt; Grid1.DataBind(); sqlCmd = "select max(id) from OA_Property_Register"; string curMaxId = SqlSel.GetSqlScale(sqlCmd).ToString(); if (string.IsNullOrEmpty(curMaxId)) { label_hidden.Text = "0"; } else { label_hidden.Text = curMaxId; } } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
//添加表格页脚打印信息 protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { string printUser = ""; string sqlCmd = "select chinesename from x_user where name='" + GetUser() + "'"; printUser = SqlSel.GetSqlScale(sqlCmd).ToString(); if (e.Row.RowType == DataControlRowType.Footer) { //e.Row.Cells[0].ColumnSpan = e.Row.Cells.Count; //e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right; //e.Row.Cells[0].Text = "打印人:" + GetUser() + " | 打印时间:" + DateTime.Now; TableCell oldTc = e.Row.Cells[0]; for (int i = 1; i < e.Row.Cells.Count; i++) { TableCell tc = e.Row.Cells[i]; if (oldTc.Text == tc.Text) { tc.Visible = false; if (oldTc.ColumnSpan == 0) { oldTc.ColumnSpan = 1; } oldTc.ColumnSpan++; //oldTc.VerticalAlign = VerticalAlign.Middle; } else { oldTc = tc; } } oldTc.Text = "打印人:" + printUser + " | 打印时间:" + DateTime.Now; oldTc.HorizontalAlign = HorizontalAlign.Right; } }
private string getStepId(string flowId) { string sqlCmd = "select id from OA_Sys_Flow_Step where flowid='" + flowId + "' and stepOrderNo=1"; string stepId = SqlSel.GetSqlScale(sqlCmd).ToString(); return(stepId); }
protected void bindGrid() { try { DataTable dt = new DataTable(); string sqlCmd = "select * from OA_DocMgmt_DocType where pid='0' and stat=1 order by type_name"; SqlSel.GetSqlSel(ref dt, sqlCmd); Grid1.DataSource = dt; Grid1.DataBind(); sqlCmd = "select max(id) from OA_DocMgmt_DocType"; string curMaxId = SqlSel.GetSqlScale(sqlCmd).ToString(); if (string.IsNullOrEmpty(curMaxId)) { label_hidden.Text = "0"; } else { label_hidden.Text = curMaxId; } } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
//提交 protected void btnSubmit_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(RadioButtonList_goal.SelectedValue)) { string sqlcmd = "update T_DailyWork set LeaderGrade=" + Convert.ToInt32(RadioButtonList_goal.SelectedValue) + ",LeaderGradeReason='" + TextArea_context.Text + "' where Id=" + tabId + " "; int exeCount = SqlSel.ExeSql(sqlcmd); if (exeCount > 0) { //将审批结果反馈给相关人员 string messageContent = string.Format("工作评分:{0}分\\n领导寄语:{1}", RadioButtonList_goal.SelectedValue, TextArea_context.Text); sqlcmd = "select cellPhone from x_user where name='" + label_hidden.Text + "'"; string targetNum = SqlSel.GetSqlScale(sqlcmd).ToString(); if (!string.IsNullOrEmpty(targetNum)) { WX2HK.ReturnInfo.messagePushByNum(targetNum + ";", string.Format("{0}-工作情况", label_date.Text), "", messageContent, ""); } //Alert.Show("提交成功!"); btnSubmit.Hidden = true; // 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } } else { Alert.ShowInTop("请打分!"); return; } }
//排产数据的添加 private void infoInsert() { string curUser = GetUser(); if (!string.IsNullOrEmpty(curUser)) { int isTempOrder = 0; if (CkeckBox_enabled.Checked) { isTempOrder = 1; } string ImgURL = label_hidden.Text; string sqlCmd = "insert into [PLM_Product_OnLine] ([LineId],[OrderId],[BuildTime],[OnlineStatus],[OperUser] ,[PlanCount] ,[IsTemp] ,[OrderNo] ,[ItemParm] ,[ItemName],[ItemNo],[RedLineCount],[PreSetCount],[ItemTech])"; sqlCmd += " values ('" + ddl_line.SelectedValue + "','" + Label_sn.Text + "','" + DateTime.Now + "',1,'" + curUser + "','" + numb_planCount.Text + "','" + isTempOrder + "',"; sqlCmd += "'" + txb_workNo.Text + "','" + TextArea_parm.Text + "','" + txb_itemName.Text + "','" + txb_itemNo.Text + "','" + numb_redCount.Text + "','" + numb_preSet.Text + "','" + txb_itemTech.Text + "')"; SqlSel.ExeSql(sqlCmd); sqlCmd = "select max(id) from PLM_Product_OnLine"; int onlineId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd)); sqlCmd = "insert into PLM_Product_Image (OnlineId,ImgURL) values "; sqlCmd += "('" + onlineId + "','" + ImgURL + "')"; SqlSel.ExeSql(sqlCmd); //执行关联明细信息的数据插入(单条) string sqlStr = "insert into PLM_Product_Rel (orderid,ProdId,PriLevel,OrderCount) values "; sqlStr += "('" + Label_sn.Text + "','" + onlineId + "',1,'" + numb_redCount.Text + "')"; SqlSel.ExeSql(sqlStr); Alert.ShowInTop("操作成功!"); PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } }
/// <summary> /// 根据表单类型和岗位加载可用流程 /// </summary> /// <param name="formName">表单类型名称</param> /// <param name="userId">用户id</param> /// <returns>流程相关信息</returns> public static DataTable validFlow(string formName, string userId) { //表单关联所有流程 string sqlCmd = "select B.flowName,B.id from OA_Sys_FlowRelForm A left join OA_sys_flow B on A.flowId=B.id where A.formDataName='" + formName + "' and B.isUsed='1'"; DataTable dt = new DataTable(); SqlSel.GetSqlSel(ref dt, sqlCmd); //获取登录用户岗位 sqlCmd = "select dutyId from OA_Sys_EmployeeInfo where id='" + userId + "'"; string userDuty = SqlSel.GetSqlScale(sqlCmd).ToString(); //遍历流程,没有指定岗位的显示,指定岗位但人员不在列的不显示 for (int rowIndex = 0; rowIndex < dt.Rows.Count; rowIndex++) { string compFlowId = dt.Rows[rowIndex]["id"].ToString(); sqlCmd = "select * from OA_Sys_FlowRelDuty where flowId='" + compFlowId + "'"; DataTable tempDt = new DataTable(); SqlSel.GetSqlSel(ref tempDt, sqlCmd); if (tempDt.Rows.Count > 0) { DataRow[] findRow = tempDt.Select("dutyId='" + userDuty + "' "); if (findRow.Length == 0) { dt.Rows.RemoveAt(rowIndex); } } } return(dt); }
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); } }
private void loadUserInfo(string LoginUserId) { string sqlCmd = "select chineseName from OA_Sys_EmployeeInfo where id='" + LoginUserId + "' "; string curUser = SqlSel.GetSqlScale(sqlCmd).ToString(); //label_userInfo.Text = curUser + ",欢迎登陆."; div_member.InnerText = curUser + ",欢迎登陆."; }
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 autoLogistics(string shopId) { //DataTable dt1 = new DataTable(); //string sqlcmd="select [TradeStatus],[TradeNO],[ShopID],(select [Name] FROM [mbh_wdgj31].[dbo].[G_Cfg_LogisticList] where [G_Trade_TradeList].LogisticID= [G_Cfg_LogisticList].LogisticID) as [LogisticName]" // +" ,[PostID],[TradeNO2] from [mbh_wdgj31].[dbo].[G_Trade_TradeList] " // +" where [ShopID]='1029' and [TradeStatus]=11 and [TradeNO2] like '%-%' " // + " and [TradeNO]>(select top 1 max([TradeNO]) from WDApiFH ) and TradeFrom='蜘蛛'"; //取已同步的最大发货时间前1天所有数据去重并同步 string sqlcmd = "select [TradeStatus],[TradeNO],[ShopID],[sndtime],(select [Name] FROM" + " [mbh_wdgj31].[dbo].[G_Cfg_LogisticList] where [G_Trade_TradeList].LogisticID= [G_Cfg_LogisticList].LogisticID) as [LogisticName]" + " ,[PostID],[TradeNO2],(select nickName from g_customer_customerlist where G_Trade_TradeList.customerId=g_customer_customerlist.customerId) as nickName" + " from [mbh_wdgj31].[dbo].[G_Trade_TradeList] where [ShopID]='" + shopId + "' and [TradeStatus]=11" + " and sndTime>dateadd(day,-1,ISNULL((select max(sendtime) from WDApiFH where cipher='" + shopId + "'),'2017-09-01'))" + " and TradeFrom='蜘蛛'"; DataTable dt = new DataTable(); SqlSel.GetSqlSel(ref dt, sqlcmd); StringBuilder sb = new StringBuilder(); try { for (int i = 0; i < dt.Rows.Count; i++) { string LogisticName = dt.Rows[i]["LogisticName"].ToString(); string PostID = dt.Rows[i]["PostID"].ToString(); string orderid = dt.Rows[i]["TradeNO2"].ToString(); string tradeNo = dt.Rows[i]["TradeNO"].ToString(); string sendTime = Convert.ToDateTime(dt.Rows[i]["sndTime"]).ToString("yyyy-MM-dd HH:mm:ss.fff"); string nickName = dt.Rows[i]["nickName"].ToString(); sb.Append(mSndGoods(orderid, LogisticName, PostID, nickName, tradeNo, sendTime, shopId)); } Label1.Text = sb.ToString(); sqlcmd = "select isnull(max(rqtid),0) from wdapifh where cipher='" + shopId + "' "; int curId = Convert.ToInt32(SqlSel.GetSqlScale(sqlcmd)); //记录自动执行日志 sqlcmd = "insert into t_sfy_autoExecLog (execTime,execCount,shopId) values ('" + DateTime.Now + "'," + curId + ",'" + shopId + "')"; SqlSel.ExeSql(sqlcmd); Label_status.Text = string.Format("{0},【1039】同步物流信息完成。", DateTime.Now); //同步记录前台更新 reloadLog(); } catch (Exception ex) { Label_status.Text = ex.Message; Timer2.Enabled = false; } //dt1.DataSet.Clear(); }
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); } }
//获取菜单序列号 private int getSortIndex(string parentId) { int sortIndex = 0; DataTable dt = new DataTable(); string sqlCmd = "select max(sortIndex) from OA_Sys_Menu where ParentMenuId='" + parentId + "'"; string res = SqlSel.GetSqlScale(sqlCmd).ToString(); if (!string.IsNullOrEmpty(res)) { sortIndex = Convert.ToInt32(res); } return(sortIndex); }
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); } }
//验证与原密码是否匹配 private bool passwordIsOk(string inputStr) { string sqlCmd = "select password from OA_Sys_EmployeeInfo where id='" + GetUser() + "'"; string dbPsw = SqlSel.GetSqlScale(sqlCmd).ToString(); if (PasswordUtil.ComparePasswords(dbPsw, inputStr)) { return(true); } else { return(false); } }
//判断当前人员是否有页面审批权限 private bool haveNoCheckPrivilege(int mainId, string loginUser) { string sqlCmd = "select rz_parentid from view_rs_employeeinfo where gh_id=(select workno from t_dailywork where id=" + mainId + ")"; string rz_parentid = SqlSel.GetSqlScale(sqlCmd).ToString();//拥有审批权限的工号 if (loginUser != rz_parentid) { return(true); } else { return(false); } }
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 btn_save_Click(object sender, EventArgs e) { string sqlCmd = ""; int userStatus = ckeckBox_enabled.Checked ? 1 : 0; if (string.IsNullOrEmpty(recvId)) { sqlCmd = "insert into OA_Sys_EmployeeInfo (loginId,password,chineseName,deptId,dutyId,useStatus,phoneNumber) values ("; sqlCmd += "'" + txb_loginID.Text + "','" + PasswordUtil.CreateDbPassword("123456") + "','" + txb_chineseName.Text + "',"; sqlCmd += "'" + ddl_depart.SelectedValue + "','" + ddl_duty.SelectedValue + "','" + userStatus + "','" + numbb_phoneNumb.Text + "')"; int exeCount = SqlSel.ExeSql(sqlCmd); if (exeCount == 1) { sqlCmd = "select max(id) from OA_Sys_EmployeeInfo"; string newUserId = SqlSel.GetSqlScale(sqlCmd).ToString(); //更新角色信息 string[] selectValueArray = ckb_roleList.SelectedValueArray; foreach (string item in selectValueArray) { sqlCmd = "insert into OA_Sys_UserRole (userid,roleid,addtime) values ("; sqlCmd += "'" + newUserId + "','" + item + "','" + DateTime.Now + "')"; SqlSel.ExeSql(sqlCmd); } } } else { sqlCmd = "update OA_Sys_EmployeeInfo set loginId='" + txb_loginID.Text + "',chineseName='" + txb_chineseName.Text + "',deptId='" + ddl_depart.SelectedValue + "',"; sqlCmd += "dutyId='" + ddl_duty.SelectedValue + "',useStatus='" + userStatus + "',phoneNumber='" + numbb_phoneNumb.Text + "' where id=" + recvId; SqlSel.ExeSql(sqlCmd); //删除用户现有角色 sqlCmd += "delete from OA_Sys_UserRole where userid=" + recvId; SqlSel.ExeSql(sqlCmd); string[] selectValueArray = ckb_roleList.SelectedValueArray; foreach (string item in selectValueArray) { sqlCmd = "insert into OA_Sys_UserRole (userid,roleid,addtime) values ("; sqlCmd += "'" + recvId + "','" + item + "','" + DateTime.Now + "')"; SqlSel.ExeSql(sqlCmd); } } Alert.ShowInTop("保存成功!"); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); }
//插入附件信息 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(); }
//排产数据的添加 private void infoInsert() { string curUser = GetUser(); if (!string.IsNullOrEmpty(curUser)) { int isTempOrder = 0; if (CkeckBox_enabled.Checked) { isTempOrder = 1; } string ImgURL = label_hidden.Text; if (!filePhoto.HasFile) { ImgURL = "636195999216328808_84U58PICkTn.jpg";//设置默认图片 } string sqlCmd = "insert into [PLM_Product_OnLine] ([LineId],[BuildTime],[OnlineStatus],[OperUser] ,[PlanCount] ,[IsTemp] ,[OrderNo] ,[ItemParm] ,[ItemName],[ItemNo],[RedLineCount],[PreSetCount],[ItemTech])"; sqlCmd += " values ('" + ddl_line.SelectedValue + "','" + DateTime.Now + "',1,'" + curUser + "','" + numb_planCount.Text + "','" + isTempOrder + "',"; sqlCmd += "'" + txb_workNo.Text + "','" + TextArea_parm.Text + "','" + txb_itemName.Text + "','" + txb_itemNo.Text + "','" + numb_redCount.Text + "','" + numb_preSet.Text + "','" + txb_itemTech.Text + "')"; SqlSel.ExeSql(sqlCmd); sqlCmd = "select max(id) from PLM_Product_OnLine"; int onlineId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd)); sqlCmd = "insert into PLM_Product_Image (OnlineId,ImgURL) values "; sqlCmd += "('" + onlineId + "','" + ImgURL + "')"; SqlSel.ExeSql(sqlCmd); //string find = ""; if (!CkeckBox_enabled.Checked)//如果不是临时插单,不插入关联信息 { for (int i = 0; i < Grid_hidden.Rows.Count; i++) { //获取合并的订单信息 int recId = Convert.ToInt32(Grid_hidden.Rows[i].Values[0]); int orderCount = Convert.ToInt32(Grid_hidden.Rows[i].Values[1]); //执行关联明细信息的数据插入 string sqlStr = "insert into PLM_Product_Rel (orderid,ProdId,PriLevel,OrderCount) values "; sqlStr += "('" + recId + "','" + onlineId + "',1,'" + orderCount + "')"; SqlSel.ExeSql(sqlStr); } } //表单重置 PageContext.RegisterStartupScript(Region2.GetResetReference()); Alert.ShowInTop("操作成功!"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { //更新加班申请表状态 DateTime spDte = System.DateTime.Now; String sqlCmd = "update T_Overtime set Stat = '1' where Id = " + tabId + ""; SqlSel.ExeSql(sqlCmd); //更新审批状态 sqlCmd = "update T_SpFollow set Checked = '1',CheckeDte = '" + spDte + "' where tabId = " + tabId + " and spTyp = '1'"; SqlSel.ExeSql(sqlCmd); //写入考勤数据库 sqlCmd = "INSERT INTO [HKKQ_real].[dbo].[KQ_b_Addban] "; sqlCmd += "([YhBH] ,[StartRqSj] ,[EndRqSj],[czy] ,[rq],[typ],[times])"; sqlCmd += "(select yhbh,reqdt1,reqdt2,reqman,Convert(char(10),reqdte,120),addfunc,ADDTIME from T_Overtime,rs_qjandjb_subdtl "; sqlCmd += "where T_Overtime.id= " + tabId + " and typ=1 and rs_qjandjb_subdtl.mainid= " + tabId + ")"; SqlSel.ExeSql(sqlCmd); //Alert.ShowInTop("审批完成!"); //审批按钮隐藏 btnSubmit.Hidden = true; //将考勤结果反馈给部门考勤员 sqlCmd = "select x_user.cellPhone from "; sqlCmd += "(select a.gh_id from view_banzhi_rsRole a inner join view_rs_employeeinfo b on a.departid=b.departid and b.gh_id=(select reqman from T_Overtime where id=" + tabId + ")) c "; sqlCmd += "left join x_user on x_user.name=c.gh_id"; string notifyTarget = SqlSel.GetSqlScale(sqlCmd).ToString(); //抄送信息至部门相关考勤员 string messageContent = string.Format("加班人员:{0}\\n加班时长:{3} \\n起始时间:{1} \\n截止时间:{2} ", label_personDtl.Text, label_startTime.Text, label_endTime.Text, label_hours.Text); if (!string.IsNullOrEmpty(notifyTarget)) { WX2HK.ReturnInfo.messagePushByNum(notifyTarget + ";", "加班登记", "", messageContent, ""); } // 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
//判断当前人员是否有页面审批权限 //private bool haveNoCheckPrivilege(string mainId) //{ // string sqlCmd = "select WorkNo from T_SpFollow where tabId=" + mainId + " and spTyp = '2'"; // string spMan = SqlSel.GetSqlScale(sqlCmd).ToString();//拥有审批权限的工号 // //if (spMan != curWorkNo) // //{ // // return true; // //} // //else // //{ // // return false; // //} //} protected void btnSubmit_Click(object sender, EventArgs e) { try { //更新审批表 String sqlCmd = "update T_SpFollow set Checked = '1',CheckeDte = '" + DateTime.Now + "' where tabId = " + tabId + " and spTyp = '2'"; SqlSel.ExeSql(sqlCmd); //更新请假单状态 sqlCmd = "update T_LeaveReq set Stat = '1' where Id = " + tabId + ""; SqlSel.ExeSql(sqlCmd); //Alert.ShowInTop("审批完成!"); //将考勤结果反馈给部门考勤员 sqlCmd = "select x_user.cellPhone from "; sqlCmd += "(select a.gh_id from view_banzhi_rsRole a inner join view_rs_employeeinfo b on a.departid=b.departid and b.gh_id=(select reqman from T_LeaveReq where id=" + tabId + ")) c "; sqlCmd += "left join x_user on x_user.name=c.gh_id"; string notifyTarget = SqlSel.GetSqlScale(sqlCmd).ToString(); //抄送信息至部门相关考勤员 string messageContent = string.Format("请假人员:{0}\\n天数:{3} \\n小时:{4} \\n起始时间:{1} \\n截止时间:{2} ", label_personDtl.Text, label_startTime.Text, label_endTime.Text, label_days.Text, label_hours.Text); if (!string.IsNullOrEmpty(notifyTarget)) { WX2HK.ReturnInfo.messagePushByNum(notifyTarget + ";", "请假登记", "", messageContent, ""); } //审批按钮隐藏 btnSubmit.Hidden = true; //写入考勤数据库 sqlCmd = "INSERT INTO [HKKQ_real].[dbo].[KQ_b_Leave] "; sqlCmd += "([YhBH],[StartRqSj],[EndRqSj],[Hours],[Days],[Cause],[Memo],[czy]) "; sqlCmd += "(select yhbh,leavedt1,leavedt2,hours,days,T_LeaveReq.typ,addfunc,reqman from T_LeaveReq,rs_qjandjb_subdtl "; sqlCmd += "where T_LeaveReq.id= " + tabId + " and rs_qjandjb_subdtl.typ=2 and rs_qjandjb_subdtl.mainid= " + tabId + ")"; SqlSel.ExeSql(sqlCmd); // 关闭本窗体,然后刷新父窗体 PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } 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_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); } }
/// <summary> /// 插入节点审批对象并推送相关微信信息 /// </summary> /// <param name="stepId">审批步骤id</param> /// <param name="tableName">表单数据库表名</param> /// <param name="formId">表单id</param> /// <param name="MessageName">审批类型名称</param> public static void pushMessage(string stepId, string tableName, string formId, string MessageName) { StringBuilder sb = new StringBuilder(); string sqlCmd = "select * from OA_Sys_Step_Emp where stepId='" + stepId + "'"; DataTable dt = new DataTable(); SqlSel.GetSqlSel(ref dt, sqlCmd); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string deptId = dt.Rows[i]["deptId"].ToString(); string dutyId = dt.Rows[i]["dutyId"].ToString(); if (deptId == "0") //申请人本部门 { sqlCmd = "select deptId from OA_Sys_EmployeeInfo where id=(select reqman from " + tableName + " where id='" + formId + "')"; deptId = SqlSel.GetSqlScale(sqlCmd).ToString(); } DataTable dtNodeUserList = new DataTable(); sqlCmd = "select id from OA_Sys_EmployeeInfo where deptid='" + deptId + "' and dutyId='" + dutyId + "' and useStatus='1'"; SqlSel.GetSqlSel(ref dtNodeUserList, sqlCmd); for (int j = 0; j < dtNodeUserList.Rows.Count; j++) { sqlCmd = "insert into OA_Sys_step_empList (stepId,userId,formId,formDataName,formName) values ('" + stepId + "','" + dtNodeUserList.Rows[j]["id"].ToString() + "',"; sqlCmd += "'" + formId + "','" + tableName + "','" + MessageName + "')"; int exeCount = SqlSel.ExeSql(sqlCmd);//插入节点审批人员明细表 //插入成功则向相关人员的微信推送消息 if (exeCount > 0) { sb.AppendFormat("{0}|", dtNodeUserList.Rows[j]["id"].ToString()); } } } //跳转至待办任务页面 string url = targetUrl("admin%2fMissionList.aspx"); WX2HK.ReturnInfo.pushMessage(sb.ToString(), MessageName, url, "有您的审批信息,请及时查阅。", ""); } }
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 btn_delete_Click(object sender, EventArgs e) { int[] selections = Grid1.SelectedRowIndexArray; string sqlCmd = ""; StringBuilder sb_Order = new StringBuilder(); for (int i = 0; i < selections.Length; i++) { sqlCmd = "select count(*) from PLM_Serials_BindBarCode where tradeno='" + Grid1.DataKeys[selections[i]][0].ToString() + "'"; int bindCount = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd)); if (bindCount > 0) { Alert.ShowInTop(string.Format("第{0}行存在已上架数据,不可直接删除!", selections[i] + 1)); return; } else { sqlCmd = "delete from PLM_Product_OnLine where id='" + Grid1.DataKeys[selections[i]][0].ToString() + "'"; SqlSel.ExeSql(sqlCmd); } } Alert.Show("已删除!"); }
protected void btn_publish_Click(object sender, EventArgs e) { try { string context = txb_title.Text; string sqlCmd = "insert into OA_Announcement (AnncTitle,AnncContext,AnncAuthor,CreateTime,isDeleted) "; sqlCmd += "values ('" + txb_title.Text + "','" + HtmlEditor1.Text + "','" + GetUser() + "','" + DateTime.Now + "','0')"; int execCount = SqlSel.ExeSql(sqlCmd); if (execCount == 1) { sqlCmd = "select max(id) from OA_Announcement"; int anncId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd)); //插入附件 InsertFiles(anncId.ToString()); //微信推送 if (isPushWX.Checked) { DataTable wxUserDt = selectUser.getDeptUserList(System.Configuration.ConfigurationManager.AppSettings["CorpDeptId"]);//得到部门中的所有人员信息 System.Text.StringBuilder toUsers = new System.Text.StringBuilder(); for (int i = 0; i < wxUserDt.Rows.Count; i++) { toUsers.AppendFormat("{0}|", wxUserDt.Rows[i]["userid"].ToString()); } string url = targetUrl(string.Format("admin%2fAnnouncement_Detail.aspx?id={0}", anncId)); ReturnInfo.pushMessage(toUsers.ToString(), "公告信息", url, context, ""); } Alert.Show("公告发布成功!"); PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); } } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
protected void btn_save_Click(object sender, EventArgs e) { string sqlCmd = ""; int useStatus = ckeckBox_enabled.Checked ? 1 : 0; if (string.IsNullOrEmpty(recvId)) { sqlCmd = "insert into OA_sys_flow (flowName,createTime,isUsed,flowDesc) values ("; sqlCmd += "'" + txb_flowName.Text + "','" + DateTime.Now + "','" + useStatus + "','" + txa_flowDesc.Text + "')"; SqlSel.ExeSql(sqlCmd); //获取流程id sqlCmd = "select max(id) from OA_sys_flow"; int flowId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd)); //插入关联表单 string[] formArray = cbl_relForm.SelectedValueArray; foreach (string selectItem in formArray) { sqlCmd = "insert into OA_Sys_FlowRelForm ([flowId],[formDataName]) values ('" + flowId + "','" + selectItem + "')"; SqlSel.ExeSql(sqlCmd); } //维护关联岗位数据 sqlCmd = "delete from OA_Sys_FlowRelDuty where flowid='" + flowId + "'"; SqlSel.ExeSql(sqlCmd); //插入关联表单 string[] dutyArray = cbl_relDuty.SelectedValueArray; foreach (string selectItem in dutyArray) { sqlCmd = "insert into OA_Sys_FlowRelDuty ([flowId],[dutyId]) values ('" + flowId + "','" + selectItem + "')"; SqlSel.ExeSql(sqlCmd); } } else { sqlCmd = "update OA_sys_flow set flowName='" + txb_flowName.Text + "',createTime='" + DateTime.Now + "',isUsed='" + useStatus + "',flowDesc='" + txa_flowDesc.Text + "' where id=" + recvId; SqlSel.ExeSql(sqlCmd); //删除现有关联表单数据 sqlCmd = "delete from OA_Sys_FlowRelForm where flowid='" + recvId + "'"; SqlSel.ExeSql(sqlCmd); //插入关联表单 string[] formArray = cbl_relForm.SelectedValueArray; foreach (string selectItem in formArray) { sqlCmd = "insert into OA_Sys_FlowRelForm ([flowId],[formDataName]) values ('" + recvId + "','" + selectItem + "')"; SqlSel.ExeSql(sqlCmd); } //维护关联岗位数据 sqlCmd = "delete from OA_Sys_FlowRelDuty where flowid='" + recvId + "'"; SqlSel.ExeSql(sqlCmd); //插入关联表单 string[] dutyArray = cbl_relDuty.SelectedValueArray; foreach (string selectItem in dutyArray) { sqlCmd = "insert into OA_Sys_FlowRelDuty ([flowId],[dutyId]) values ('" + recvId + "','" + selectItem + "')"; SqlSel.ExeSql(sqlCmd); } } Alert.Show("保存成功!请关闭当前窗口。"); //PageContext.RegisterStartupScript(ActiveWindow.GetHideReference()); }