/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.CustomerData DataRowToModel(DataRow row)
{
Maticsoft.Model.CustomerData model=new Maticsoft.Model.CustomerData();
if (row != null)
{
if(row["PhoneNumber"]!=null)
{
model.PhoneNumber=row["PhoneNumber"].ToString();
}
if(row["CustomerName"]!=null)
{
model.CustomerName=row["CustomerName"].ToString();
}
if(row["Address"]!=null)
{
model.Address=row["Address"].ToString();
}
if(row["MiAvailable"]!=null && row["MiAvailable"].ToString()!="")
{
model.MiAvailable=int.Parse(row["MiAvailable"].ToString());
}
if(row["JingAvailable"]!=null && row["JingAvailable"].ToString()!="")
{
model.JingAvailable=int.Parse(row["JingAvailable"].ToString());
}
if(row["ZhunAvailable"]!=null && row["ZhunAvailable"].ToString()!="")
{
model.ZhunAvailable=int.Parse(row["ZhunAvailable"].ToString());
}
if(row["BaoAvaivable"]!=null && row["BaoAvaivable"].ToString()!="")
{
model.BaoAvaivable=int.Parse(row["BaoAvaivable"].ToString());
}
if(row["GiftPacks"]!=null && row["GiftPacks"].ToString()!="")
{
model.GiftPacks=int.Parse(row["GiftPacks"].ToString());
}
if(row["ProductPacks"]!=null && row["ProductPacks"].ToString()!="")
{
model.ProductPacks=int.Parse(row["ProductPacks"].ToString());
}
}
return model;
}
public List<string> ReciveMsg(string phonenumber, string codes, Hashtable HtCustomer, Hashtable HtCode)
{
List<string> msg = new List<string>();
ReciveMsgDAL dal = new ReciveMsgDAL();
List<string> RightCodes;//正确代码
List<string> WrongFormatCode;//格式错误代码
List<string> ExchangedCode;//已兑换代码
List<string> NoexistCode;//不存在代码
List<string> ValidatedCode;//已验证代码
checkCode(codes, HtCode, out RightCodes, out WrongFormatCode, out ExchangedCode, out NoexistCode, out ValidatedCode);
using (System.Transactions.TransactionScope tsCope = new TransactionScope(TransactionScopeOption.RequiresNew, new TimeSpan(0, 30, 0)))
{
try
{
if (RightCodes.Count > 0)//代码正确
{
string[] rightcode = RightCodes.ToArray();
for (int i = 0; i < rightcode.Length; i++)
{
//更新CodeData表
Maticsoft.Model.CodeData CodeDataModel = HtCode[rightcode[i]] as Maticsoft.Model.CodeData;
CodeDataModel.PhoneNumber = phonenumber;
CodeDataModel.IsValidated = true;
CodeDataModel.ValidatedTime = DateTime.Now;
CodeDatadal.Update(CodeDataModel);
//CustomerData存在兑奖者记录
if (HtCustomer.Contains(phonenumber))
{
Maticsoft.Model.CustomerData CustomerDataModel = HtCustomer[phonenumber] as Maticsoft.Model.CustomerData;
if (CodeDataModel.Remark == "密")
{
CustomerDataModel.MiAvailable += 1;
}
else if (CodeDataModel.Remark == "净")
{
CustomerDataModel.JingAvailable += 1;
}
else if (CodeDataModel.Remark == "准")
{
CustomerDataModel.ZhunAvailable += 1;
}
else if (CodeDataModel.Remark == "宝护盖")
{
CustomerDataModel.BaoAvaivable += 1;
}
CustomerDatadal.Update(CustomerDataModel);//更新可兑换信息
}
else //CustomerData不存在兑奖者记录
{
Maticsoft.Model.CustomerData CustomerDataModel = new Maticsoft.Model.CustomerData();
CustomerDataModel.PhoneNumber = phonenumber;
CustomerDataModel.BaoAvaivable = 0;
CustomerDataModel.ZhunAvailable = 0;
CustomerDataModel.JingAvailable = 0;
CustomerDataModel.MiAvailable = 0;
CustomerDataModel.ProductPacks = 0;
CustomerDataModel.GiftPacks = 0;
CustomerDataModel.Address = "";
CustomerDataModel.CustomerName = "";
if (CodeDataModel.Remark == "密")
{
CustomerDataModel.MiAvailable = 1;
}
else if (CodeDataModel.Remark == "净")
{
CustomerDataModel.JingAvailable = 1;
}
else if (CodeDataModel.Remark == "准")
{
CustomerDataModel.ZhunAvailable = 1;
}
else if (CodeDataModel.Remark == "宝护盖")
{
CustomerDataModel.BaoAvaivable = 1;
}
CustomerDatadal.Add(CustomerDataModel);//新增可兑换信息
HtCustomer.Add(phonenumber, CustomerDataModel);//新增后添加到hashtable
}
}
}
if (WrongFormatCode.Count > 0 || ExchangedCode.Count > 0 || NoexistCode.Count > 0 || ValidatedCode.Count > 0)//代码错误
{
string wrongformatcodestring = "";
foreach (string wrongformatcodestr in WrongFormatCode)
{
wrongformatcodestring += wrongformatcodestr + "、";
}
if (wrongformatcodestring != "")
{
wrongformatcodestring = wrongformatcodestring.TrimEnd('、');
string errormsg = string.Format("您提交的代码{0}格式有误，请按正确格式将9位代码上传，多个代码则用“/”分隔。如有疑问，请咨询400-820-2775。", wrongformatcodestring);
msg.Add(errormsg);
}
string exchangedcodestring = "";
foreach (string exchangedcodestr in ExchangedCode)
{
Maticsoft.Model.CodeData codedatamodel = HtCode[exchangedcodestr] as Maticsoft.Model.CodeData;
string str = string.Format("{0}已于{1}年{2}月{3}日兑换", exchangedcodestr, codedatamodel.ExchangeTime.Value.Year, codedatamodel.ExchangeTime.Value.Month, codedatamodel.ExchangeTime.Value.Day);
exchangedcodestring += str + "、";
}
if (exchangedcodestring != "")
{
exchangedcodestring = exchangedcodestring.TrimEnd('、');
string errormsg = string.Format("您上传的代码{0}。如有疑问，请咨询400-820-2775。", exchangedcodestring);
msg.Add(errormsg);
}
string noexistcodestring = "";
foreach (string noexistcodestr in NoexistCode)
{
noexistcodestring += noexistcodestr + "、";
}
if (noexistcodestring != "")
{
noexistcodestring = noexistcodestring.TrimEnd('、');
string errormsg = string.Format("您上传的代码{0}有误，请核对后重新上传。如有疑问，请咨询400-820-2775。", noexistcodestring);
msg.Add(errormsg);
}
string validatedtcodestring = "";
foreach (string validatedtcodestr in ValidatedCode)
{
Maticsoft.Model.CodeData codedatamodel = HtCode[validatedtcodestr] as Maticsoft.Model.CodeData;
string str = string.Format("{0}已于{1}年{2}月{3}上传", validatedtcodestr, codedatamodel.ValidatedTime.Value.Year, codedatamodel.ValidatedTime.Value.Month, codedatamodel.ValidatedTime.Value.Day);
validatedtcodestring += str + "、";
}
if (validatedtcodestring != "")
{
validatedtcodestring = validatedtcodestring.TrimEnd('、');
string errormsg = string.Format("您上传的代码{0}。如有疑问，请咨询400-820-2775。", validatedtcodestring);
msg.Add(errormsg);
}
}
//获取可兑换信息
if (HtCustomer.Contains(phonenumber))
{
Maticsoft.Model.CustomerData model = HtCustomer[phonenumber] as Maticsoft.Model.CustomerData;
int BaoNum = model.BaoAvaivable;
int JingNum = model.JingAvailable;
int MiNum = model.MiAvailable;
int ZhunNum = model.ZhunAvailable;
msg.AddRange(getMsg(BaoNum, JingNum, MiNum, ZhunNum));
}
tsCope.Complete();
}
catch (Exception)
{
msg.Clear();
throw;
}
finally
{
tsCope.Dispose();
}
}
return msg;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.CustomerData GetModel(string PhoneNumber)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 PhoneNumber,CustomerName,Address,MiAvailable,JingAvailable,ZhunAvailable,BaoAvaivable,GiftPacks,ProductPacks from CustomerData ");
strSql.Append(" where PhoneNumber=@PhoneNumber ");
SqlParameter[] parameters = {
new SqlParameter("@PhoneNumber", SqlDbType.NVarChar,50) };
parameters[0].Value = PhoneNumber;
Maticsoft.Model.CustomerData model=new Maticsoft.Model.CustomerData();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
