public static Model.CompanyInfo GetModel()
{
string strSql = "select top 1 * from CompanyInfo order by ID desc";
Model.CompanyInfo model = new Model.CompanyInfo();
DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString);
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
model.Company = Convert.ToString(ds.Tables[0].Rows[0]["Company"]);
model.Address = Convert.ToString(ds.Tables[0].Rows[0]["Address"]);
model.BelongArea = Convert.ToString(ds.Tables[0].Rows[0]["BelongArea"]);
model.BusinessLicense = Convert.ToString(ds.Tables[0].Rows[0]["BusinessLicense"]);
model.CertificationTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["CertificationTime"]);
model.CompanyTel = Convert.ToString(ds.Tables[0].Rows[0]["CompanyTel"]);
model.Contact = Convert.ToString(ds.Tables[0].Rows[0]["Contact"]);
model.ContactIDCardFile = Convert.ToString(ds.Tables[0].Rows[0]["ContactIDCardFile"]);
model.ContactIDCardNumer = Convert.ToString(ds.Tables[0].Rows[0]["ContactIDCardNumer"]);
model.Industry = Convert.ToString(ds.Tables[0].Rows[0]["Industry"]);
model.LegalIDCardFile = Convert.ToString(ds.Tables[0].Rows[0]["LegalIDCardFile"]);
model.LegalIDCardNumber = Convert.ToString(ds.Tables[0].Rows[0]["LegalIDCardNumber"]);
model.LegalPerson = Convert.ToString(ds.Tables[0].Rows[0]["LegalPerson"]);
model.OrganizationCode = Convert.ToString(ds.Tables[0].Rows[0]["OrganizationCode"]);
model.PowerOfAttorney = Convert.ToString(ds.Tables[0].Rows[0]["PowerOfAttorney"]);
model.SurveyingFile = Convert.ToString(ds.Tables[0].Rows[0]["SurveyingFile"]);
model.SurveyingNumber = Convert.ToString(ds.Tables[0].Rows[0]["SurveyingNumber"]);
model.SurveyingQualification = Convert.ToString(ds.Tables[0].Rows[0]["SurveyingQualification"]);
return(model);
}
else
{
return(null);
}
}
public Fangor.Model.CompanyInfo GetBind(SqlDataReader Reader)
{
Fangor.Model.CompanyInfo result = new Model.CompanyInfo();
result.Company_Id1 = Convert.ToInt32(Reader["Company_Id"]);
Fangor.Model.Images image = new Model.Images();
image.Image_Id1 = Convert.ToInt32(Reader["Company_AddPicture"]);
result.Company_AddPicture1 = image;
result.Company_Address1 = Reader["Company_Address"].ToString();
result.Company_Content1 = Reader["Company_Content"].ToString();
result.Company_Email1 = Reader["Company_Email"].ToString();
image.Image_Id1 = Convert.ToInt32(Reader["Company_Logo"]);
result.Company_Logo1 = image;
result.Company_QQ1 = Reader["Company_QQ"].ToString();
result.Company_Tel1 = Reader["Company_Tel"].ToString();
result.Company_Time1 = Convert.ToDateTime(Reader["Company_Time"]);
result.Company_Type1 = Reader["Company_Type"].ToString();
result.Company_Writer1 = Reader["Company_Writer"].ToString();
return result;
}
/// <summary>
/// 增加一个单位信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Add(Model.CompanyInfo model)
{
string strSql = "insert into CompanyInfo(Company,Address,CompanyTel,Industry,OrganizationCode,BusinessLicense,SurveyingQualification,SurveyingNumber,SurveyingFile,LegalPerson,LegalIDCardNumber,LegalIDCardFile,PowerOfAttorney,Contact,ContactIDCardNumer,ContactIDCardFile,CertificationTime,BelongArea,ServiceAgreementFile,Balance) values(@Company,@Address,@CompanyTel,@Industry,@OrganizationCode,@BusinessLicense,@SurveyingQualification,@SurveyingNumber,@SurveyingFile,@LegalPerson,@LegalIDCardNumber,@LegalIDCardFile,@PowerOfAttorney,@Contact,@ContactIDCardNumer,@ContactIDCardFile,@CertificationTime,@BelongArea,@ServiceAgreementFile,@Balance)";
SqlParameter Company = new SqlParameter("Company", SqlDbType.NVarChar); Company.Value = model.Company;
SqlParameter Address = new SqlParameter("Address", SqlDbType.NVarChar); Address.Value = model.Address;
SqlParameter CompanyTel = new SqlParameter("CompanyTel", SqlDbType.NVarChar); CompanyTel.Value = model.CompanyTel;
SqlParameter Industry = new SqlParameter("Industry", SqlDbType.NVarChar); Industry.Value = model.Industry;
SqlParameter OrganizationCode = new SqlParameter("OrganizationCode", SqlDbType.NVarChar); OrganizationCode.Value = model.OrganizationCode;
SqlParameter BusinessLicense = new SqlParameter("BusinessLicense", SqlDbType.NVarChar); BusinessLicense.Value = model.BusinessLicense;
SqlParameter SurveyingQualification = new SqlParameter("SurveyingQualification", SqlDbType.NVarChar); SurveyingQualification.Value = model.SurveyingQualification;
SqlParameter SurveyingNumber = new SqlParameter("SurveyingNumber", SqlDbType.NVarChar); SurveyingNumber.Value = model.SurveyingNumber;
SqlParameter SurveyingFile = new SqlParameter("SurveyingFile", SqlDbType.NVarChar); SurveyingFile.Value = model.SurveyingFile;
SqlParameter LegalPerson = new SqlParameter("LegalPerson", SqlDbType.NVarChar); LegalPerson.Value = model.LegalPerson;
SqlParameter LegalIDCardNumber = new SqlParameter("LegalIDCardNumber", SqlDbType.NVarChar); LegalIDCardNumber.Value = model.LegalIDCardNumber;
SqlParameter LegalIDCardFile = new SqlParameter("LegalIDCardFile", SqlDbType.NVarChar); LegalIDCardFile.Value = model.LegalIDCardFile;
SqlParameter PowerOfAttorney = new SqlParameter("PowerOfAttorney", SqlDbType.NVarChar); PowerOfAttorney.Value = model.PowerOfAttorney;
SqlParameter Contact = new SqlParameter("Contact", SqlDbType.NVarChar); Contact.Value = model.Contact;
SqlParameter ContactIDCardNumer = new SqlParameter("ContactIDCardNumer", SqlDbType.NVarChar); ContactIDCardNumer.Value = model.ContactIDCardNumer;
SqlParameter ContactIDCardFile = new SqlParameter("ContactIDCardFile", SqlDbType.NVarChar); ContactIDCardFile.Value = model.ContactIDCardFile;
SqlParameter CertificationTime = new SqlParameter("CertificationTime", SqlDbType.DateTime); CertificationTime.Value = model.CertificationTime;
SqlParameter BelongArea = new SqlParameter("BelongArea", SqlDbType.NVarChar); BelongArea.Value = model.BelongArea;
SqlParameter ServiceAgreementFile = new SqlParameter("ServiceAgreementFile", SqlDbType.NVarChar); ServiceAgreementFile.Value = model.ServiceAgreementFile;
SqlParameter Balance = new SqlParameter("Balance", SqlDbType.NVarChar); Balance.Value = model.Balance;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { Company, Address, CompanyTel, Industry, OrganizationCode, BusinessLicense, SurveyingQualification, SurveyingNumber, SurveyingFile, LegalPerson, LegalIDCardNumber, LegalIDCardFile, PowerOfAttorney, Contact, ContactIDCardNumer, ContactIDCardFile, CertificationTime, BelongArea, ServiceAgreementFile, Balance }, connectionString) == 1 ? true : false);
}
/// <summary>
/// 更新一条数据,根据ID
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(Model.CompanyInfo model)
{
string strSql = "update CompanyInfo set Company=@Company, Address=@Address, CompanyTel=@CompanyTel, Industry=@Industry, OrganizationCode=@OrganizationCode, BusinessLicense=@BusinessLicense, SurveyingQualification=@SurveyingQualification, SurveyingNumber=@SurveyingNumber, SurveyingFile=@SurveyingFile, LegalPerson=@LegalPerson, LegalIDCardNumber=@LegalIDCardNumber, LegalIDCardFile=@LegalIDCardFile,ServiceAgreementFile=@ServiceAgreementFile, PowerOfAttorney=@PowerOfAttorney, Contact=@Contact, ContactIDCardNumer=@ContactIDCardNumer, ContactIDCardFile=@ContactIDCardFile, CertificationTime=@CertificationTime, BelongArea=@BelongArea where ID = " + model.ID.ToString();
SqlParameter Company = new SqlParameter("Company", SqlDbType.NVarChar); Company.Value = model.Company;
SqlParameter Address = new SqlParameter("Address", SqlDbType.NVarChar); Address.Value = model.Address;
SqlParameter CompanyTel = new SqlParameter("CompanyTel", SqlDbType.NVarChar); CompanyTel.Value = model.CompanyTel;
SqlParameter Industry = new SqlParameter("Industry", SqlDbType.NVarChar); Industry.Value = model.Industry;
SqlParameter OrganizationCode = new SqlParameter("OrganizationCode", SqlDbType.NVarChar); OrganizationCode.Value = model.OrganizationCode;
SqlParameter BusinessLicense = new SqlParameter("BusinessLicense", SqlDbType.NVarChar); BusinessLicense.Value = model.BusinessLicense;
SqlParameter SurveyingQualification = new SqlParameter("SurveyingQualification", SqlDbType.NVarChar); SurveyingQualification.Value = model.SurveyingQualification;
SqlParameter SurveyingNumber = new SqlParameter("SurveyingNumber", SqlDbType.NVarChar); SurveyingNumber.Value = model.SurveyingNumber;
SqlParameter SurveyingFile = new SqlParameter("SurveyingFile", SqlDbType.NVarChar); SurveyingFile.Value = model.SurveyingFile;
SqlParameter LegalPerson = new SqlParameter("LegalPerson", SqlDbType.NVarChar); LegalPerson.Value = model.LegalPerson;
SqlParameter LegalIDCardNumber = new SqlParameter("LegalIDCardNumber", SqlDbType.NVarChar); LegalIDCardNumber.Value = model.LegalIDCardNumber;
SqlParameter LegalIDCardFile = new SqlParameter("LegalIDCardFile", SqlDbType.NVarChar); LegalIDCardFile.Value = model.LegalIDCardFile;
SqlParameter ServiceAgreementFile = new SqlParameter("ServiceAgreementFile", SqlDbType.NVarChar); ServiceAgreementFile.Value = model.ServiceAgreementFile;
SqlParameter PowerOfAttorney = new SqlParameter("PowerOfAttorney", SqlDbType.NVarChar); PowerOfAttorney.Value = model.PowerOfAttorney;
SqlParameter Contact = new SqlParameter("Contact", SqlDbType.NVarChar); Contact.Value = model.Contact;
SqlParameter ContactIDCardNumer = new SqlParameter("ContactIDCardNumer", SqlDbType.NVarChar); ContactIDCardNumer.Value = model.ContactIDCardNumer;
SqlParameter ContactIDCardFile = new SqlParameter("ContactIDCardFile", SqlDbType.NVarChar); ContactIDCardFile.Value = model.ContactIDCardFile;
SqlParameter CertificationTime = new SqlParameter("CertificationTime", SqlDbType.DateTime); CertificationTime.Value = model.CertificationTime;
SqlParameter BelongArea = new SqlParameter("BelongArea", SqlDbType.NVarChar); BelongArea.Value = model.BelongArea;
// SqlParameter Balance = new SqlParameter("Balance", SqlDbType.NVarChar); Balance.Value = model.Balance;
//WebLogger.WriteErroLog(strSql);
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { Company, Address, CompanyTel, Industry, OrganizationCode, BusinessLicense, SurveyingQualification, SurveyingNumber, SurveyingFile, LegalPerson, LegalIDCardNumber, LegalIDCardFile, ServiceAgreementFile, PowerOfAttorney, Contact, ContactIDCardNumer, ContactIDCardFile, CertificationTime, BelongArea }, connectionString) == 1 ? true : false);
}
private void Add()
{
var cont = Request["net"].ToString();
Content content = CORSV2.cs.JSONHelper.JSONToObject <Content>(cont);
Model.OrderList orderList = new Model.OrderList();
int companyCertifiationIndex = Convert.ToInt32(DAL.RegisterUser.GetModel(Session["UserName"].ToString()).CertifiationIndex);
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(companyCertifiationIndex);
orderList.UserName = Session["UserName"].ToString();
orderList.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff");
Session["OrderNumber"] = orderList.OrderNumber;
orderList.company = companyInfo.Company;
orderList.DealTime = DateTime.Now;
orderList.OrderContent = "续费账号";
orderList.OrderStatus = 0;
orderList.OrdeType = 1;
orderList.RoamID = "";
if (content.RenewalDuration == "一个月")
{
orderList.ServiceDuration = "1";
}
if (content.RenewalDuration == "半年")
{
orderList.ServiceDuration = "6";
}
if (content.RenewalDuration == "一年")
{
orderList.ServiceDuration = "12";
}
if (content.RenewalDuration == "两年")
{
orderList.ServiceDuration = "24";
}
string[] sys = content.SatelliteSystem.Split(' ');
int num = 0;
foreach (string s in sys)
{
if (s != "")
{
orderList.OrderContent += (s + ';');
num++;
}
}
orderList.Price = Convert.ToString(1000 * num);
if (DAL.OrderList.Add(orderList))
{
Response.Clear();
Response.Write(orderList.OrderNumber);
Response.End();
return;
}
}
private void toolSave_Click(object sender, EventArgs e)
{
if (txtCompanyID.Text == "" || txtCompanyName.Text == "" || txtCompanyDirector.Text == "" || txtCompanyPhone.Text == "" || txtCompanyAddress.Text == "")
{
MessageBox.Show("请将信息添加完整！");
return;
}
Model.CompanyInfo model = new Model.CompanyInfo();//实例化model层
model.CompanyID = txtCompanyID.Text.Trim();
model.CompanyName = txtCompanyName.Text.Trim();
model.CompanyDirector = txtCompanyDirector.Text.Trim();
model.CompanyPhone = txtCompanyPhone.Text.Trim();
model.CompanyAddress = txtCompanyAddress.Text.Trim();
model.CompanyRemarks = txtCompanyRemarks.Text.Trim();
model.ReDateTime = DateTime.Parse(dateTimePicker1.Text);
BLL.CompanyInfo bll = new BLL.CompanyInfo();//实例化BLL层
switch (flag)
{
case 0:
{
} break;
case 1:
{
if (bll.Add(model)) //将员工信息添加到数据库中，根据返回值判断是否添加成功
{
DataBind(); //窗体登录时绑定数据到DataGridView
ControlStatus();
ClearControls();
}
} break;
case 2:
{
if (bll.Update(model)) //根据返回布尔值判断是否修改数据成功
{
DataBind(); //窗体登录时绑定数据到DataGridView
ControlStatus();
ClearControls();
}
} break;
case 3:
{
if (bll.Delete(model)) //根据返回布尔值判断是否删除数据成功
{
DataBind(); //窗体登录时绑定数据到DataGridView
ControlStatus();
ClearControls();
}
} break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
userName = Session["UserName"].ToString();
int companyCertifiationIndex = Convert.ToInt32(DAL.RegisterUser.GetModel(Session["UserName"].ToString()).CertifiationIndex);
//根据注册用户的认证id索引加载页面信息
Model.CompanyInfo companyinfo = DAL.CompanyInfo.GetModel(companyCertifiationIndex);
company.InnerText = companyinfo.Company;
Balance.InnerText = companyinfo.Balance.ToString();
if (Request["action"] == "order")
{
Model.OrderList orderlist = new Model.OrderList();
orderlist.UserName = Session["UserName"].ToString();
orderlist.company = company.InnerText;
orderlist.Price = Price.Value;
orderlist.OrderStatus = 0;
orderlist.OrderContent = orderlist.company + "充值" + orderlist.Price + "元";
orderlist.OrdeType = 2;
orderlist.ServerType = "";
orderlist.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff");
//将订单号存储在session里面用于整个订单的操作流程。
Session["OrderNumber"] = orderlist.OrderNumber;
orderlist.SubmitTime = DateTime.Now;
if (DAL.OrderList.Add(orderlist))
{
Response.Write(orderlist.OrderNumber);
//Model.SysLog syslog = new Model.SysLog();
//syslog.LogTime = DateTime.Now;
//syslog.LogType = 5;
//syslog.Remark = "申请的服务订单待处理";
//syslog.UserName = orderlist.UserName;
//DAL.SysLog.Add(syslog);
Response.End();
}
else
{
Response.Write("200");
Response.End();
}
}
}
private int Verifycompanyform()
{
Model.CompanyInfo companyinfo = new Model.CompanyInfo();
companyinfo.Address = Request.Form["address"];
companyinfo.BelongArea = Request.Form["city"];
companyinfo.BusinessLicense = business_licence_path;
companyinfo.Company = Request.Form["company_name"];
companyinfo.CompanyTel = Request.Form["corporate_tel"];
companyinfo.Contact = Request.Form["contact_name"];
companyinfo.ContactIDCardFile = operator_id_card_front;
companyinfo.ContactIDCardNumer = "";
companyinfo.Industry = Request.Form["company_type_id"];
companyinfo.LegalIDCardFile = corporate_id_card_front;
companyinfo.LegalIDCardNumber = "";
companyinfo.LegalPerson = Request.Form["corporate"];
companyinfo.OrganizationCode = Request.Form["business_licence"];
companyinfo.PowerOfAttorney = client_authorization_path;
companyinfo.SurveyingFile = map_qualification_path;
companyinfo.SurveyingNumber = Request.Form["map_qualification_sn"];
companyinfo.SurveyingQualification = Request.Form["map_level"];
DAL.CompanyInfo.Add(companyinfo);
Model.CompanyInfo temp_companyinfo = DAL.CompanyInfo.GetModel();
Model.RegisterUser registeruser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
registeruser.CertifiationIndex = temp_companyinfo.ID.ToString();
registeruser.CertifiationStatus = 1;
DAL.RegisterUser.Update(registeruser);
string json = "{\"code\":200}";
Response.Write(json);
Response.End();
//select top 1 * from tra.dbo.订单 order by 下单时间 desc --时间倒序排列取第一条
// companyinfo.
//string map_level = Request.Form["map_level"];
//string corporate = Request.Form["corporate"];
//string province = Request.Form["province"];
//string city = Request.Form["city"];
//string town = Request.Form["town"];
//string address = Request.Form["address"];
//string post_code = Request.Form["post_code"];
//string contact_phone = Request.Form["contact_phone"];
//string contact_email = Request.Form["contact_email"];
//string contact_qq = Request.Form["contact_qq"];
//string contact_wechat = Request.Form["contact_wechat"];
return(1);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.CompanyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CompanyInfo set ");
strSql.Append("CompanyName=@CompanyName,");
strSql.Append("CompanyDirector=@CompanyDirector,");
strSql.Append("CompanyPhone=@CompanyPhone,");
strSql.Append("CompanyAddress=@CompanyAddress,");
strSql.Append("CompanyRemarks=@CompanyRemarks,");
strSql.Append("ReDateTime=@ReDateTime,");
strSql.Append("Flag=@Flag");
strSql.Append(" where CompanyID=@CompanyID ");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyID", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyDirector", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyPhone", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyAddress", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyRemarks", SqlDbType.NVarChar, 200),
new SqlParameter("@ReDateTime", SqlDbType.DateTime),
new SqlParameter("@Flag", SqlDbType.Int)
};
parameters[0].Value = model.CompanyID;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.CompanyDirector;
parameters[3].Value = model.CompanyPhone;
parameters[4].Value = model.CompanyAddress;
parameters[5].Value = model.CompanyRemarks;
parameters[6].Value = model.ReDateTime;
parameters[7].Value = model.Flag;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Session["UserName"] = "******";
//Session["UserType"] = "1";
if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 5)
{
Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>");
Response.End();
}
//加载前端数据
userName = Session["UserName"].ToString();
companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(DAL.RegisterUser.GetModel(userName).CertifiationIndex));
oldCompany = companyInfo.Company;
//
if (Request["action"] != null && Request["action"].ToString() == "changeCompanyInfo")
{
registerUser = DAL.RegisterUser.GetModel(userName);
companyInfo.Company = Request["new_company"].ToString();
DAL.CompanyInfo.Update(companyInfo);
//string SMS = "http://39.108.107.73:8090/sysmonitor/services/monitor/sendmessage.json?key=is8ji3&phone=@phone&message=@message";
//string message = "尊敬的用户您好：平台绑定单位已经成功修改为：" + companyInfo.Company + "，请及时登录系统查看!";
//SMS = SMS.Replace("@message", message);
//SMS = SMS.Replace("@phone", registerUser.Phone);
//try
//{
// cs.HttpHelper.SendSMS(SMS);
//}
//catch (Exception ex)
//{
// cs.WebLogger.WriteErroLog("修改单位短信发送错误" + ex.ToString()); //输出到文件中
//}
Response.Write("{\"code\":200}");
Response.End();
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.CompanyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CompanyInfo(");
strSql.Append("CompanyID,CompanyName,CompanyDirector,CompanyPhone,CompanyAddress,CompanyRemarks,ReDateTime,Flag)");
strSql.Append(" values (");
strSql.Append("@CompanyID,@CompanyName,@CompanyDirector,@CompanyPhone,@CompanyAddress,@CompanyRemarks,@ReDateTime,@Flag)");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyID", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyDirector", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyPhone", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyAddress", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyRemarks", SqlDbType.NVarChar, 200),
new SqlParameter("@ReDateTime", SqlDbType.DateTime),
new SqlParameter("@Flag", SqlDbType.Int)
};
parameters[0].Value = model.CompanyID;
parameters[1].Value = model.CompanyName;
parameters[2].Value = model.CompanyDirector;
parameters[3].Value = model.CompanyPhone;
parameters[4].Value = model.CompanyAddress;
parameters[5].Value = model.CompanyRemarks;
parameters[6].Value = model.ReDateTime;
parameters[7].Value = model.Flag;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(Model.CompanyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from CompanyInfo ");
strSql.Append(" where CompanyID=@CompanyID ");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.CompanyID;
int rows = DBHelper.ExecuteSql(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["UserName"] == null || Session["UserType"] == null)
{
Response.Write("<script>alert(\"请登录\");parent.window.location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>");
Response.End();
}
DataSet dsRoamArea = DAL.RoamArea.GetList("1=1");
foreach (DataRow dr in dsRoamArea.Tables[0].Rows)
{
Select2.Items.Add(dr["AreaName"].ToString());
Select4.Items.Add(dr["AreaName"].ToString());
}
}
if (Request["action"] == "check")
{
string username = Request["data"].ToString();
DAL.RegisterUser du = new DAL.RegisterUser();
if (DAL.RTKUserInfo.GetModel(username) == null && DAL.RegisterUser.GetModel(username) == null && DAL.DeUserInfo.GetModel(username) == null)
{
Response.Clear();
Response.Write("1");
Response.End();
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
//Session["UserName"] = "******";
if (Request["action"] == "order")
{
Model.OrderList orderlist = new Model.OrderList();
orderlist.UserName = Session["UserName"].ToString();
Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName);
orderlist.WorkArea = registerUser.BelongArea;
orderlist.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff");
//将订单号存储在session里面用于整个订单的操作流程。
Session["OrderNumber"] = orderlist.OrderNumber;
orderlist.SubmitTime = DateTime.Now;
orderlist.AccountNum = Convert.ToInt32(Request["applynum"]);
orderlist.ServiceDuration = Request["time"].ToString();
orderlist.ServerType = Request["servertype"].ToString();
Model.RegisterUser RegisterUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(RegisterUser.CertifiationIndex));
orderlist.company = companyInfo.Company;
orderlist.OrdeType = 0;
orderlist.Price = Request["price"].ToString();
if (Select1.Value == "是")
{
orderlist.RoamID = this.Select2.Value;//保存的漫游ID
}
else
{
orderlist.RoamID = "";
}
if (Checkbox1.Checked == true)
{
orderlist.ElevationEnable = 1;
}
else
{
orderlist.ElevationEnable = 0;
}
string[] otherserver = Request["otherserver"].ToString().Split(',');
if (Array.IndexOf(otherserver, "CoorTransEnable") != -1)
{
orderlist.CoorSystemEnable = 1;
}
if (Array.IndexOf(otherserver, "HeightTransEnable") != -1)
{
orderlist.HeightTransEnable = 1;
}
if (Array.IndexOf(otherserver, "SHPTransEnable") != -1)
{
orderlist.SHPTransEnable = 1;
}
if (Array.IndexOf(otherserver, "ObsQualityEnable") != -1)
{
orderlist.ObsQualityEnable = 1;
}
if (DAL.OrderList.Add(orderlist))
{
Response.Write(orderlist.OrderNumber);
//Model.SysLog syslog = new Model.SysLog();
//syslog.LogTime = DateTime.Now;
//syslog.LogType = 5;
//syslog.Remark = "申请的服务订单待处理";
//syslog.UserName = orderlist.UserName;
//DAL.SysLog.Add(syslog);
Response.End();
}
else
{
Response.Write("200");
Response.End();
}
}
if (Request["action"] == "order1")
{
Model.OrderList orderlist = new Model.OrderList();
orderlist.UserName = Session["UserName"].ToString();
Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName);
orderlist.WorkArea = registerUser.BelongArea;
orderlist.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff");
//将订单号存储在session里面用于整个订单的操作流程。
Session["OrderNumber"] = orderlist.OrderNumber;
orderlist.SubmitTime = DateTime.Now;
orderlist.AccountNum = Convert.ToInt32(Request["applynum1"]);
orderlist.ServiceDuration = Request["time1"].ToString();
orderlist.ServerType = Request["servertype1"].ToString();
Model.RegisterUser RegisterUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(RegisterUser.CertifiationIndex));
orderlist.company = companyInfo.Company;
orderlist.OrdeType = 3;
orderlist.Price = Request["price1"].ToString();
if (Select3.Value == "是")
{
orderlist.RoamID = this.Select4.Value;//保存的漫游ID
}
else
{
orderlist.RoamID = "";
}
if (Checkbox2.Checked == true)
{
orderlist.ElevationEnable = 1;
}
else
{
orderlist.ElevationEnable = 0;
}
if (Checkbox3.Checked == true)
{
orderlist.ElevationEnable = 1;
}
else
{
orderlist.ElevationEnable = 0;
}
string[] otherserver = Request["otherserver1"].ToString().Split(',');
if (Array.IndexOf(otherserver, "CoorTransEnable") != -1)
{
orderlist.CoorSystemEnable = 1;
}
if (Array.IndexOf(otherserver, "HeightTransEnable") != -1)
{
orderlist.HeightTransEnable = 1;
}
if (Array.IndexOf(otherserver, "SHPTransEnable") != -1)
{
orderlist.SHPTransEnable = 1;
}
if (Array.IndexOf(otherserver, "ObsQualityEnable") != -1)
{
orderlist.ObsQualityEnable = 1;
}
string[] sys = Request["username1"].ToString().Split(',');
if (DAL.OrderList.Add(orderlist))
{
foreach (string s in sys)
{
if (s != null || s != "")
{
Model.DeUserInfo deUserInfo = new Model.DeUserInfo();
deUserInfo.UserName = s;
deUserInfo.UserPwd = AES_Key.AESEncrypt(s, s.PadLeft(16, '0'));
deUserInfo.OrderNumber = orderlist.OrderNumber;
DAL.DeUserInfo.Add(deUserInfo);
}
else
{
Response.Write("<script >alert('用户名不能为空！');</script>");
}
}
Response.Write(orderlist.OrderNumber);
//Model.SysLog syslog = new Model.SysLog();
//syslog.LogTime = DateTime.Now;
//syslog.LogType = 5;
//syslog.Remark = "申请的服务订单待处理";
//syslog.UserName = orderlist.UserName;
//DAL.SysLog.Add(syslog);
Response.End();
}
else
{
Response.Write("200");
Response.End();
}
}
}
private bool GetEquips()
{
string search = "";
int offset = 0;
int limit = 10;
if (Request["offset"] != null)
{
offset = Convert.ToInt32(Request["offset"]);
limit = Convert.ToInt32(Request["limit"]);
}
if (Request["search"] != null)
{
search = Request["search"].ToString();
}
Model.RegisterUser RegisterUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(RegisterUser.CertifiationIndex));
string Company = companyInfo.Company;
int totalCount = DAL.PaymentRecord.GetRecordCount(Company);
if (offset + limit > totalCount)
{
limit = totalCount - offset;
}
string strwhere = "1=1";
if ((Request["dataType1"] != null))
{
if (Request["dataType1"].ToString().Contains("类型"))
{
}
else
{
strwhere += (" and Type like '%" + Request["dataType1"].ToString() + "%'");
}
}
DataSet ds = DAL.PaymentRecord.GetBriefList(offset, limit, search, strwhere, Company, Session["UserName"].ToString());
ds.Tables[0].Columns.Add("deRechargeTime", typeof(string));
ds.Tables[0].Columns.Add("deType", typeof(string));
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["Type"].ToString().Trim() == "0" || dr["Type"].ToString().Trim() == "3")
{
dr["deType"] = "申请";
}
if (dr["Type"].ToString().Trim() == "1")
{
dr["deType"] = "续费";
}
if (dr["Type"].ToString().Trim() == "2")
{
dr["deType"] = "充值";
}
dr["deRechargeTime"] = dr["RechargeTime"].ToString();
}
string jsonComs = CORSV2.cs.JSONHelper.DataTableToJSON(ds.Tables[0]);
result = "{\"total\":" + totalCount.ToString() + ",\"rows\":" + jsonComs + "}";
Response.ContentType = "application/Json";
Response.Write(result);
Response.End();
if (ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Session["UserName"] = "******";
//Session["UserType"] = "1";
if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 5)
{
Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>");
Response.End();
}
int registerId = Convert.ToInt32(Request["id"]);
int companyCertifiationIndex = Convert.ToInt32(DAL.RegisterUser.GetModel(registerId).CertifiationIndex);
int companyCertifiationStatus = Convert.ToInt32(DAL.RegisterUser.GetModel(registerId).CertifiationStatus);
//根据注册用户的认证id索引加载页面信息
Model.CompanyInfo companyinfo = DAL.CompanyInfo.GetModel(companyCertifiationIndex);
if (companyinfo == null)
{
Response.Write("<script>alert('未绑定单位名')</script>");
}
else
{
company_name.Value = companyinfo.Company;
map_qualification_path.Src = companyinfo.SurveyingFile;
switch (companyinfo.Industry)
{
case "1":
company_type_id.Value = "市内测绘资质单位";
break;
case "2":
company_type_id.Value = "政府机构";
break;
case "3":
company_type_id.Value = "仪器公司";
break;
case "4":
company_type_id.Value = "高校/科研院所";
break;
case "5":
company_type_id.Value = "其他非测绘资质执证单位";
break;
case "6":
company_type_id.Value = "市外测绘资质单位";
break;
case "7":
company_type_id.Value = "市外非测绘资质单位";
break;
case "8":
company_type_id.Value = "市内非测绘资质单位";
break;
}
map_level.Value = companyinfo.SurveyingQualification;
map_qualification_sn.Value = companyinfo.SurveyingNumber;
corporate.Value = companyinfo.LegalPerson;
corporate_tel.Value = companyinfo.CompanyTel;
business_licence.Value = companyinfo.OrganizationCode;
address.Value = companyinfo.Address;
business_licence_path.Src = companyinfo.BusinessLicense;
//corporate_id_card.Src = companyinfo.LegalIDCardFile;
//operator_id_card_front.Src = companyinfo.ContactIDCardFile;
//secrecy_agreement_path.Src = companyinfo.ServiceAgreementFile;
//client_authorization_path.Src = companyinfo.PowerOfAttorney;
contact_name.Value = companyinfo.Contact;
//contact_phone.Value = companyinfo.CompanyTel;
contactPhone.Value = companyinfo.CompanyTel;
//string res = cs.JSONHelper.ObjectToJSON(companyinfo);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["name"] != null)
{
Session["RegisterUserName"] = Request["name"].ToString();
}
DataSet ds = DAL.CoorSysPars.GetList("YSZBXM ='WGS84'");
foreach (DataRow dr in ds.Tables[0].Rows)
{
ssdfzbx.Items.Add(dr["MDZBXM"].ToString());
ssdfzbx1.Items.Add(dr["MDZBXM"].ToString());
}
DataSet ds1 = DAL.SourceTable.GetList("1=1");
foreach (DataRow dr in ds1.Tables[0].Rows)
{
ssylbpz.Items.Add(dr["Source"].ToString());
ssylbpz1.Items.Add(dr["Source"].ToString());
}
int companyCertifiationIndex = Convert.ToInt32(DAL.RegisterUser.GetModel(Session["RegisterUserName"].ToString()).CertifiationIndex);
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(companyCertifiationIndex);
Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(Session["RegisterUserName"].ToString());
Company.Value = companyInfo.Company;
Contacts.Value = companyInfo.Contact;
phone.Value = registerUser.Phone;
email.Value = registerUser.Email;
Company1.Value = companyInfo.Company;
Contacts1.Value = companyInfo.Contact;
phone1.Value = registerUser.Phone;
email1.Value = registerUser.Email;
if (Request["action"] != null)
{
if (Request["action"].ToString() == "check")
{
string username = Request["data"].ToString();
DAL.RegisterUser du = new DAL.RegisterUser();
if (DAL.RTKUserInfo.GetModel(username) == null && DAL.RegisterUser.GetModel(username) == null)
{
Response.Clear();
Response.Write("1");
Response.End();
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
if (Request["action"].ToString() == "AddUser")
{
bool dele = true;
string UserName = Request.Form["username"].ToString();
try
{
// 个人信息部分
DAL.RegisterUser du1 = new DAL.RegisterUser();
if (DAL.RTKUserInfo.GetModel(UserName) == null && DAL.RegisterUser.GetModel(UserName) == null)
{
}
else
{
dele = false;
Response.Clear();
Response.Write("-1");
Response.End();
return;
}
string PassWord = Request.Form["password"].ToString();
string WorkType = Request.Form["WorkType"].ToString();
string Contacts = Request.Form["Contacts"].ToString();
string Phone = Request.Form["phone"].ToString();
string Email = Request.Form["email"].ToString();
string Company = Request.Form["Company"].ToString();
int Enable = int.Parse(Request.Form["status"].ToString());
Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo();
rtkUserInfo.RegisterUserName = Session["RegisterUserName"].ToString();
rtkUserInfo.UserName = UserName;
rtkUserInfo.Company = Company;
rtkUserInfo.PassWord = AES_Key.AESEncrypt(PassWord, UserName.PadLeft(16, '0'));
rtkUserInfo.UserType = 0;
//rtkUserInfo.OrderNumber = ;
// rtkUserInfo.BelongArea = registerUser.BelongArea;
rtkUserInfo.Contact = Contacts;
rtkUserInfo.ContactPhone = Phone;
rtkUserInfo.ContactEmail = Email;
rtkUserInfo.RegTime = DateTime.Now;
rtkUserInfo.CORSCardNum = "";
if (DAL.RTKUserInfo.Add(rtkUserInfo))
{
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
return;
}
// 权限信息部分
Model.RTKUserPurview mrtkp = new Model.RTKUserPurview();
int PostEnable = int.Parse(Request.Form["ssfwky"].ToString());
string StartTime = Request.Form["ssbsks"].ToString();
string EndTime = Request.Form["ssbsjs"].ToString();
string CoorSystem = Request.Form["sskyzbx"].ToString();
string SourceTable = Request.Form["sskyylb"].ToString();
int ElevationEnable = int.Parse(Request.Form["sszcghq"].ToString());
string ElevationMode = Request.Form["ssgcjz"].ToString();
mrtkp.AreaID = "";
mrtkp.ElevationEnable = ElevationEnable;
mrtkp.ElevationMode = ElevationMode;
mrtkp.SourceTable = SourceTable;
mrtkp.UserName = UserName;
mrtkp.VRSEnable = PostEnable;
mrtkp.ServerType = WorkType;
mrtkp.CoorSystem = CoorSystem;
mrtkp.RoamID = "";
mrtkp.StartTime = Convert.ToDateTime(StartTime);
mrtkp.EndTime = Convert.ToDateTime(EndTime);
if (!DAL.RTKUserPurview.Exists(mrtkp.UserName))
{
if (!DAL.RTKUserPurview.Add(mrtkp))
{
DAL.RTKUserInfo.Delete(UserName);
Response.Clear();
Response.Write("0");
Response.End();
return;
}
}
Model.RTKPostPurview rTKPostPurview = new Model.RTKPostPurview();
rTKPostPurview.UserName = UserName;
rTKPostPurview.CoorTransEnable = 0;
rTKPostPurview.HeightTransEnable = 0;
rTKPostPurview.SHPTransEnable = 0;
rTKPostPurview.DXFTransEnable = 0;
rTKPostPurview.PPPserverEnable = 0;
rTKPostPurview.ObsQualityEnable = 0;
rTKPostPurview.BaseLineEnable = 0;
rTKPostPurview.StartTime = Convert.ToDateTime(StartTime);
rTKPostPurview.EndTime = Convert.ToDateTime(EndTime);
DAL.RTKPostPurview.Add(rTKPostPurview);
//添加用户状态信息
Model.RTKUserStatus mrtks = new Model.RTKUserStatus();
mrtks.UserName = UserName;
mrtks.Company = Company;
mrtks.IsOnline = 0;
mrtks.Lat = 0;
mrtks.Lon = 0;
mrtks.StartTime = Convert.ToDateTime(StartTime);
mrtks.Remark = "";
DAL.RTKUserStatus bllrtkus = new DAL.RTKUserStatus();
if (!bllrtkus.Exists(UserName))
{
if (DAL.RTKUserStatus.Add(mrtks))
{
}
}
Model.OrderList orderList = new Model.OrderList();
orderList.UserName = Session["RegisterUserName"].ToString();
orderList.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff");
orderList.company = Company;
orderList.Price = "1000";
orderList.DealTime = DateTime.Now;
orderList.OrderContent = "账号申请";
orderList.OrderStatus = 2;
orderList.OrdeType = 0;
orderList.RoamID = "";
DAL.OrderList.Add(orderList);
//修改单位余额
Model.CompanyInfo UpdatecompanyInfo = DAL.CompanyInfo.GetModel(Company);
UpdatecompanyInfo.Balance = UpdatecompanyInfo.Balance - 1000;
DAL.CompanyInfo.Update(UpdatecompanyInfo);
//添加发票信息
Model.InvoiceList invoicelist = new Model.InvoiceList();
invoicelist.OrderDetail = orderList.ID.ToString();
invoicelist.OrderNumber = orderList.OrderNumber;
invoicelist.BelongArea = orderList.WorkArea;
invoicelist.PayTime = orderList.PayTime;
invoicelist.Price = orderList.Price;
invoicelist.Status = 1;
invoicelist.ContractStatus = 1;
invoicelist.UserName = orderList.UserName;
DAL.InvoiceList.Add(invoicelist);
//添加缴费记录
Model.PaymentRecord paymentRecord = new Model.PaymentRecord();
paymentRecord.ProductName = "账号申请";
paymentRecord.Company = Company;
paymentRecord.Type = orderList.OrdeType;
paymentRecord.Money = "-" + orderList.Price;
paymentRecord.RechargeTime = DateTime.Now;
paymentRecord.UserName = orderList.UserName;
DAL.PaymentRecord.Add(paymentRecord);
}
catch {
DAL.RTKUserInfo.Delete(UserName);
DAL.RTKUserPurview.Delete(UserName);
DAL.RTKUserStatus.Delete(UserName);
DAL.RTKPostPurview.Delete(UserName);
DAL.InvoiceList.Delete(UserName);
Response.Clear();
Response.Write("0");
Response.End();
return;
}
Response.Clear();
Response.Write("1");
Response.End();
}
if (Request["action"].ToString() == "AddUser1")
{
bool dele = true;
for (int i = 0; i < Convert.ToInt32(AccountNumber.Value); i++)
{
int[] RandKey = cs.RandomNumber.UseHashTableToNonRepeatedRandom(4, 0, 9);
string UserName = Session["RegisterUserName"].ToString() + string.Join("", RandKey);
try
{
// 个人信息部分
DAL.RegisterUser du1 = new DAL.RegisterUser();
if (DAL.RTKUserInfo.GetModel(UserName) == null && DAL.RegisterUser.GetModel(UserName) == null)
{
}
else
{
dele = false;
Response.Clear();
Response.Write("-1");
Response.End();
return;
}
string PassWord = UserName;
string WorkType = Request.Form["WorkType1"].ToString();
string Contacts = Request.Form["Contacts1"].ToString();
string Phone = Request.Form["phone1"].ToString();
string Email = Request.Form["email1"].ToString();
string Company = Request.Form["Company1"].ToString();
int Enable = int.Parse(Request.Form["status1"].ToString());
Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo();
rtkUserInfo.RegisterUserName = Session["RegisterUserName"].ToString();
rtkUserInfo.UserName = UserName;
rtkUserInfo.Company = Company;
rtkUserInfo.PassWord = AES_Key.AESEncrypt(PassWord, UserName.PadLeft(16, '0'));
rtkUserInfo.UserType = 0;
//rtkUserInfo.OrderNumber = ;
// rtkUserInfo.BelongArea = registerUser.BelongArea;
rtkUserInfo.Contact = Contacts;
rtkUserInfo.ContactPhone = Phone;
rtkUserInfo.ContactEmail = Email;
rtkUserInfo.RegTime = DateTime.Now;
rtkUserInfo.CORSCardNum = "";
if (DAL.RTKUserInfo.Add(rtkUserInfo))
{
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
return;
}
// 权限信息部分
Model.RTKUserPurview mrtkp = new Model.RTKUserPurview();
int PostEnable = int.Parse(Request.Form["ssfwky1"].ToString());
string StartTime = Request.Form["ssbsks1"].ToString();
string EndTime = Request.Form["ssbsjs1"].ToString();
string CoorSystem = Request.Form["sskyzbx1"].ToString();
string SourceTable = Request.Form["sskyylb1"].ToString();
int ElevationEnable = int.Parse(Request.Form["sszcghq1"].ToString());
string ElevationMode = Request.Form["ssgcjz1"].ToString();
mrtkp.AreaID = "";
mrtkp.ElevationEnable = ElevationEnable;
mrtkp.ElevationMode = ElevationMode;
mrtkp.SourceTable = SourceTable;
mrtkp.UserName = UserName;
mrtkp.VRSEnable = PostEnable;
mrtkp.ServerType = WorkType;
mrtkp.CoorSystem = CoorSystem;
mrtkp.RoamID = "";
mrtkp.StartTime = Convert.ToDateTime(StartTime);
mrtkp.EndTime = Convert.ToDateTime(EndTime);
mrtkp.RoamID = "";
if (!DAL.RTKUserPurview.Exists(mrtkp.UserName))
{
if (!DAL.RTKUserPurview.Add(mrtkp))
{
DAL.RTKUserInfo.Delete(UserName);
Response.Clear();
Response.Write("0");
Response.End();
return;
}
}
Model.RTKPostPurview rTKPostPurview = new Model.RTKPostPurview();
rTKPostPurview.UserName = UserName;
rTKPostPurview.CoorTransEnable = 0;
rTKPostPurview.HeightTransEnable = 0;
rTKPostPurview.SHPTransEnable = 0;
rTKPostPurview.DXFTransEnable = 0;
rTKPostPurview.PPPserverEnable = 0;
rTKPostPurview.ObsQualityEnable = 0;
rTKPostPurview.BaseLineEnable = 0;
rTKPostPurview.StartTime = Convert.ToDateTime(StartTime);
rTKPostPurview.EndTime = Convert.ToDateTime(EndTime);
DAL.RTKPostPurview.Add(rTKPostPurview);
//添加用户状态信息
Model.RTKUserStatus mrtks = new Model.RTKUserStatus();
mrtks.UserName = UserName;
mrtks.Company = Company;
mrtks.IsOnline = 0;
mrtks.Lat = 0;
mrtks.Lon = 0;
mrtks.StartTime = Convert.ToDateTime(StartTime);
mrtks.Remark = "";
DAL.RTKUserStatus bllrtkus = new DAL.RTKUserStatus();
if (!bllrtkus.Exists(UserName))
{
if (DAL.RTKUserStatus.Add(mrtks))
{
}
}
Model.OrderList orderList = new Model.OrderList();
orderList.UserName = Session["RegisterUserName"].ToString();
orderList.OrderNumber = DateTime.Now.ToString("yyyMMddhhmmssfff");
orderList.company = Company;
orderList.Price = "1000";
orderList.DealTime = DateTime.Now;
orderList.OrderContent = "账号申请";
orderList.OrderStatus = 2;
orderList.OrdeType = 0;
orderList.RoamID = "";
DAL.OrderList.Add(orderList);
//修改单位余额
Model.CompanyInfo UpdatecompanyInfo = DAL.CompanyInfo.GetModel(Company);
UpdatecompanyInfo.Balance = UpdatecompanyInfo.Balance - 1000;
DAL.CompanyInfo.Update(UpdatecompanyInfo);
//添加发票信息
Model.InvoiceList invoicelist = new Model.InvoiceList();
invoicelist.OrderDetail = orderList.ID.ToString();
invoicelist.OrderNumber = orderList.OrderNumber;
invoicelist.BelongArea = orderList.WorkArea;
invoicelist.PayTime = orderList.PayTime;
invoicelist.Price = orderList.Price;
invoicelist.Status = 1;
invoicelist.ContractStatus = 1;
invoicelist.UserName = orderList.UserName;
DAL.InvoiceList.Add(invoicelist);
//添加缴费记录
Model.PaymentRecord paymentRecord = new Model.PaymentRecord();
paymentRecord.ProductName = "账号申请";
paymentRecord.Company = Company;
paymentRecord.Type = orderList.OrdeType;
paymentRecord.Money = "-" + orderList.Price;
paymentRecord.RechargeTime = DateTime.Now;
paymentRecord.UserName = orderList.UserName;
DAL.PaymentRecord.Add(paymentRecord);
}
catch
{
DAL.RTKUserInfo.Delete(UserName);
DAL.RTKUserPurview.Delete(UserName);
DAL.RTKUserStatus.Delete(UserName);
DAL.RTKPostPurview.Delete(UserName);
DAL.InvoiceList.Delete(UserName);
Response.Clear();
Response.Write("0");
Response.End();
return;
}
}
Response.Clear();
Response.Write("1");
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 5)
{
Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>");
Response.End();
}
#region 加载页面数据
if (Session["UserType"].ToString() != "0")
{
string tempUserName = Session["UserName"].ToString();
Model.RegisterUser registerUser = new Model.RegisterUser();
registerUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
userName.InnerText = registerUser.UserName;
try
{
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex));
company.InnerText = companyInfo.Company;
Balance.InnerText = companyInfo.Balance.ToString();
}
catch
{
company.InnerText = "未绑定";
}
switch (registerUser.UserType)
{
case 1:
userType.InnerText = "普通用户";
break;
case 2:
userType.InnerText = "协管员用户";
break;
case 3:
userType.InnerText = "超级管理员用户";
break;
default:
break;
}
registerTime.InnerText = registerUser.RegTime.ToString("yyyy-MM-dd HH:mm:ss");
email.InnerText = cs.HideCharShow.StrReplaceByStar(registerUser.Email, 3, 5, "*");
phone.InnerText = cs.HideCharShow.StrReplaceByStar(registerUser.Phone, 4, 7, "*");
switch (registerUser.CertifiationStatus)
{
case 0:
qualificationStatus.InnerText = "尚未认证资质";
qualificationStatus.Style.Add("color", "red");
RechargeBtn.Visible = false;
break;
case 1:
case 3:
qualificationStatus.InnerText = "资质认证中";
qualificationStatus.Style.Add("color", "blue");
RechargeBtn.Visible = false;
break;
case 2:
case 4:
qualificationStatus.InnerText = "资质认证通过";
qualificationStatus.Style.Add("color", "green");
RechargeBtn.Visible = true;
break;
case 5:
qualificationStatus.InnerText = "资质认证失败";
qualificationStatus.Style.Add("color", "red");
RechargeBtn.Visible = false;
break;
case 6:
qualificationStatus.InnerText = "资质变更中";
qualificationStatus.Style.Add("color", "blue");
RechargeBtn.Visible = false;
break;
default:
break;
}
}
else
{
string rr = Session["UserName"].ToString();
Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo();
rtkUserInfo = DAL.RTKUserInfo.GetModel(Session["UserName"].ToString());
userType.InnerText = "RTK作业用户";
registerTime.InnerText = rtkUserInfo.RegTime.ToString("yyyy-MM-dd HH:mm:ss");
email.InnerText = cs.HideCharShow.StrReplaceByStar(rtkUserInfo.ContactEmail, 3, 5, "*");
phone.InnerText = cs.HideCharShow.StrReplaceByStar(rtkUserInfo.ContactPhone, 4, 7, "*");
qualificationStatus.InnerText = "资质认证通过";
company_update.Visible = false;
Model.RegisterUser registerUser = new Model.RegisterUser();
registerUser = DAL.RegisterUser.GetModel(rtkUserInfo.RegisterUserName);
try
{
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex));
company.InnerText = companyInfo.Company;
}
catch
{
company.InnerText = "未绑定";
}
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
//Session["UserName"] = "******";
//Session["UserType"] = "1";
if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 5)
{
Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>");
Response.End();
}
if (Request["action"] != "" && Request["action"] != null)
{
if (Request["action"] == "AddData")
{
AddData();
}
if (Request["action"] == "save")
{
save();
}
if (Request["action"].ToString() == "check")
{
string username = Request["data"].ToString();
DAL.CompanyInfo du = new DAL.CompanyInfo();
if (DAL.CompanyInfo.Exists(username))
{
Response.Clear();
Response.Write("1");
Response.End();
}
else
{
Response.Clear();
Response.Write("0");
Response.End();
}
}
}
if (!IsPostBack)
{
int companyCertifiationIndex = Convert.ToInt32(DAL.RegisterUser.GetModel(Session["UserName"].ToString()).CertifiationIndex);
//根据注册用户的认证id索引加载页面信息
Model.CompanyInfo companyinfo = DAL.CompanyInfo.GetModel(companyCertifiationIndex);
company_name.Value = companyinfo.Company;
map_qualification_path_file_.Src = companyinfo.SurveyingFile;
switch (companyinfo.Industry)
{
case "1":
type_id.Value = "市内测绘资质单位";
break;
case "2":
type_id.Value = "政府机构";
break;
case "3":
type_id.Value = "仪器公司";
break;
case "4":
type_id.Value = "高校/科研院所";
break;
case "5":
type_id.Value = "其他非测绘资质执证单位";
break;
case "6":
type_id.Value = "市外测绘资质单位";
break;
case "7":
type_id.Value = "市外非测绘资质单位";
break;
case "8":
type_id.Value = "市内非测绘资质单位";
break;
}
maplevel.Value = companyinfo.SurveyingQualification;
map_qualification_sn.Value = companyinfo.SurveyingNumber;
corporate.Value = companyinfo.LegalPerson;
corporate_tel.Value = companyinfo.CompanyTel;
business_licence.Value = companyinfo.OrganizationCode;
address.Value = companyinfo.Address;
//business_licence_path_file_.Src = companyinfo.BusinessLicense;
//corporate_id_card_front_file_.Src = companyinfo.LegalIDCardFile;
//secrecy_agreement_path_file_.Src = companyinfo.ServiceAgreementFile;
//client_authorization_path_file_.Src = companyinfo.PowerOfAttorney;
contact_name.Value = companyinfo.Contact;
//contact_phone.Value = companyinfo.CompanyTel;
phone.Value = companyinfo.CompanyTel;
//string res = cs.JSONHelper.ObjectToJSON(companyinfo);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(Model.CompanyInfo model)
{
return(dal.Delete(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.CompanyInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.CompanyInfo model)
{
return(dal.Add(model));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 1 || Convert.ToInt32(Session["UserType"]) > 3)
{
Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/login/login.aspx\";</script>");
Response.End();
}
if (!IsPostBack)
{
rtkUserInfoId = Convert.ToInt32(Request["id"]);
if (rtkUserInfoId == null)
{
Response.Redirect("/forms/administrator/users/RtkUserManage.aspx");
Response.End();
}
#region 加载初始数据
//作业区域
DataSet dswork = DAL.WorkingArea.GetList("1=1");
foreach (DataRow dr in dswork.Tables[0].Rows)
{
sszyqu.Items.Add(dr["AreaName"].ToString());
}
//源列表
DataSet dssource = DAL.SourceTable.GetList("1=1");
foreach (DataRow dr in dssource.Tables[0].Rows)
{
ssylbpz.Items.Add(dr["Source"].ToString());
}
// 坐标系
DataSet dsCoor = DAL.CoorSysPars.GetList("YSZBXM ='WGS84'");
foreach (DataRow dr in dsCoor.Tables[0].Rows)
{
ssdfzbx.Items.Add(dr["MDZBXM"].ToString());
shzbzhlb.Items.Add(dr["YSZBXM"].ToString() + "_" + dr["MDZBXM"].ToString());
}
#endregion
#region 用户信息
Model.RTKUserInfo mrtk = DAL.RTKUserInfo.GetModel(rtkUserInfoId);
if (mrtk.UserType == 1)
{
cominfo1.Visible = false;
cominfo12.Visible = false;
cominfo3.Visible = false;
cominfo4.Visible = false;
}
else
{
user1.Visible = false;
user2.Visible = false;
}
UserName.Value = mrtk.UserName;
PassWord.Value = AES_Key.AESDecrypt(mrtk.PassWord, mrtk.UserName.PadLeft(16, '0'));
if (mrtk.UserType == -1)
{
corszhky.SelectedIndex = 1;
}
else
{
corszhky.SelectedIndex = 0;
}
Contacts.Value = mrtk.Contact;
Phone.Value = mrtk.ContactPhone;
contactEmail.Value = mrtk.ContactEmail;
regtime.Value = mrtk.RegTime.ToString();
#endregion
if (mrtk.UserType == 1)
{
//IDCardNumber.Value = mrtk.IDCardNumber;
//IDCard.Value = mrtk.IDCard;
}
else
{
try
{
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(mrtk.Company);
company.Value = companyInfo.Company;
BelongArea.Value = companyInfo.BelongArea;
dwType.Value = companyInfo.Industry;
Industry.Value = companyInfo.Industry;
}
catch
{
}
}
corsbelongarea.Value = mrtk.BelongArea;
#region 用户权限
Model.RTKUserPurview rTKUserPurview = DAL.RTKUserPurview.GetModel(mrtk.UserName);
Model.RTKPostPurview rTKPostPurview = DAL.RTKPostPurview.GetModel(mrtk.UserName);
if (rTKUserPurview.ServerType == "cm")
{
corstype.Value = "厘米级";
}
else
{
corstype.Value = "亚米级";
}
if (rTKUserPurview.VRSEnable == 1)
{
ssfwky.SelectedIndex = 1;
}
else
{
ssfwky.SelectedIndex = 0;
}
ssbsks.Value = rTKUserPurview.StartTime.ToString();
ssbsjs.Value = rTKUserPurview.EndTime.ToString();
if (rTKPostPurview.CoorTransEnable == 1)
{
ssdfzbxhq.SelectedIndex = 0;
}
else
{
ssdfzbxhq.SelectedIndex = 1;
}
sskyzbx.Value = rTKUserPurview.CoorSystem;
if (rTKUserPurview.CoorSystem == "")
{
ssdfzbxky.SelectedIndex = 0;
}
else
{
ssdfzbxky.SelectedIndex = 1;
ssdfzbx.Value = rTKUserPurview.CoorSystem.Split(';')[0];
}
if (rTKUserPurview.SourceTable == "")
{
ssylbky.SelectedIndex = 0;
}
else
{
ssylbky.SelectedIndex = 1;
ssylbpz.Value = rTKUserPurview.SourceTable.Split(';')[0];
}
sskyylb.Value = rTKUserPurview.SourceTable;
if (rTKUserPurview.AreaID == "")
{
sskyqu.Value = "全部区域";
sszyqu.SelectedIndex = 0;
sszyqyky.SelectedIndex = 1;
}
else
{
string[] workareas = rTKUserPurview.AreaID.Split(';');
string workarea = "";
foreach (var wo in workareas)
{
try
{
workarea += (DAL.WorkingArea.GetModel(int.Parse(wo)).AreaName + ";");
}
catch (Exception)
{
}
}
sskyqu.Value = workarea; //mrtkpur.AreaID;//
sszyqyky.SelectedIndex = 1;
sszyqu.Value = DAL.WorkingArea.GetModel(int.Parse(workareas[0])).AreaName; //workareas[0];//
}
if (rTKUserPurview.ElevationEnable == 1)
{
sszcghq.SelectedIndex = 1;
}
else
{
sszcghq.SelectedIndex = 0;
}
if (rTKUserPurview.ElevationMode.Contains("85"))
{
ssgcjz.SelectedIndex = 0;
}
else
{
ssgcjz.SelectedIndex = 1;
}
if (rTKUserPurview.ServerType == "cm")
{
WorkType.Value = "厘米级";
}
else
{
if (rTKUserPurview.ServerType == "dm")
{
WorkType.Value = "亚米级";
}
else
{
if (rTKUserPurview.ServerType == "m")
{
WorkType.Value = "米级";
}
else
{
WorkType.Value = "厘米级";
}
}
}
#endregion
}
if (Request["action"] == "save")
{
#region 用户个人信息
Model.RTKUserInfo rTKUserInfo = DAL.RTKUserInfo.GetModel(rtkUserInfoId);
rTKUserInfo.UserName = Request.Form["UserName"].ToString();
try
{
rTKUserInfo.Company = Request.Form["Company"].ToString();
}
catch
{
rTKUserInfo.Company = "个人";
}
rTKUserInfo.PassWord = AES_Key.AESEncrypt(Request.Form["PassWord"].ToString().Trim(), Request.Form["UserName"].ToString().Trim().PadLeft(16, '0'));
rTKUserInfo.ContactPhone = Request.Form["Phone"].ToString();
rTKUserInfo.ContactEmail = Request.Form["contactEmail"].ToString();
rTKUserInfo.RegTime = DateTime.Parse(Request.Form["regtime"].ToString());
if (Request.Form["corszhky"].ToString().Trim() == "可用")
{
rTKUserInfo.UserType = -1;
}
try
{
if (Request.Form["BelongArea"].ToString() == "")
{
rTKUserInfo.BelongArea = "全部";
}
else
{
rTKUserInfo.BelongArea = Request.Form["BelongArea"].ToString();
}
}
catch
{
rTKUserInfo.BelongArea = "全部";
}
if (rTKUserInfo.UserType == 1)
{
//rTKUserInfo.IDCard = Request.Form["IDCard"].ToString();
//rTKUserInfo.IDCardNumber = Request.Form["IDCardNumber"].ToString();
}
else
{
rTKUserInfo.UserType = 0;
Model.CompanyInfo mci = DAL.CompanyInfo.GetModel(rTKUserInfo.Company);
}
rTKUserInfo.BelongArea = Request.Form["corsbelongarea"].ToString();
DAL.RTKUserInfo.Update(rTKUserInfo);
#endregion
#region 权限
Model.RTKUserPurview rTKUserPurview = DAL.RTKUserPurview.GetModel(rTKUserInfo.UserName);
Model.RTKPostPurview rTKPostPurview = DAL.RTKPostPurview.GetModel(rTKUserInfo.UserName);
rTKUserPurview.AreaID = Request.Form["sskyqu"].ToString();
if (Request.Form["ssbsjs"] == null || Request.Form["ssbsjs"] == "")
{
rTKUserPurview.EndTime = DateTime.Now;
rTKPostPurview.EndTime = DateTime.Now;
}
else
{
rTKUserPurview.EndTime = DateTime.Parse(Request.Form["ssbsjs"].ToString());
rTKPostPurview.EndTime = DateTime.Parse(Request.Form["ssbsjs"].ToString());
}
if (Request.Form["WorkType"].ToString() == "厘米级")
{
rTKUserPurview.ServerType = "cm";
}
if (Request.Form["WorkType"].ToString() == "亚米级")
{
rTKUserPurview.ServerType = "dm";
}
if (Request.Form["WorkType"].ToString() == "米级")
{
rTKUserPurview.ServerType = "m";
}
if (Request.Form["sskyqu"].ToString().Trim() == "全部区域")
{
rTKUserPurview.AreaID = "";
}
else
{
string[] areanames = Request.Form["sskyqu"].ToString().Split(';');
rTKUserPurview.AreaID = "";
foreach (var aname in areanames)
{
try
{
rTKUserPurview.AreaID += (DAL.WorkingArea.GetModel(aname).ID + ";");
}
catch (Exception)
{
}
}
}
if (Request.Form["ssgcjz"].ToString().Trim() == "56国家高程")
{
rTKUserPurview.ElevationMode = "56GC";
}
else
{
rTKUserPurview.ElevationMode = "85GC";
}
if (Request.Form["sszcghq"] == null)
{
if (sszcghq.SelectedIndex == 1)
{
rTKUserPurview.ElevationEnable = 1;
}
else
{
rTKUserPurview.ElevationEnable = 0;
}
}
else
{
if (Request.Form["sszcghq"].ToString().Trim() == "可用")
{
rTKUserPurview.ElevationEnable = 1;
}
else
{
rTKUserPurview.ElevationEnable = 0;
}
}
if (Request.Form["ssdfzbxhq"].ToString().Trim() == "可用")
{
rTKPostPurview.CoorTransEnable = 1;
}
else
{
rTKPostPurview.CoorTransEnable = 0;
}
rTKUserPurview.CoorSystem = Request.Form["sskyzbx"].ToString();
rTKUserPurview.SourceTable = Request.Form["sskyylb"].ToString();
rTKUserPurview.UserName = Request.Form["username"].ToString();
if (Request.Form["ssfwky"].ToString().Trim() == "否")
{
rTKUserPurview.VRSEnable = 0;
}
else
{
rTKUserPurview.VRSEnable = 1;
}
//DAL.RTKUserPurview.Update(rTKUserPurview);
//DAL.RTKPostPurview.Update(rTKPostPurview);
#endregion
Model.SysLog msyslog = new Model.SysLog();
msyslog.UserName = Session["UserName"].ToString();
msyslog.LogTime = DateTime.Now;
msyslog.LogType = 0;
msyslog.Remark = "管理员修改了CORS用户：" + rTKUserInfo.UserName;
DAL.SysLog.Add(msyslog);
Response.Clear();
Response.Write("1");
Response.End();
}
}
public void save()
{
int companyCertifiationIndex = Convert.ToInt32(DAL.RegisterUser.GetModel(Session["UserName"].ToString()).CertifiationIndex);
Model.CompanyInfo updateinfo = DAL.CompanyInfo.GetModel(companyCertifiationIndex);
updateinfo.Company = company_name.Value;
type_id.SelectedIndex = Convert.ToInt32(updateinfo.Industry) - 1;
switch (type_id.Value)
{
case "市内测绘资质单位":
updateinfo.Industry = "1";
break;
case "政府机构":
updateinfo.Industry = "2";
break;
case "仪器公司":
updateinfo.Industry = "3";
break;
case "科研院所":
updateinfo.Industry = "4";
break;
case "其他非测绘资质执证单位":
updateinfo.Industry = "5";
break;
case "市外测绘资质单位":
updateinfo.Industry = "6";
break;
case "市外非测绘资质单位":
updateinfo.Industry = "7";
break;
case "市内非测绘资质单位":
updateinfo.Industry = "8";
break;
}
updateinfo.SurveyingQualification = maplevel.Value;
updateinfo.SurveyingNumber = map_qualification_sn.Value;
updateinfo.LegalPerson = corporate.Value;
updateinfo.CompanyTel = corporate_tel.Value;
updateinfo.OrganizationCode = business_licence.Value;
updateinfo.Address = address.Value;
updateinfo.Industry = type_id.Value;
updateinfo.Contact = contact_name.Value;
//contact_phone.Value = companyinfo.CompanyTel;
updateinfo.CompanyTel = phone.Value;
updateinfo.ID = companyCertifiationIndex;
if (business_licence_path == "")
{
updateinfo.BusinessLicense = business_licence_path_file_.Src;
}
else
{
updateinfo.BusinessLicense = business_licence_path;
}
//if (corporate_id_card_front == "")
//{
// updateinfo.LegalIDCardFile = corporate_id_card_front_file_.Src;
//}
//else
//{
// updateinfo.LegalIDCardFile = corporate_id_card_front;
//}
if (map_qualification_path == "")
{
updateinfo.SurveyingFile = map_qualification_path_file_.Src;
}
else
{
updateinfo.SurveyingFile = map_qualification_path;
}
//if (secrecy_agreement_path=="")
//{
// updateinfo.ServiceAgreementFile = secrecy_agreement_path_file_.Src;
//}
//else
//{
// updateinfo.ServiceAgreementFile = secrecy_agreement_path;
//}
//if (client_authorization_path=="")
//{
// updateinfo.PowerOfAttorney = client_authorization_path_file_.Src;
//}
//else
//{
// updateinfo.PowerOfAttorney = client_authorization_path;
//}
if (DAL.CompanyInfo.Exists(updateinfo.Company))
{
Response.Clear();
Response.Write("-1");
Response.End();
}
else
{
DAL.CompanyInfo.Update(updateinfo);
Model.RegisterUser registeruser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
registeruser.CertifiationStatus = 6;
DAL.RegisterUser.Update(registeruser);
Response.Clear();
Response.Write("1");
Response.End();
}
}
private int Verifycompanyform()
{
Model.CompanyInfo companyinfo = new Model.CompanyInfo();
companyinfo.Address = Request.Form["address"];
try
{
companyinfo.BelongArea = Request.Form["city"];
}
catch
{
companyinfo.BelongArea = "重庆";
}
companyinfo.BusinessLicense = business_licence_path;
companyinfo.Company = Request.Form["company_name"];
companyinfo.CompanyTel = Request.Form["corporate_tel"];
companyinfo.Contact = Request.Form["contact_name"];
companyinfo.ContactIDCardFile = operator_id_card_front;
companyinfo.ContactIDCardNumer = "";
try
{
companyinfo.Industry = Request.Form["company_type_id"];
}
catch
{
companyinfo.Industry = "1";
}
// companyinfo.LegalIDCardFile = corporate_id_card_front;
companyinfo.LegalIDCardNumber = "";
companyinfo.LegalPerson = Request.Form["corporate"];
companyinfo.OrganizationCode = Request.Form["business_licence"];
//companyinfo.PowerOfAttorney = client_authorization_path;
companyinfo.SurveyingFile = map_qualification_path;
companyinfo.SurveyingNumber = Request.Form["map_qualification_sn"];
//companyinfo.ServiceAgreementFile = secrecy_agreement_path;
try
{
companyinfo.SurveyingQualification = Request.Form["map_level"];
}
catch
{
companyinfo.SurveyingQualification = "1";
}
if (DAL.CompanyInfo.Exists(companyinfo.Company))
{
//Response.Write(" <script>function window.onload() {alert( '该机构已认证,不能重复认证！' ); } </script> ");
// string json = "{\"code\":200}";
Response.Write("{\"code\":100}");
Response.End();
//Model.CompanyInfo companyInfo1= DAL.CompanyInfo.GetModel(companyinfo.Company);
//companyinfo.ID = companyInfo1.ID;
//DAL.CompanyInfo.Update1(companyinfo);
//Model.CompanyInfo temp_companyinfo = DAL.CompanyInfo.GetModel(companyinfo.Company);
//Model.RegisterUser registeruser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
//registeruser.CertifiationIndex = temp_companyinfo.ID.ToString();
//registeruser.CertifiationStatus = 1;
//registeruser.BelongArea = companyinfo.BelongArea;
//DAL.RegisterUser.Update(registeruser);
}
else
{
companyinfo.Balance = 0;
DAL.CompanyInfo.Add(companyinfo);
Model.CompanyInfo temp_companyinfo = DAL.CompanyInfo.GetModel();
Model.RegisterUser registeruser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
registeruser.CertifiationIndex = temp_companyinfo.ID.ToString();
//registeruser.CertifiationIndex = temp_companyinfo.ID.ToString();
registeruser.CertifiationStatus = 1;
registeruser.BelongArea = companyinfo.BelongArea;
DAL.RegisterUser.Update(registeruser);
}
string json = "{\"code\":200}";
Response.Write(json);
Response.End();
return(1);
//选择最新添加的一条数据
//select top 1 * from tra.dbo.订单 order by 下单时间 desc --时间倒序排列取第一条
// companyinfo.
//string map_level = Request.Form["map_level"];
//string corporate = Request.Form["corporate"];
//string province = Request.Form["province"];
//string city = Request.Form["city"];
//string town = Request.Form["town"];
//string address = Request.Form["address"];
//string post_code = Request.Form["post_code"];
//string contact_phone = Request.Form["contact_phone"];
//string contact_email = Request.Form["contact_email"];
//string contact_qq = Request.Form["contact_qq"];
//string contact_wechat = Request.Form["contact_wechat"];
}
private bool AddData()
{
try
{
Model.OrderList orderlist = DAL.OrderList.GetModel(Convert.ToInt32(Request["verify"]));
if (Request["status"] == "OK")
{
orderlist.OrderStatus = 2;
if (orderlist.OrdeType == 0)//账号申请
{
//订单审核通过后添加发票信息
Model.InvoiceList invoicelist = new Model.InvoiceList();
invoicelist.OrderDetail = orderlist.ID.ToString();
invoicelist.OrderNumber = orderlist.OrderNumber;
invoicelist.BelongArea = orderlist.WorkArea;
invoicelist.PayTime = orderlist.PayTime;
invoicelist.Price = orderlist.Price;
invoicelist.Status = 1;
invoicelist.ContractStatus = 1;
invoicelist.UserName = orderlist.UserName;
invoicelist.Type = 0;
DAL.InvoiceList.Add(invoicelist);
Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo();
for (int i = 0; i < orderlist.AccountNum; i++)
{
Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName);
System.Random a = new Random(DateTime.Now.Millisecond);
// use System.DateTime.Now.Millisecond as seed
int RandKey = a.Next(100, 999);
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex));
rtkUserInfo.RegisterUserName = orderlist.UserName;
rtkUserInfo.UserName = orderlist.UserName + RandKey.ToString();
rtkUserInfo.Company = companyInfo.Company;
rtkUserInfo.PassWord = AES_Key.AESEncrypt(rtkUserInfo.UserName, rtkUserInfo.UserName.PadLeft(16, '0'));
rtkUserInfo.UserType = 0;
rtkUserInfo.OrderNumber = orderlist.OrderNumber;
rtkUserInfo.CORSCardNum = "";
rtkUserInfo.BelongArea = registerUser.BelongArea;
rtkUserInfo.Contact = companyInfo.Contact;
rtkUserInfo.ContactPhone = registerUser.Phone;
rtkUserInfo.ContactEmail = registerUser.Email;
rtkUserInfo.RegTime = DateTime.Now;
if (!DAL.RTKUserInfo.Exists(rtkUserInfo.UserName))
{
DAL.RTKUserInfo.Add(rtkUserInfo);
}
else
{
//如何已经存在则重新循环一次
i = i - 1;
continue;
}
#region 权限信息部分
Model.RTKUserPurview rtkUserPurview = new Model.RTKUserPurview();
Model.RTKPostPurview rTKPostPurview = new Model.RTKPostPurview();
string startTime = DateTime.Now.ToString();
rtkUserPurview.UserName = rtkUserInfo.UserName;
rtkUserPurview.StartTime = DateTime.Now;
rtkUserPurview.EndTime = DateTime.Now.AddMonths(Convert.ToInt32(orderlist.ServiceDuration));
rtkUserPurview.ServerType = orderlist.ServerType;
string CoorSystem = "";
string SourceTable = "";
rtkUserPurview.VRSEnable = 1;
rtkUserPurview.SourceTable = SourceTable;
rtkUserPurview.CoorSystem = CoorSystem;
if (orderlist.RoamID == "" || orderlist.RoamID == null)
{
rtkUserPurview.RoamID = "";
}
else
{
rtkUserPurview.RoamID = orderlist.RoamID;
}
if (orderlist.ElevationEnable == 1)
{
rtkUserPurview.ElevationEnable = 1;
}
else
{
rtkUserPurview.ElevationEnable = 0;
}
rTKPostPurview.UserName = rtkUserInfo.UserName;
rTKPostPurview.StartTime = DateTime.Now;
rTKPostPurview.EndTime = DateTime.Now.AddMonths(Convert.ToInt32(orderlist.ServiceDuration));
DAL.RTKPostPurview.Add(rTKPostPurview);
DAL.RTKUserPurview.Add(rtkUserPurview);
companyInfo.Balance = companyInfo.Balance - Convert.ToSingle(orderlist.Price);
DAL.CompanyInfo.Update2(companyInfo);
#endregion
}
}
if (orderlist.OrdeType == 3)//账号申请（自定义账号）
{
//订单审核通过后添加发票信息
Model.InvoiceList invoicelist = new Model.InvoiceList();
invoicelist.OrderDetail = orderlist.ID.ToString();
invoicelist.OrderNumber = orderlist.OrderNumber;
invoicelist.BelongArea = orderlist.WorkArea;
invoicelist.PayTime = orderlist.PayTime;
invoicelist.Price = orderlist.Price;
invoicelist.Status = 1;
invoicelist.ContractStatus = 1;
invoicelist.UserName = orderlist.UserName;
invoicelist.Type = 0;
DAL.InvoiceList.Add(invoicelist);
Model.RTKUserInfo rtkUserInfo = new Model.RTKUserInfo();
Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(orderlist.UserName);
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex));
DataSet ds = DAL.DeUserInfo.GetList(orderlist.OrderNumber);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
rtkUserInfo.RegisterUserName = orderlist.UserName;
rtkUserInfo.UserName = ds.Tables[0].Rows[i]["UserName"].ToString();
rtkUserInfo.Company = companyInfo.Company;
rtkUserInfo.PassWord = AES_Key.AESEncrypt(rtkUserInfo.UserName, rtkUserInfo.UserName.PadLeft(16, '0'));
rtkUserInfo.UserType = 0;
rtkUserInfo.OrderNumber = orderlist.OrderNumber;
rtkUserInfo.BelongArea = registerUser.BelongArea;
rtkUserInfo.Contact = companyInfo.Contact;
rtkUserInfo.ContactPhone = registerUser.Phone;
rtkUserInfo.ContactEmail = registerUser.Email;
rtkUserInfo.CORSCardNum = "";
rtkUserInfo.RegTime = DateTime.Now;
if (!DAL.RTKUserInfo.Exists(rtkUserInfo.UserName))
{
DAL.RTKUserInfo.Add(rtkUserInfo);
}
else
{
//如何已经存在则重新循环一次
i = i - 1;
continue;
}
#region 权限信息部分
Model.RTKUserPurview rtkUserPurview = new Model.RTKUserPurview();
Model.RTKPostPurview rTKPostPurview = new Model.RTKPostPurview();
string startTime = DateTime.Now.ToString();
rtkUserPurview.UserName = rtkUserInfo.UserName;
rtkUserPurview.StartTime = DateTime.Now;
rtkUserPurview.EndTime = DateTime.Now.AddMonths(Convert.ToInt32(orderlist.ServiceDuration));
rtkUserPurview.ServerType = orderlist.ServerType;
string CoorSystem = "";
string SourceTable = "";
rtkUserPurview.VRSEnable = 1;
rtkUserPurview.SourceTable = SourceTable;
rtkUserPurview.CoorSystem = CoorSystem;
if (orderlist.RoamID == "" || orderlist.RoamID == null)
{
rtkUserPurview.RoamID = "";
}
else
{
rtkUserPurview.RoamID = orderlist.RoamID;
}
if (orderlist.ElevationEnable == 1)
{
rtkUserPurview.ElevationEnable = 1;
}
else
{
rtkUserPurview.ElevationEnable = 0;
}
rTKPostPurview.UserName = rtkUserInfo.UserName;
rTKPostPurview.StartTime = DateTime.Now;
rTKPostPurview.EndTime = DateTime.Now.AddMonths(Convert.ToInt32(orderlist.ServiceDuration));
DAL.RTKPostPurview.Add(rTKPostPurview);
DAL.RTKUserPurview.Add(rtkUserPurview);
#endregion
}
companyInfo.Balance = companyInfo.Balance - Convert.ToSingle(orderlist.Price);
DAL.CompanyInfo.Update2(companyInfo);
Model.PaymentRecord paymentRecord = new Model.PaymentRecord();
paymentRecord.ProductName = "账号申请";
paymentRecord.Company = orderlist.company;
paymentRecord.Type = orderlist.OrdeType;
paymentRecord.Money = "-" + orderlist.Price;
paymentRecord.RechargeTime = DateTime.Now;
paymentRecord.UserName = orderlist.UserName;
DAL.PaymentRecord.Add(paymentRecord);
}
if (orderlist.OrdeType == 1)//账号续费
{
Model.InvoiceList invoicelist = new Model.InvoiceList();
invoicelist.OrderDetail = orderlist.ID.ToString();
invoicelist.OrderNumber = orderlist.OrderNumber;
invoicelist.BelongArea = orderlist.WorkArea;
invoicelist.PayTime = orderlist.PayTime;
invoicelist.Price = orderlist.Price;
invoicelist.Status = 1;
invoicelist.ContractStatus = 1;
invoicelist.UserName = orderlist.UserName;
invoicelist.Type = 1;
DAL.InvoiceList.Add(invoicelist);
string a = orderlist.OrderContent;
string name = orderlist.OrderContent.Substring(4);
Regex regex = new Regex(";");//以 [##] 分割
string[] result = regex.Split(name);
for (int i = 0; i < result.Length; i++)
{
if (result[i] != "")
{
Model.RTKUserPurview rtkUserPurview = DAL.RTKUserPurview.GetModel(result[i]);
Model.RTKPostPurview rTKPostPurview = DAL.RTKPostPurview.GetModel(result[i]);
rtkUserPurview.UserName = result[i];
rtkUserPurview.EndTime = rtkUserPurview.EndTime.AddMonths(Convert.ToInt32(orderlist.ServiceDuration));
rTKPostPurview.UserName = result[i];
rTKPostPurview.EndTime = rTKPostPurview.EndTime.AddMonths(Convert.ToInt32(orderlist.ServiceDuration));
DAL.RTKPostPurview.Update1(rTKPostPurview);
DAL.RTKUserPurview.Update1(rtkUserPurview);
}
}
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(orderlist.company);
companyInfo.Balance = companyInfo.Balance - Convert.ToSingle(orderlist.Price);
DAL.CompanyInfo.Update2(companyInfo);
Model.PaymentRecord paymentRecord = new Model.PaymentRecord();
paymentRecord.ProductName = "账号续费";
paymentRecord.Company = orderlist.company;
paymentRecord.Type = orderlist.OrdeType;
paymentRecord.Money = "-" + orderlist.Price;
paymentRecord.RechargeTime = DateTime.Now;
paymentRecord.UserName = orderlist.UserName;
DAL.PaymentRecord.Add(paymentRecord);
}
if (orderlist.OrdeType == 2)//账号充值
{
Model.InvoiceList invoicelist = new Model.InvoiceList();
invoicelist.OrderDetail = orderlist.ID.ToString();
invoicelist.OrderNumber = orderlist.OrderNumber;
invoicelist.BelongArea = orderlist.WorkArea;
invoicelist.PayTime = orderlist.PayTime;
invoicelist.Price = orderlist.Price;
invoicelist.Status = 1;
invoicelist.ContractStatus = 1;
invoicelist.UserName = orderlist.UserName;
invoicelist.Type = 2;
DAL.InvoiceList.Add(invoicelist);
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(orderlist.company);
companyInfo.Balance += Convert.ToSingle(orderlist.Price);
DAL.CompanyInfo.Update2(companyInfo);
Model.PaymentRecord paymentRecord = new Model.PaymentRecord();
paymentRecord.ProductName = "账号充值";
paymentRecord.Company = orderlist.company;
paymentRecord.Type = orderlist.OrdeType;
paymentRecord.Money = orderlist.Price;
paymentRecord.RechargeTime = DateTime.Now;
paymentRecord.UserName = orderlist.UserName;
DAL.PaymentRecord.Add(paymentRecord);
}
}
else
{
orderlist.OrderStatus = 3;
}
DAL.OrderList.Update(orderlist);
return(true);
}
catch (System.Threading.ThreadAbortException)
{
return(true);
}
catch (Exception ex)
{
cs.WebLogger.WriteErroLog(ex.ToString()); //输出到文件中
//Response.Write("<script>alert(\"1\")</script>");
return(true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Session["UserName"] = "******";
//Session["UserType"] = "1";
if (Session["UserName"] == null || Session["UserType"] == null || Convert.ToInt32(Session["UserType"]) < 0 || Convert.ToInt32(Session["UserType"]) > 5)
{
Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/publicforms/Login/Login.aspx\";</script>");
Response.End();
}
string UserName = Session["UserName"].ToString();
if (Request["action"] != null)
{
switch (Request["action"])
{
case "AddData":
//Response.ContentType = "text/plain";
AddData();
//Response.End();
break;
case "verifycompanyform":
Verifycompanyform();
break;
case "company_judge":
company_judge(Request["company_name"]);
break;
default:
break;
}
if (Request["action"].ToString() == "check")
{
string username = Request["data"].ToString();
DAL.CompanyInfo du = new DAL.CompanyInfo();
if (DAL.CompanyInfo.Exists(username))
{
Response.Clear();
Response.Write("0");
Response.End();
}
else
{
Response.Clear();
Response.Write("1");
Response.End();
}
}
}
if (DAL.RegisterUser.Exists(Session["UserName"].ToString()))
{
Model.RegisterUser registerUser = DAL.RegisterUser.GetModel(Session["UserName"].ToString());
if (registerUser.CertifiationStatus == 5)
{
try
{
Model.CompanyInfo companyInfo = DAL.CompanyInfo.GetModel(Convert.ToInt32(registerUser.CertifiationIndex));
company_name.Value = companyInfo.Company;
map_level.Value = companyInfo.SurveyingQualification;
map_qualification_sn.Value = companyInfo.SurveyingNumber;
business_licence.Value = companyInfo.OrganizationCode;
corporate.Value = companyInfo.LegalPerson;
corporate_tel.Value = companyInfo.CompanyTel;
province.SelectedIndex = 1;
city.SelectedIndex = 1;
town.SelectedIndex = 1;
address.Value = companyInfo.Address;
post_code.Value = "";
map_qualification_path_file_.Src = companyInfo.SurveyingFile;
map_qualification_path = companyInfo.SurveyingFile;
business_licence_path_file_.Src = companyInfo.BusinessLicense;
business_licence_path = companyInfo.BusinessLicense;
// corporate_id_card_front_file_.Src = companyInfo.LegalIDCardFile;
//corporate_id_card_front = companyInfo.LegalIDCardFile;
// operator_id_card_front_file_.Src = companyInfo.ContactIDCardFile;
// operator_id_card_front = companyInfo.ContactIDCardFile;
// client_authorization_path_file_.Src = companyInfo.PowerOfAttorney;
// client_authorization_path = companyInfo.PowerOfAttorney;
contact_name.Value = companyInfo.Contact;
qcphone.Value = companyInfo.CompanyTel;
//secrecy_agreement_path_file_.Src = companyInfo.ServiceAgreementFile;
}
catch
{
}
}
}
}
