/// <summary>
/// 保存公司信息
/// </summary>
/// <param name="Type">空=A,新增建筑=B,新增房间=H</param>
/// <param name="PCoChk">父ID号</param>
/// <param name="v1_CustInfo">Co_id主键ID:0新增,CoName:客户名称,Parent_id:父ID号,Disabled:是否弃用0否1是,CustAddr:客户地址,Office_tel:办公电话,Mobile:移动电话,Email,IsDefine:定义属性默认0</param>
/// <returns></returns>
public APIRst SetSaveCo(string Type, int PCoChk, v1_custInfoVModel v1_CustInfo)
{
APIRst rst = new APIRst();
try
{
if (Type == "A")
{
v1_CustInfo.Attrib = 0;
}
if (Type == "B")
{
v1_CustInfo.Attrib = 100;
}
if (Type == "H")
{
v1_CustInfo.Attrib = 9000;
}
if (PCoChk == 0 && v1_CustInfo.Co_id == 0)
{
v1_CustInfo.Parent_id = 0;
}
if (PCoChk == 1 && v1_CustInfo.Parent_id == 0)
{
throw new Exception("父ID号错误");
}
var sameNameCoid = CommFunc.ConvertDBNullToInt32(bll.IsExistSameYdCustName(v1_CustInfo.CoName));
if ((v1_CustInfo.Co_id == 0 && sameNameCoid > 0) || (v1_CustInfo.Co_id > 0 && sameNameCoid != 0 && sameNameCoid != v1_CustInfo.Co_id))
{
throw new Exception("该用户名称已经存在");
}
bll.SetCustInfo(v1_CustInfo);
VEasyUiTree tInfo = new VEasyUiTree();
tInfo.id = v1_CustInfo.Co_id.ToString();
tInfo.text = v1_CustInfo.CoName;
//object obj = new { total = dtSource.Rows.Count, data = new { tt = tInfo, pid = cust.Parent_id } };
rst.data = new { tt = tInfo, pid = v1_CustInfo.Parent_id };
}
catch (Exception ex)
{
rst.rst = false;
rst.err.code = (int)ResultCodeDefine.Error;
rst.err.msg = ex.Message;
FileLog.WriteLog("修改组织信息错误:" + ex.Message + ex.StackTrace);
}
return(rst);
}
/// <summary>
/// 新增修改用户
/// </summary>
/// <param name="cust"></param>
/// <returns></returns>
public int SetCustInfo(v1_custInfoVModel cust)
{
return(dal.SetCustInfo(cust));
}
/// <summary>
/// 新增修改客户信息
/// </summary>
/// <param name="cust"></param>
/// <returns></returns>
public int SetCustInfo(v1_custInfoVModel cust)
{
StringBuilder strSql = new StringBuilder();
strSql.Clear();
DataTable obj = new DataTable();
if (cust.Co_id == 0)
{
strSql.Clear();
strSql.Append("select Co_id from v1_cust where Ledger=@Ledger and Parent_id=@Parent_id and CoName=@CoName");
obj = SQLHelper.Query(strSql.ToString(), new { Ledger = this.Ledger, Parent_id = cust.Parent_id, CoName = cust.CoName });
if (obj.Rows.Count > 0)
{
throw new Exception("名称:" + cust.CoName + "已经在本区域中存在，请检查后使用。");
}
obj = null;
strSql.Clear();
strSql.Append("select Layer from v1_cust where Ledger=@Ledger and Co_id=@Parent_id");
obj = SQLHelper.Query(strSql.ToString(), new { Ledger = this.Ledger, Parent_id = cust.Parent_id });
cust.Layer = obj.Rows.Count > 0 ? CommFunc.ConvertDBNullToInt32(obj.Rows[0]["Layer"]) + 1 : 0;
obj = null;
strSql.Clear();
strSql.Append("select max(Co_id) as Co_id from v1_cust where Ledger=@Ledger");
obj = SQLHelper.Query(strSql.ToString(), new { Ledger = this.Ledger });
cust.Co_id = obj.Rows.Count > 0 ? CommFunc.ConvertDBNullToInt32(obj.Rows[0]["Co_id"]) + 1 : 1;
//cust.Co_id = CommFunc.ConvertDBNullToInt32(obj.Rows[0]["Co_id"]) + 1;
strSql.Clear();
strSql.Append("insert into v1_cust(");
strSql.Append("Ledger,Co_id,CoNo,CoName,Disabled,Parent_id,Attrib,Layer,Create_by,Create_dt,Update_by,Update_dt)");
strSql.Append(" values (");
strSql.Append("@Ledger,@Co_id,@Co_id,@CoName,@Disabled,@Parent_id,@Attrib,@Layer,@SysUid,now(),@SysUid,now());");
}
else
{
strSql.Append("update v1_cust set ");
//strSql.Append("CoNo=@CoNo,");
strSql.Append("CoName=@CoName,");
strSql.Append("Disabled=@Disabled,");
strSql.Append("Parent_id=@Parent_id,");
strSql.Append("Attrib=@Attrib,");
strSql.Append("Update_by=@SysUid,");
strSql.Append("Update_dt=now()");
strSql.Append(" where Ledger=@Ledger and Co_id=@Co_id;");
}
strSql.Append("insert into v1_custinfo(");
strSql.Append("Ledger,Co_id,CustAddr,Office_tel,Mobile,Email,IsDefine,Update_by,Update_dt)");
strSql.Append(" values (");
strSql.Append("@Ledger,@Co_id,@CustAddr,@Office_tel,@Mobile,@Email,@IsDefine,@SysUid,now())");
strSql.Append(" ON DUPLICATE KEY UPDATE ");
strSql.Append("CustAddr=@CustAddr,");
strSql.Append("Office_tel=@Office_tel,");
strSql.Append("Mobile=@Mobile,");
strSql.Append("Email=@Email,");
strSql.Append("IsDefine=@IsDefine,");
strSql.Append("Update_by=@SysUid,");
strSql.Append("Update_dt=now(); ");
// 更新全名
strSql.Append("update v1_cust as a,v1_custinfo as b set b.StrucName=GetCoOnStrucName(a.Ledger,a.Co_id)");
strSql.Append(" where a.Ledger=b.Ledger and a.Co_id=b.Co_id and a.Ledger=@Ledger and FIND_IN_SET(a.Co_id,GetCoChildList(a.Ledger,@Co_id));");
//return 1;
return(SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Co_id = cust.Co_id, CoName = cust.CoName, Disabled = cust.Disabled, Parent_id = cust.Parent_id, Attrib = cust.Attrib, Layer = cust.Layer, SysUid = this.SysUid, CustAddr = cust.CustAddr, Office_tel = cust.Office_tel, Mobile = cust.Mobile, Email = cust.Email, IsDefine = cust.IsDefine }));
}
public APIRst SetSaveCo(string Type, int PCoChk, v1_custInfoVModel v1_CustInfo)
{
return(infoHelper.SetSaveCo(Type, PCoChk, v1_CustInfo));
}
