public string CreateCompany(Company company, string uid) { string sql = ""; sql += @"insert into Company(Name, CreditNo, RegisteredCapital, BusinessType, BusinessScope, QualificationLevel, SecurityCertificateNo, CorporateRepresentative, RepPhone, Contact, ContactPhone, ContactAddress, ConstructionContent, Note, Status, Type, Referre,AuditDate, AuditStatus, SubmitUserId, CreateDate, OutCompanyProjId, AddYear)" + "values(N'" + company.Name + "', N'" + company.CreditNo + "', " + company.RegisteredCapital + ", " + "N'" + company.BusinessType + "', N'" + company.BusinessScope + "', N'" + company.QualificationLevel + "', " + "'" + company.SecurityCertificateNo + "', N'" + company.CorporateRepresentive + "', '" + company.RepPhone + "', " + "N'" + company.Contact + "', '" + company.ContactPhone + "', N'" + company.ContactAddress + "', " + "N'" + company.ConstructionContent + "', N'" + company.Note + "', " + company.Status + ", " + company.Type + ", N'" + company.Referrer + "', getdate(), " + company.AuditStatus + ", " + uid + @", getdate()," + company.OutCompanyProjId + ", " + company.AddYear + ");"; sql += "select max(id) from Company;"; string i = DBHelper.ExecuteScalar(CommandType.Text, sql); sql = @"declare @did int select @did=ID from Department where ProjectDp=1 and ID in ( select PID from Department where ID in (select du.departmentid from DepartmentUser du where du.UserId=" + uid + @")) update Company set DepartmentID = @did where ID=" + i; DBHelper.ExecuteNonQuery(sql); if (company.AuditStatus == 1) { DataTable dt = null; if (company.Type == 1) { // 名录内企业 dt = CreateApproveProcess(i, uid, "5"); } else { // 名录外企业 dt = CreateApproveProcess(i, uid, "1"); } string puser = DBHelper.ExecuteScalar("select UserName from userinfo where id=" + uid); try { string reurl = ""; string aptype = ""; switch (company.Type == 0 ? "1" : "5") { case "1": aptype = "名录外企业审批"; reurl = "http://cr16gd.saibo.net.cn/MobileCompany?id=" + i + "&approved=1&userid="; break; case "5": aptype = "名录内企业审批"; reurl = "http://cr16gd.saibo.net.cn/MobileCompany?id=" + i + "&approved=1&userid="; break; } WXMessage.WXMessage message = new WXMessage.WXMessage(); for (int j = 0; j < dt.Rows.Count; j++) { uid = dt.Rows[j][1].ToString(); string guid = Guid.NewGuid().ToString().Replace("-", ""); reurl += uid + "&lcode=" + guid; message.SendTempletMessge(dt.Rows[j][0].ToString(), reurl, aptype, company.Name, puser); DBHelper.ExecuteNonQuery("insert into WXLoginSession(code, dtime, userid) values('" + guid + "',getdate()," + uid + ", 0)"); } } catch (Exception e) { Log ll = new Log(); ll.OperType = OperateType.SendWXInfo; ll.UserId = uid; ll.Description = "发送短信失败:" + e.ToString(); LogContext.WriteLog(ll); } Log l = new Log(); l.OperType = OperateType.Create; l.UserId = uid; l.Description = "创建公司" + company.Type == "1"?"名录内":"名录外" + " - " + company.Name; LogContext.WriteLog(l); } return(i); }
public void SubmitCompany(string cid, string type, string uid) { string sql = "update Company set AuditStatus=1, CreateDate=getdate() where Id=" + cid; DBHelper.ExecuteNonQuery(sql); DataTable dt = null; if (type == "1") { // 名录内企业 dt = CreateApproveProcess(cid, uid, "5"); } else { // 名录外企业 dt = CreateApproveProcess(cid, uid, "1"); } string cname = DBHelper.ExecuteScalar("select name from company where id = " + cid); string puser = DBHelper.ExecuteScalar(@"select UserName from UserInfo where id in( select UserId from vw_AppPLevel where ObjId = " + cid + " and AppProcId = " + type + " and Approved = 2 and DealDatetime in (select MAX(dealdatetime) from AppProcessing where ObjId = " + cid + " and AppProcId = " + type + " and Approved = 2))"); if (puser == "") { puser = DBHelper.ExecuteScalar("select UserName from userinfo where id=" + uid); } try { string reurl = ""; string aptype = ""; switch (type == "0" ? "1" : "5") { case "1": aptype = "名录外企业审批"; reurl = "http://cr16gd.saibo.net.cn/MobileCompany?id=" + cid + "&approved=1&userid="; break; case "5": aptype = "名录内企业审批"; reurl = "http://cr16gd.saibo.net.cn/MobileCompany?id=" + cid + "&approved=1&userid="; break; } WXMessage.WXMessage message = new WXMessage.WXMessage(); for (int j = 0; j < dt.Rows.Count; j++) { uid = dt.Rows[j][1].ToString(); string guid = Guid.NewGuid().ToString().Replace("-", ""); reurl += uid + "&lcode=" + guid; message.SendTempletMessge(dt.Rows[j][0].ToString(), reurl, aptype, cname, puser); DBHelper.ExecuteNonQuery("insert into WXLoginSession(code, dtime, userid, visited) values('" + guid + "',getdate()," + uid + ", 0)"); } } catch (Exception e) { Log ll = new Log(); ll.OperType = OperateType.SendWXInfo; ll.UserId = uid; ll.Description = "发送短信失败:" + e.ToString(); LogContext.WriteLog(ll); } Log l = new Log(); l.OperType = OperateType.Create; l.UserId = uid; l.Description = "创建公司" + type == "1" ? "名录内" : "名录外" + " - " + cid; LogContext.WriteLog(l); }
public void UpdateApproveProcess(string apid, string oid, string aStatus, string comment) { string uid = Session["UserId"].ToString(); SqlParameter[] parameters = new SqlParameter[5]; parameters[0] = new SqlParameter("@apid", apid); parameters[1] = new SqlParameter("@userid", uid); parameters[2] = new SqlParameter("@oid", oid); parameters[3] = new SqlParameter("@status", aStatus); parameters[4] = new SqlParameter("@comment", comment); DataTable dt = DBHelper.ExecuteSP("UpdateApproveProcess", parameters).Tables[0]; string pname = ""; if (apid == "1" || apid == "5") { pname = DBHelper.ExecuteScalar("select name from Company where ID=" + oid); } else { pname = DBHelper.ExecuteScalar("select name from Project where ID=" + oid); } try { WXMessage.WXMessage message = new WXMessage.WXMessage(); if (aStatus == "3") { message.sendRefuseNotification(dt.Rows[0][0].ToString(), apid, pname); } else { string reurl = ""; string aptype = ""; switch (apid) { case "1": aptype = "名录外企业审批"; reurl = "http://cr16gd.saibo.net.cn/MobileCompany?id=" + oid + "&approved=1&userid="; break; case "5": aptype = "名录内企业审批"; reurl = "http://cr16gd.saibo.net.cn/MobileCompany?id=" + oid + "&approved=1&userid="; break; case "2": aptype = "招标文件审批"; reurl = "http://cr16gd.saibo.net.cn/MobileBidingFile?pid=" + oid + "&approved=1&userid="; break; case "3": aptype = "招标审批"; reurl = "http://cr16gd.saibo.net.cn/MobileBid?pid=" + oid + "&approved=1&userid="; break; case "4": aptype = "定标文件审批"; reurl = "http://cr16gd.saibo.net.cn/MobileMakeBidFile?pid=" + oid + "&approved=1&userid="; break; } string puser = DBHelper.ExecuteScalar("select UserName from userinfo where id=" + uid); for (int j = 0; j < dt.Rows.Count; j++) { uid = dt.Rows[j][1].ToString(); string guid = Guid.NewGuid().ToString().Replace("-", ""); string url = reurl + uid + "&lcode=" + guid; message.SendTempletMessge(dt.Rows[j][0].ToString(), url, aptype, pname, puser); DBHelper.ExecuteNonQuery("insert into WXLoginSession(code, dtime, userid,visited) values('" + guid + "',getdate()," + uid + ", 0)"); } } } catch (Exception e) { Log ll = new Log(); ll.OperType = OperateType.SendWXInfo; ll.UserId = uid; ll.Description = "发送短信失败:" + e.ToString(); LogContext.WriteLog(ll); } ApproveProcessLog(apid, oid, aStatus, uid); }