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