//测试推送 protected void btn_test_Click(object sender, EventArgs e) { //将图片保存至本地服务器 if (hidden_field.Value != null) { string access_token = VerifyLegal.GetAccess_Token(); GetMultimedia(access_token, hidden_field.Value); } //string num = ""; //WX2HK.ReturnInfo.messagePushByNum(num, "良辰在此", "", "你们这些渣渣~!", ""); }
//插入附件信息 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_synCorpToWx_Click(object sender, EventArgs e) { DataTable wxUserDt = new DataTable(); string deptId = System.Configuration.ConfigurationManager.AppSettings["CorpDeptId"]; //指定企业号通讯录部门Id wxUserDt = selectUser.getDeptUserList(deptId); //得到企业号中的所有人员信息 string sqlCmd = "select * from OA_Sys_EmployeeInfo where useStatus='1'"; DataTable corpUserDt = new DataTable(); SqlSel.GetSqlSel(ref corpUserDt, sqlCmd);//获取企业信息中所有在职人员 for (int i = 0; i < corpUserDt.Rows.Count; i++) { string userId = corpUserDt.Rows[i]["id"].ToString(); DataRow[] drArr = wxUserDt.Select("userid='" + userId + "'"); //如果成员不存在,则创建 if (drArr.Length == 0) { VerifyLegal.createUser(corpUserDt.Rows[i]["id"].ToString(), corpUserDt.Rows[i]["chineseName"].ToString(), deptId, corpUserDt.Rows[i]["phoneNumber"].ToString()); } else //存在则更新信息 { VerifyLegal.updateUser(corpUserDt.Rows[i]["id"].ToString(), corpUserDt.Rows[i]["chineseName"].ToString(), deptId, corpUserDt.Rows[i]["phoneNumber"].ToString()); } } //删除离职人员信息 sqlCmd = "select * from OA_Sys_EmployeeInfo where useStatus='0'"; DataTable leaveUserDt = new DataTable(); SqlSel.GetSqlSel(ref leaveUserDt, sqlCmd); List <string> userList = new List <string>(); for (int i = 0; i < leaveUserDt.Rows.Count; i++) { userList.Add(leaveUserDt.Rows[i]["id"].ToString()); } VerifyLegal.deleteUser(userList); Alert.ShowInTop("同步成功!"); }
//插入附件信息 private void InsertFiles(string formId) { string access_token = VerifyLegal.GetAccess_Token();//获取access_token string sqlCmd = ""; string fileList = hidden_field.Value; //解析明细Id String[] str = fileList.Split(';'); foreach (string it in str) { if (it == "") { break; } string fileName = GetMultimedia(access_token, it); sqlCmd = "insert into OA_Sys_files (FormId,fileName,formDataName) values ('" + formId + "','" + fileName + "','OA_Fines_Main')"; SqlSel.ExeSql(sqlCmd); } }
protected void btn_downLoad_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(fileName)) { MediaType mt = MediaType.file; //file型多媒体文件 string filePath = Server.MapPath("/image") + "\\" + fileName; //上传文件路径 string token = VerifyLegal.GetAccess_Token(); UpLoadInfo uploadFile = WxUpLoad(filePath, token, mt); //上传临时多媒体文件,返回mediaId if (uploadFile != null) { string mediaId = uploadFile.media_id; ReturnInfo.pushMessage_File(curUserId, System.Configuration.ConfigurationManager.AppSettings["CorpAppId"], mediaId);//向指定用户发送file型消息 btn_downLoad.Hidden = true; label_result.Hidden = false; label_result.Text = "文件下载完成!"; } else { btn_downLoad.Hidden = true; label_result.Hidden = false; label_result.Text = "文件下载失败!"; return; } } else { Alert.ShowInTop("文件丢失,请重试!"); return; } } catch (Exception ex) { Alert.ShowInTop(ex.Message); } }
// 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); } }