public static string AddUserPortrait(P_Sys_UserPortraitModel model)
{
//string remark = ",";
//if (!string.IsNullOrEmpty(model.RemarkContent1))
//{
// int reVal1 = UserPortraitBLL.AddRemark(model.RemarkType1, model.RemarkContent1);
// if (reVal1 > 0)
// {
// remark += reVal1.ToString() + ",";
// }
//}
//if (!string.IsNullOrEmpty(model.RemarkContent2))
//{
// int reVal2 = UserPortraitBLL.AddRemark(model.RemarkType2, model.RemarkContent2);
// if (reVal2 > 0)
// {
// remark += reVal2.ToString() + ",";
// }
//}
//if (remark.Length > 1)
//{
// model.RemarkId = remark;
//}
//用户拓展信息保留一个备注
model.RemarkId = model.RemarkContent1;
return(UserPortraitBLL.AddUserPortrait(model));
}
public string AddUserPortrait(P_Sys_UserPortraitModel model)
{
return(UserPortrait.AddUserPortrait(model));
}
public string AddUserPortrait(P_Sys_UserPortraitModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from P_Sys_UserPortrait where AccId=@accid;");
int count = DapperHelper.ExecuteScalar <int>(strSql.ToString(), new { accid = model.AccId });
strSql.Clear();
if (count == 0)
{
strSql.Append("insert into P_Sys_UserPortrait (" +
" InsertTime," +
" AccId," +
" Industry," +
" UserSourcePortrait," +
" ChoiceReason," +
" CompetingProduct," +
" PotentialNeed," +
" Attitude," +
" BusinessExp," +
" PhoneNum," +
" QQNum," +
" AgeGrade," +
" Gender," +
" WebExpGrade," +
" SalesmanNum," +
" RealName," +
" Email," +
" Weixin," +
" IdCardNo," +
" InvoiceTitle," +
" ShopAddress," +
" BranchNum," +
" RemarkId,MainQuestion) values(" +
" @InsertTime," +
" @AccId," +
" @Industry," +
" @UserSourcePortrait," +
" @ChoiceReason," +
" @CompetingProduct," +
" @PotentialNeed," +
" @Attitude," +
" @BusinessExp," +
" @PhoneNum," +
" @QQNum," +
" @AgeGrade," +
" @Gender," +
" @WebExpGrade," +
" @SalesmanNum," +
" @RealName," +
" @Email," +
" @Weixin," +
" @IdCardNo," +
" @InvoiceTitle," +
" @ShopAddress," +
" @BranchNum," +
" @RemarkId,@MainQuestion);");
try
{
int reVal = DapperHelper.Execute(strSql.ToString(), new
{
InsertTime = DateTime.Now,
AccId = model.AccId,
Industry = model.Industry,
UserSourcePortrait = model.UserSourcePortrait,
ChoiceReason = model.ChoiceReason,
CompetingProduct = model.CompetingProduct,
PotentialNeed = model.PotentialNeed,
Attitude = model.Attitude,
BusinessExp = model.BusinessExp,
PhoneNum = model.PhoneNum,
QQNum = model.QQNum,
AgeGrade = model.AgeGrade,
Gender = model.Gender,
WebExpGrade = model.WebExpGrade,
SalesmanNum = model.SalesmanNum,
RealName = model.RealName,
Email = model.Email,
Weixin = model.Weinxin,
IdCardNo = model.IdCardNo,
InvoiceTitle = model.InvoiceTitle,
ShopAddress = model.ShopAddress,
BranchNum = model.BranchNum,
RemarkId = model.RemarkId,
MainQuestion = model.MainQuestion
});
if (reVal > 0)
{
return("");
}
else
{
return("err");
}
}
catch (Exception ex)
{
return("err");
}
}
else
{
strSql.Append("update P_Sys_UserPortrait set " +
" InsertTime=@insertTime," +
" Industry=@industry," +
" UserSourcePortrait=@userSource," +
" ChoiceReason=@choiceReason," +
" CompetingProduct=@competingProduct," +
" PotentialNeed=@potentialNeed," +
" Attitude=@attitude," +
" BusinessExp=@business," +
" PhoneNum=@phone," +
" QQNum=@qq," +
" AgeGrade=@ageGrade," +
" Gender=@gender," +
" WebExpGrade=@webExpGrade," +
" SalesmanNum=@salemanNum," +
" RealName=@RealName," +
" Email=@Email," +
" Weixin=@Weixin," +
" IdCardNo=@IdCardNo," +
" InvoiceTitle=@InvoiceTitle," +
" ShopAddress=@ShopAddress," +
" BranchNum=@BranchNum," +
" RemarkId=@remarkId,MainQuestion=@MainQuestion where AccId=@accid;");
try
{
int reVal = DapperHelper.Execute(strSql.ToString(), new
{
insertTime = DateTime.Now,
industry = model.Industry,
userSource = model.UserSourcePortrait,
choiceReason = model.ChoiceReason,
competingProduct = model.CompetingProduct,
potentialNeed = model.PotentialNeed,
attitude = model.Attitude,
business = model.BusinessExp,
phone = model.PhoneNum,
qq = model.QQNum,
ageGrade = model.AgeGrade,
gender = model.Gender,
webExpGrade = model.WebExpGrade,
salemanNum = model.SalesmanNum,
remarkId = model.RemarkId,
RealName = model.RealName,
Email = model.Email,
Weixin = model.Weinxin,
IdCardNo = model.IdCardNo,
InvoiceTitle = model.InvoiceTitle,
ShopAddress = model.ShopAddress,
BranchNum = model.BranchNum,
accid = model.AccId,
MainQuestion = model.MainQuestion
});
if (reVal > 0)
{
return("");
}
else
{
return("err");
}
}
catch (Exception ex)
{
return("err");
}
}
}
public static string AddUserPortrait(P_Sys_UserPortraitModel model)
{
UserPortraitDAL dal = new UserPortraitDAL();
return(dal.AddUserPortrait(model));
}