/// <summary>
/// 计量单位验证
/// </summary>
/// <param name="value"></param>
/// <param name="str"></param>
/// <param name="index"></param>
/// <param name="Tran"></param>
/// <returns></returns>
public string CheckGoodsUnit(string value, string str, SqlTransaction Tran)
{
List <Hi.Model.BD_DefDoc_B> l = new Hi.BLL.BD_DefDoc_B().GetList("", " AtVal = '" + value.Trim() + "' and AtName='计量单位' and compid=" + this.CompID + " and isnull(dr,0)=0", "", Tran);
if (l.Count == 0)
{
List <Hi.Model.BD_DefDoc> list = new Hi.BLL.BD_DefDoc().GetList("", " AtName='计量单位' and compid=" + this.CompID + " and isnull(dr,0)=0", "", Tran);
int defid = 0;
if (list.Count == 0)
{
Hi.Model.BD_DefDoc doc = new Hi.Model.BD_DefDoc();
doc.CompID = this.CompID;
doc.AtCode = "";
doc.AtName = "计量单位";
doc.ts = DateTime.Now;
doc.modifyuser = this.UserID;
doc.dr = 0;
defid = new Hi.BLL.BD_DefDoc().Add(doc, Tran);
}
else
{
defid = list[0].ID;
}
Hi.Model.BD_DefDoc_B item = new Hi.Model.BD_DefDoc_B();
item.AtVal = value;
item.AtName = "计量单位";
item.CompID = this.CompID;
item.DefID = defid;
item.ts = DateTime.Now;
item.dr = 0;
item.modifyuser = this.UserID;
int count = new Hi.BLL.BD_DefDoc_B().Add(item, Tran);
//if (count == 0)
//{
// JScript.AlertMethod(this, "Excel没有数据，请重新导入", JScript.IconOption.错误, "function(){location.href='ImportGoods.aspx'}");
// throw new ApplicationException("Excel行号为： <i error>" + (index + TitleIndex + 1) + "</i> 的数据有误。" + str + "录入数据库失败，请修改后重新导入。");
//}
}
return(value);
}
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string attrVal = string.Empty; //属性值
string SortIndex = string.Empty; //排序
string str = string.Empty;
string attrNameId = ViewState["attrNameId"].ToString(); //属性名称Id
string attrValId = ViewState["attrValId"].ToString(); //属性值Id
#region 获取页面的值
if (this.txtAtVal.Text != "")
{
attrVal = this.txtAtVal.Text.Trim();
}
if (this.txtSortIndex.Text != "")
{
SortIndex = this.txtSortIndex.Text.Trim();
}
#endregion
#region 判断
if (attrVal == "")
{
str += "- 属性值不能为空。\\r\\n";
}
//if (SortIndex == "")
//{
// str += "- 排序不能为空。\\r\\n";
//}
#endregion
if (str != "")
{
JScript.AlertMsgOne(this, str, JScript.IconOption.错误, 2500);
return;
}
Hi.Model.BD_DefDoc_B attrValModel = new Hi.Model.BD_DefDoc_B();
Hi.Model.BD_DefDoc AttrNameModel = AttrNameBLL.GetModel(Convert.ToInt16(attrNameId));
if (AttrNameModel != null)
{
attrValModel.ID = Convert.ToInt16(attrValId);
attrValModel.DefID = Convert.ToInt16(attrNameId);
attrValModel.AtName = AttrNameModel.AtName;
attrValModel.AtVal = attrVal;
attrValModel.SortIndex = SortIndex;
bool falg = AttrValBLL.Update(attrValModel);
if (falg)
{
JScript.AlertMsgOne(this, "数据修改成功！", JScript.IconOption.笑脸);
AttrValBind(attrNameId, 1);
Clear();
//日志
// Hi.Model.A_AdminUser UModel = Session["AdminUser"] as Hi.Model.A_AdminUser;
//Utils.EditLog("用户" + this.UserName + "修改属性值成功", ID, "属性名称模块", "SysManager/AttrManager.aspx", 1);
}
else
{
JScript.AlertMsgOne(this, "数据修改失败", JScript.IconOption.错误, 2500);
}
}
else
{
JScript.AlertMsgOne(this, "属性名称不存在", JScript.IconOption.错误, 2500);
}
}
/// <summary>
/// 添加费用科目
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected string AddFykm(string unit)
{
SqlTransaction Tran = null;
try
{
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
//新增数据字典
Hi.Model.BD_DefDoc doc = new Hi.Model.BD_DefDoc();
doc.CompID = this.CompID;
doc.AtCode = "";
doc.AtName = "费用科目";
doc.ts = DateTime.Now;
doc.modifyuser = UserID;
doc.dr = 0;
List <Hi.Model.BD_DefDoc> ll = new Hi.BLL.BD_DefDoc().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and atname='费用科目'", "");
int defid = 0;
if (ll.Count == 0)
{
defid = new Hi.BLL.BD_DefDoc().Add(doc, Tran);
}
else
{
defid = ll[0].ID;
}
if (defid != 0)
{
Hi.Model.BD_DefDoc_B doc2 = new Hi.Model.BD_DefDoc_B();
doc2.CompID = this.CompID;
doc2.DefID = defid;
doc2.AtName = "费用科目";
doc2.AtVal = unit; //txtunits.Value.Trim();
doc2.ts = DateTime.Now;
doc2.dr = 0;
doc2.modifyuser = this.UserID;
List <Hi.Model.BD_DefDoc_B> lll = new Hi.BLL.BD_DefDoc_B().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and atname='费用科目' and defid=" + defid + " and atval='" + unit + "'", "");
if (lll.Count == 0)
{
new Hi.BLL.BD_DefDoc_B().Add(doc2, Tran);
}
else
{
return("[{\"AtVal\":\"ycz\"}]");
}
}
Tran.Commit();
List <Hi.Model.BD_DefDoc> l = new Hi.BLL.BD_DefDoc().GetList("", "AtName='费用科目' and compid=" + this.CompID + " and isnull(dr,0)=0", "");
if (l.Count > 0)
{
List <Hi.Model.BD_DefDoc_B> llll = new Hi.BLL.BD_DefDoc_B().GetList("", "DefID=" + l[0].ID + "and ISNULL(dr,0)=0 and compid=" + this.CompID, "id desc");
if (llll.Count > 0)
{
DataTable dt = Common.FillDataTable(llll);
if (dt.Rows.Count != 0)
{
return(ConvertJson.ToJson(dt));
}
}
}
return("[{\"AtVal\":\"cc\"}]");
// this.txtunit.Value = unit;
}
catch (Exception)
{
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
return("[{\"AtVal\":\"sb\"}]");
}
finally
{
DBUtility.SqlHelper.ConnectionClose();
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.BD_DefDoc model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.BD_DefDoc model)
{
return(dal.Add(model));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (KeyID > 0)
{
bool Audit = false;
Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(KeyID);
if (comp != null)
{
if (comp.dr == 1)
{
JScript.AlertMsg(this, "厂商不存在！。");
return;
}
string str = string.Empty;
SqlTransaction Tran = null;
try
{
if (comp.AuditState == 2)
{
Audit = true;
}
if (Common.CompExistsAttribute("CompName", txtCompName.Value.Trim(), KeyID.ToString()))
{
JScript.AlertMsg(this, "该厂商名称已存在。");
return;
}
string CompAddr = hidProvince.Value.Trim();
if (!string.IsNullOrWhiteSpace(hidCity.Value.Trim()) && hidCity.Value.Trim() != "选择市")
{
CompAddr += "-" + hidCity.Value.Trim();
}
if (!string.IsNullOrWhiteSpace(hidArea.Value.Trim()) && hidArea.Value.Trim() != "选择区")
{
CompAddr += "-" + hidArea.Value.Trim();
}
comp.CompAddr = CompAddr;
comp.CompName = Common.NoHTML(txtCompName.Value.Trim());
comp.Capital = Capital.Value.Trim();
comp.CompType = Convert.ToInt32(CompType.SelectedValue);
comp.Tel = Common.NoHTML(txtTel.Value.Trim());
if (txtPrincipal.Value.Trim() != "")
{
comp.Principal = Common.NoHTML(txtPrincipal.Value.Trim());
}
else
{
comp.Principal = Common.NoHTML(txtUserTrueName.Value.Trim());
}
comp.Legal = Common.NoHTML(txtLegal.Value.Trim());
if (txtPhone.Value.Trim() != "")
{
comp.Phone = Common.NoHTML(txtPhone.Value.Trim());
}
else
{
comp.Phone = Common.NoHTML(txtUserPhone.Value.Trim());
}
comp.ShortName = Common.NoHTML(txtShotName.Value.Trim());
comp.Zip = Common.NoHTML(txtZip.Value.Trim());
comp.Identitys = Common.NoHTML(txtIdentitys.Value.Trim());
comp.Licence = Common.NoHTML(txtLicence.Value.Trim());
comp.LegalTel = Common.NoHTML(txtLegalTel.Value.Trim());
comp.ManageInfo = Common.NoHTML(txtInfo.Value.Trim());
comp.Fax = Common.NoHTML(txtFax.Value.Trim());
comp.Account = Common.NoHTML(txtAccount.Value.Trim());
comp.Address = Common.NoHTML(txtAddress.Value.Trim());
comp.IndID = txtIndusName.SelectedValue.ToInt(0);
comp.Trade = txtIndusName.Items[txtIndusName.SelectedIndex].Text;
comp.AuditState = 2;
comp.AuditDate = DateTime.Now;//add by hgh 审核日期
comp.AuditUser = UserID.ToString();
comp.ts = DateTime.Now;
comp.modifyuser = UserID;
comp.OrganizationCode = Common.NoHTML(txtOrcode.Value.Trim());
comp.IsEnabled = rdEbleYes.Checked ? 1 : 0;
comp.HotShow = rdHotShowYes.Checked ? 1 : 0;
comp.FirstShow = Convert.ToInt32(ddlChkShow.SelectedValue);// rdFirstShowYes.Checked ? 1 : 0;
comp.Remark = Common.NoHTML(txtRemark.Value.Trim());
comp.Erptype = ddlErptype.SelectedValue.ToInt(0);
//企业编号 add by hgh
comp.CompCode = Common.CreateCode(KeyID);
if (HidFfileName.Value != "")
{
if (string.IsNullOrEmpty(comp.Attachment))
{
comp.Attachment = HidFfileName.Value;
}
else
{
comp.Attachment += "," + HidFfileName.Value;
}
}
List <Hi.Model.SYS_CompUser> ListComp = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and Ctype=1 and Utype=4 and CompID=" + KeyID + "", "");
if (ListComp.Count > 0)
{
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
Audit = ListComp[0].IsAudit == 2;
if (Audit)
{
List <Hi.Model.BD_Distributor> dis = new Hi.BLL.BD_Distributor().GetList("", " isnull(dr,0)=0 and compid=" + KeyID + "", "");
foreach (Hi.Model.BD_Distributor model2 in dis)
{
model2.IsEnabled = comp.IsEnabled;
model2.ts = DateTime.Now;
model2.modifyuser = UserID;
new Hi.BLL.BD_Distributor().Update(model2, Tran);
}
new Hi.BLL.BD_Company().Update(comp, Tran);
List <Hi.Model.SYS_Users> user = new Hi.BLL.SYS_Users().GetList("", " isnull(dr,0)=0 and id=" + ListComp[0].UserID + " ", "");
if (user.Count > 0)
{
user[0].TrueName = Common.NoHTML(txtUserTrueName.Value.Trim());
user[0].ts = DateTime.Now;
user[0].modifyuser = UserID;
new Hi.BLL.SYS_Users().Update(user[0], Tran);
}
Tran.Commit();
Response.Redirect("CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=5", false);
}
else
{
if (UserType == 3 || UserType == 4)
{
comp.OrgID = OrgID;
comp.SalesManID = SalesManID;
}
if ((new Hi.BLL.BD_Company().Update(comp, Tran)))
{
//新增数据字典
Hi.Model.BD_DefDoc doc = new Hi.Model.BD_DefDoc();
doc.CompID = KeyID;
doc.AtCode = "";
doc.AtName = "计量单位";
doc.ts = DateTime.Now;
doc.modifyuser = UserID;
doc.dr = 0;
List <Hi.Model.BD_DefDoc> ll = new Hi.BLL.BD_DefDoc().GetList("", "isnull(dr,0)=0 and compid=" + KeyID + " and atname='计量单位'", "", Tran);
if (ll.Count == 0)
{
new Hi.BLL.BD_DefDoc().Add(doc, Tran);
}
//代理商加盟是否需要审核
Hi.Model.SYS_SysName sysname = new Hi.Model.SYS_SysName();
sysname.CompID = KeyID;
sysname.Code = "";
sysname.Name = "代理商加盟是否需要审核";
sysname.Value = "0";
sysname.ts = DateTime.Now;
sysname.modifyuser = UserID;
List <Hi.Model.SYS_SysName> sysl = new Hi.BLL.SYS_SysName().GetList("", "Name='代理商加盟是否需要审核' and CompID=" + KeyID, "", Tran);
if (sysl != null && sysl.Count == 0)
{
new Hi.BLL.SYS_SysName().Add(sysname, Tran);
}
//费用科目
Hi.Model.BD_DefDoc doc1 = new Hi.Model.BD_DefDoc();
doc1.CompID = KeyID;
doc1.AtCode = "";
doc1.AtName = "费用科目";
doc1.ts = DateTime.Now;
doc1.modifyuser = UserID;
doc1.dr = 0;
List <Hi.Model.BD_DefDoc> ll1 = new Hi.BLL.BD_DefDoc().GetList("", "isnull(dr,0)=0 and compid=" + KeyID + " and atname='费用科目'", "", Tran);
if (ll1.Count == 0)
{
new Hi.BLL.BD_DefDoc().Add(doc1, Tran);
}
doc.CompID = KeyID;
doc.AtCode = "";
doc.AtName = "代理商等级";
doc.ts = DateTime.Now;
doc.modifyuser = UserID;
doc.dr = 0;
List <Hi.Model.BD_DefDoc> lll = new Hi.BLL.BD_DefDoc().GetList("", "isnull(dr,0)=0 and compid=" + KeyID + " and atname='代理商等级'", "", Tran);
if (lll.Count == 0)
{
new Hi.BLL.BD_DefDoc().Add(doc, Tran);
}
List <Hi.Model.SYS_Role> l = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and isenabled=1 and compid=" + KeyID + " and RoleName='企业管理员'", "");
if (l.Count == 0)
{
//新增角色（企业管理员）
Hi.Model.SYS_Role role = new Hi.Model.SYS_Role();
role.CompID = KeyID;
role.RoleName = "企业管理员";
role.IsEnabled = 1;
role.SortIndex = "1";
role.CreateDate = DateTime.Now;
role.CreateUserID = UserID;
role.ts = DateTime.Now;
role.modifyuser = UserID;
role.dr = 0;
int Roid = new Hi.BLL.SYS_Role().Add(role, Tran);
//新增角色用户
Hi.Model.SYS_RoleUser RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = ListComp[0].UserID;
RoleUser.RoleID = Roid;
RoleUser.IsEnabled = true;
RoleUser.CreateUser = this.UserID.ToString();
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
new Hi.BLL.SYS_RoleUser().Add(RoleUser, Tran);
//修改用户对应的角色
List <Hi.Model.SYS_Users> ListUser = new Hi.BLL.SYS_Users().GetList("", " isnull(dr,0)=0 and id=" + ListComp[0].UserID + " ", "");
if (ListUser.Count > 0)
{
ListUser[0].TrueName = Common.NoHTML(txtUserTrueName.Value.Trim());
ListUser[0].ts = DateTime.Now;
ListUser[0].modifyuser = UserID;
ListUser[0].AuditState = 2;
new Hi.BLL.SYS_Users().Update(ListUser[0], Tran);
}
ListComp[0].IsAudit = 2;
ListComp[0].modifyuser = UserID;
ListComp[0].ts = DateTime.Now;
ListComp[0].RoleID = Roid;
new Hi.BLL.SYS_CompUser().Update(ListComp[0], Tran);
Hi.Model.BD_CompNews CNew = new Hi.Model.BD_CompNews();
CNew.NewsTitle = "欢迎登录" + ConfigurationManager.AppSettings["PhoneSendName"].ToString() + "平台";
CNew.NewsContents = "”" + ConfigurationManager.AppSettings["PhoneSendName"].ToString() + "”平台为企业和代理商之间搭建了电子商务平台，通过企业入驻及代理商的加盟，形成覆盖全行业的线上销售网络。同时，充分利用平台信息化整合优势，帮助入驻企业销售模式电商化改造，以及为代理商信息化建设提供有力支持。另外，还将为供应链上的相关各方提供全渠道的结算服务以及授信融资等多项互联网金融服务。";
CNew.IsEnabled = 1;
CNew.IsTop = 0;
CNew.NewsType = 2;
CNew.ShowType = "1,2";
CNew.CompID = KeyID;
CNew.CreateDate = DateTime.Now;
CNew.CreateUserID = UserID;
CNew.ts = DateTime.Now;
CNew.modifyuser = UserID;
new Hi.BLL.BD_CompNews().Add(CNew, Tran);
//新增角色权限表
Hi.Model.SYS_RoleSysFun rolesys = null;
//add by hgh 增加了：and funcode<>'1030'
List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("", " Type=1 and funcode<>'1030'", "");
foreach (Hi.Model.SYS_SysFun sys in funList)
{
rolesys = new Hi.Model.SYS_RoleSysFun();
rolesys.CompID = KeyID;
rolesys.RoleID = Roid;
rolesys.FunCode = sys.FunCode;
rolesys.FunName = sys.FunName;
rolesys.IsEnabled = 1;
rolesys.CreateUserID = UserID;
rolesys.CreateDate = DateTime.Now;
rolesys.ts = DateTime.Now;
rolesys.modifyuser = UserID;
new Hi.BLL.SYS_RoleSysFun().Add(rolesys, Tran);
}
//新增代理商分类
Hi.Model.BD_DisType distype = new Hi.Model.BD_DisType();
distype.CompID = KeyID;
distype.TypeName = "全部";
distype.ParentId = 0;
distype.TypeCode = "1001";
distype.SortIndex = "1000";
distype.IsEnabled = 0;
distype.CreateUserID = UserID;
distype.CreateDate = DateTime.Now;
distype.ts = DateTime.Now;
distype.modifyuser = UserID;
distype.dr = 0;
new Hi.BLL.BD_DisType().Add(distype, Tran);
Tran.Commit();
//审核成功 添加一条默认的商品分类 -开始
string Typecode = "";//商品大类
//Hi.Model.SYS_GType gtype = new Hi.BLL.SYS_GType().GetList(" top 1 *", " Deep=3 and FullCode like '"+ Typecode + "-%' and IsEnabled=1 and dr=0 ", " parentid,ID")[0];
//Hi.Model.BD_GoodsCategory DisType = new Hi.Model.BD_GoodsCategory();
//DisType.Code = NewCategoryCode("1");
//DisType.Deep = 1;
//DisType.ParCode = "";
//DisType.ParentId = 0;
//DisType.CompID = KeyID;
//DisType.CategoryName = "默认";
//DisType.GoodsTypeID = gtype.ID;
//DisType.SortIndex = "1000";
//DisType.CreateDate = DateTime.Now;
//DisType.CreateUserID = 0;
//DisType.IsEnabled = 1;
//DisType.ts = DateTime.Now;
//DisType.modifyuser = 0;
//SqlTransaction trans = SqlHelper.CreateStoreTranSaction();
//try
//{
// int countID = 0;
// if ((countID = new Hi.BLL.BD_GoodsCategory().Add(DisType, trans)) > 0)
// {
// List<Hi.Model.BD_Goods> gList = new Hi.BLL.BD_Goods().GetList("", " CategoryID=''", "");
// if (gList != null && gList.Count > 0)
// {
// foreach (var bdGoodse in gList)
// {
// bdGoodse.CategoryID = countID;
// new Hi.BLL.BD_Goods().Update(bdGoodse, trans);
// }
// }
// trans.Commit();
// }
//}
//catch (Exception ex)
//{
// Tiannuo.LogHelper.LogHelper.Error("Error", ex);
// if (trans != null)
// {
// if (trans.Connection != null)
// {
// trans.Rollback();
// }
// }
// return;
//}
//finally
//{
// SqlHelper.ConnectionClose();
// if (trans != null)
// {
// if (trans.Connection != null)
// {
// trans.Connection.Close();
// }
// }
//}
//审核成功 添加一条默认的商品分类 -结束
DBUtility.GetPhoneCode getphonecode = new DBUtility.GetPhoneCode();
str = getphonecode.ReturnSTRS(ListUser[0].Phone, comp.CompName, ListUser[0].UserName);
if (str != "Success")
{
JScript.AlertMsgMo(this, "审核通过的通知短信发送失败！请自行发送短信通知企业。", "function(){ window.location.href='CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=" + Request.QueryString["type"] + "" + "'; }");
}
else
{
JScript.AlertMsgMo(this, "审核成功", "function(){ window.location.href='CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=5'; }");
}
}
else
{
ListComp[0].IsAudit = 2;
ListComp[0].modifyuser = UserID;
ListComp[0].ts = DateTime.Now;
new Hi.BLL.SYS_CompUser().Update(ListComp[0], Tran);
Hi.Model.SYS_Users user = null;
List <Hi.Model.SYS_CompUser> User2 = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and utype=4 and CompID=" + KeyID + "", "");
if (User2.Count > 0)
{
user = new Hi.BLL.SYS_Users().GetModel(User2[0].UserID);
}
Tran.Commit();
// 发短信通知
DBUtility.GetPhoneCode getphonecode = new DBUtility.GetPhoneCode();
getphonecode.GetUser(ConfigurationManager.AppSettings["PhoneCodeAccount"].ToString(), ConfigurationManager.AppSettings["PhoneCodePwd"].ToString());
str = getphonecode.ReturnSTRS(user.Phone, comp.CompName, user.UserName);
if (str != "Success")
{
JScript.AlertMsgMo(this, "审核通过的通知短信发送失败！请自行发送短信通知企业。", "function(){ window.location.href='CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=" + Request.QueryString["type"] + "" + "'; }");
}
else
{
JScript.AlertMsgMo(this, "审核成功", "function(){ window.location.href='CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=5'; }");
}
}
}
}
}
else
{
JScript.AlertMsg(this, "用户明细数据异常！。");
return;
}
}
catch (Exception ex)
{
Tiannuo.LogHelper.LogHelper.Error("Error", ex);
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
JScript.AlertMsgMo(this, "审核失败", "function(){ window.location.href=window.location.href; }");
}
finally
{
DBUtility.SqlHelper.ConnectionClose();
}
}
else
{
JScript.AlertMsg(this, "厂商不存在！。");
return;
}
//cust by ggh 20180327 begin 审核通过时，默认给核心企业设置手续费
Settings(KeyID);
//cust by ggh 20180327 end 审核通过时，默认给核心企业设置手续费
}
else
{
if (Common.GetUserExists(txtUsername.Value.Trim()))
{
JScript.AlertMsg(this, "该登录帐号已存在。");
return;
}
if (Common.CompExistsAttribute("CompName", txtCompName.Value.Trim()))
{
JScript.AlertMsg(this, "该厂商名称已存在。");
return;
}
Regex Phonereg = new Regex("^0?1[0-9]{10}$");
if (!Phonereg.IsMatch(txtUserPhone.Value.Trim()))
{
JScript.AlertMsg(this, "手机号码格式错误！");
return;
}
if (Common.GetUserExists("Phone", txtUserPhone.Value.Trim()))
{
JScript.AlertMsg(this, "手机号码已被注册！");
return;
}
Hi.Model.BD_Company comp = new Hi.Model.BD_Company();
if (UserType == 3 || UserType == 4)
{
comp.OrgID = OrgID;
comp.SalesManID = SalesManID;
}
comp.CompName = Common.NoHTML(txtCompName.Value.Trim());
comp.Capital = Capital.Value.Trim();
comp.CompType = Convert.ToInt32(CompType.SelectedValue);
comp.Tel = Common.NoHTML(txtTel.Value.Trim());
if (txtPrincipal.Value.Trim() != "")
{
comp.Principal = Common.NoHTML(txtPrincipal.Value.Trim());
}
else
{
comp.Principal = Common.NoHTML(txtUserTrueName.Value.Trim());
}
comp.Legal = Common.NoHTML(txtLegal.Value.Trim());
comp.LegalTel = Common.NoHTML(txtLegalTel.Value.Trim());
if (txtPhone.Value.Trim() != "")
{
comp.Phone = Common.NoHTML(txtPhone.Value.Trim());
}
else
{
comp.Phone = Common.NoHTML(txtUserPhone.Value.Trim());
}
comp.ShortName = Common.NoHTML(txtShotName.Value.Trim());
comp.Zip = Common.NoHTML(txtZip.Value.Trim());
comp.Identitys = Common.NoHTML(txtIdentitys.Value.Trim());
comp.Licence = Common.NoHTML(txtLicence.Value.Trim());
comp.ManageInfo = Common.NoHTML(txtInfo.Value.Trim());
comp.Fax = Common.NoHTML(txtFax.Value.Trim());
comp.OrganizationCode = Common.NoHTML(txtOrcode.Value.Trim());
comp.Trade = txtIndusName.Items[txtIndusName.SelectedIndex].Text;
comp.Account = Common.NoHTML(txtAccount.Value.Trim());
comp.Attachment = HidFfileName.Value;
comp.Address = Common.NoHTML(txtAddress.Value.Trim());
comp.CustomCompinfo = "本公司产品种类丰富、质量优良、价格公道、服务周到。感谢您长期的支持与厚爱，您的满意是我们最高的追求，我们将竭诚为您提供优质、贴心的服务！";
string CompAddr = hidProvince.Value.Trim();
if (!string.IsNullOrWhiteSpace(hidCity.Value.Trim()) && hidCity.Value.Trim() != "选择市")
{
CompAddr += "-" + hidCity.Value.Trim();
}
if (!string.IsNullOrWhiteSpace(hidArea.Value.Trim()) && hidArea.Value.Trim() != "选择区")
{
CompAddr += "-" + hidArea.Value.Trim();
}
comp.CompAddr = CompAddr;
comp.IndID = txtIndusName.SelectedValue.ToInt(0);
comp.CreateDate = DateTime.Now;
comp.CreateUserID = UserID;
comp.ts = DateTime.Now;
comp.modifyuser = UserID;
comp.IsEnabled = rdEbleYes.Checked ? 1 : 0;
comp.HotShow = rdHotShowYes.Checked ? 1 : 0;
comp.FirstShow = Convert.ToInt32(ddlChkShow.SelectedValue);// rdFirstShowYes.Checked ? 1 : 0;
comp.SortIndex = "001";
comp.Remark = Common.NoHTML(txtRemark.Value.Trim());
comp.Erptype = ddlErptype.SelectedValue.ToInt(0);
comp.AuditState = 0;
int comid = 0;
SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
comid = new Hi.BLL.BD_Company().Add(comp, Tran);
comp.CompCode = Common.CreateCode(comid);
comp.ID = comid;
new Hi.BLL.BD_Company().Update(comp, Tran);
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
user.UserName = Common.NoHTML(txtUsername.Value.Trim());
user.TrueName = Common.NoHTML(txtUserTrueName.Value.Trim());
user.UserPwd = Util.md5(txtUpwd.Text.Trim());
user.Phone = Common.NoHTML(txtUserPhone.Value.Trim());
user.AuditState = 2;
user.IsEnabled = 1;
user.AuditUser = UserID.ToString();
user.CreateUserID = UserID;
user.CreateDate = DateTime.Now;
user.ts = DateTime.Now;
user.modifyuser = UserID;
int userid = 0;
userid = new Hi.BLL.SYS_Users().Add(user, Tran);
Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = comid;
CompUser.DisID = 0;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = UserID;
CompUser.modifyuser = UserID;
CompUser.CType = 1;
CompUser.UType = 4;
CompUser.IsEnabled = 1;
CompUser.IsAudit = 0;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = userid;
new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
Tran.Commit();
Response.Redirect("CompInfo.aspx?go=1&KeyID=" + comid, false);
}
}