private Submit_Out SubmitCallWork(string input)
{
Submit_Out jsonModel = new Submit_Out();
TF.RunSafty.BLL.TAB_MsgCallWork bllCallWork = new TF.RunSafty.BLL.TAB_MsgCallWork();
TF.RunSafty.BLL.TAB_MsgCallWork_Record bllRecord = new TF.RunSafty.BLL.TAB_MsgCallWork_Record();
TF.Api.Utilities.Validation validater = new TF.Api.Utilities.Validation();
try
{
Submit_In paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <Submit_In>(input);
//验证数据正确性,非空字段不能为空
if (validater.IsNotNullPropertiesValidated(paramModel.data))
{
foreach (pMsg msg in paramModel.data)
{
TF.RunSafty.Model.TAB_MsgCallWork_Record record = bllRecord.GetModelByGUID(msg.strGUID);
if (record != null)
{
record.strReceiverPhone = msg.strReceiverPhone;
record.strSenderPhone = msg.strSenderPhone;
record.dtTime = DateTime.Parse(msg.dtSendTime);
record.nResult = int.Parse(msg.nResult);
bllRecord.Update(record);
}
else
{
record.strReceiverPhone = msg.strReceiverPhone;
record.strSenderPhone = msg.strSenderPhone;
record.dtTime = DateTime.Parse(msg.dtSendTime);
record.nResult = int.Parse(msg.nResult);
bllRecord.Add(record);
}
//更新叫班次数
TF.RunSafty.Model.TAB_MsgCallWork work = bllCallWork.GetModelByGUID(msg.strGUID);
if (work != null)
{
work.dtCallTime = DateTime.Parse(msg.dtSendTime);
work.nCallTimes = work.nCallTimes + 1;
bllCallWork.Update(work);
}
}
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
return(jsonModel);
}
public Receipt_Out SubmitReceipt(string input)
{
//根据电话号码找到乘务员的guid,然后根据trainmanguid和receivetime匹配TAB_MsgCallWork 最近的一次记录
Receipt_Out jsonModel = new Receipt_Out();
TF.RunSafty.BLL.TAB_MsgCallWork bllCallWork = new TF.RunSafty.BLL.TAB_MsgCallWork();
TF.RunSafty.BLL.TAB_MsgCallWork_Record bllRecord = new TF.RunSafty.BLL.TAB_MsgCallWork_Record();
TF.Api.Utilities.Validation validater = new TF.Api.Utilities.Validation();
try
{
Receipt_In paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <Receipt_In>(input);
//验证数据正确性,非空字段不能为空
if (validater.IsNotNullPropertiesValidated(paramModel.data))
{
foreach (pMsgContent msg in paramModel.data)
{
TF.RunSafty.Model.TAB_MsgCallWork work = bllCallWork.GetModelByTelephone(msg.strSenderPhone, msg.dtRecvTime);
if (work != null)
{
TF.RunSafty.Model.TAB_MsgCallWork_Record record = new TF.RunSafty.Model.TAB_MsgCallWork_Record();
record.strGUID = Guid.NewGuid().ToString();
record.strMsgContent = msg.strContent;
record.strSenderPhone = msg.strSenderPhone;
record.strReceiverPhone = msg.strReceiverPhone;
//record.strCallWorkGUID = work.strGUID;
record.dtTime = DateTime.Parse(msg.dtRecvTime);
record.nType = 0;
record.nResult = 1;
bllRecord.Add(record);
//更新叫班表的叫班状态、接收时间、接收次数
//work.DtRecvMsgTime = DateTime.Parse(msg.dtRecvTime);
work.nRecvCount = work.nRecvCount + 1;
//work.nState = (int)TRsCallWorkState.cwsRecv;
bllCallWork.Update(work);
}
}
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败" + ex.Message;
}
return(jsonModel);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TF.RunSafty.Model.TAB_MsgCallWork_Record model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TAB_MsgCallWork_Record set ");
strSql.Append("strGUID=@strGUID,");
strSql.Append("strMsgContent=@strMsgContent,");
strSql.Append("strCallWorkGUID=@strCallWorkGUID,");
strSql.Append("dtTime=@dtTime,");
strSql.Append("nType=@nType,");
strSql.Append("nResult=@nResult,");
strSql.Append("strSenderPhone=@strSenderPhone,");
strSql.Append("strReceiverPhone=@strReceiverPhone");
strSql.Append(" where nId=@nId");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strMsgContent", SqlDbType.VarChar, 200),
new SqlParameter("@strCallWorkGUID", SqlDbType.VarChar, 200),
new SqlParameter("@dtTime", SqlDbType.DateTime),
new SqlParameter("@nType", SqlDbType.Int, 4),
new SqlParameter("@nResult", SqlDbType.Int, 4),
new SqlParameter("@strSenderPhone", SqlDbType.VarChar, 20),
new SqlParameter("@strReceiverPhone", SqlDbType.VarChar, 20),
new SqlParameter("@nId", SqlDbType.Int, 4)
};
parameters[0].Value = model.strGUID;
parameters[1].Value = model.strMsgContent;
parameters[2].Value = model.strCallWorkGUID;
parameters[3].Value = model.dtTime;
parameters[4].Value = model.nType;
parameters[5].Value = model.nResult;
parameters[6].Value = model.strSenderPhone;
parameters[7].Value = model.strReceiverPhone;
parameters[8].Value = model.nId;
int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Model.TAB_MsgCallWork_Record DataRowToModel(DataRow row)
{
TF.RunSafty.Model.TAB_MsgCallWork_Record model = new TF.RunSafty.Model.TAB_MsgCallWork_Record();
if (row != null)
{
if (row["nId"] != null && row["nId"].ToString() != "")
{
model.nId = int.Parse(row["nId"].ToString());
}
if (row["strGUID"] != null)
{
model.strGUID = row["strGUID"].ToString();
}
if (row["strMsgContent"] != null)
{
model.strMsgContent = row["strMsgContent"].ToString();
}
if (row["strCallWorkGUID"] != null)
{
model.strCallWorkGUID = row["strCallWorkGUID"].ToString();
}
if (row["dtTime"] != null && row["dtTime"].ToString() != "")
{
model.dtTime = DateTime.Parse(row["dtTime"].ToString());
}
if (row["nType"] != null && row["nType"].ToString() != "")
{
model.nType = int.Parse(row["nType"].ToString());
}
if (row["nResult"] != null && row["nResult"].ToString() != "")
{
model.nResult = int.Parse(row["nResult"].ToString());
}
if (row["strSenderPhone"] != null)
{
model.strSenderPhone = row["strSenderPhone"].ToString();
}
if (row["strReceiverPhone"] != null)
{
model.strReceiverPhone = row["strReceiverPhone"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TF.RunSafty.Model.TAB_MsgCallWork_Record model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_MsgCallWork_Record(");
strSql.Append("strGUID,strMsgContent,strCallWorkGUID,dtTime,nType,nResult,strSenderPhone,strReceiverPhone)");
strSql.Append(" values (");
strSql.Append("@strGUID,@strMsgContent,@strCallWorkGUID,@dtTime,@nType,@nResult,@strSenderPhone,@strReceiverPhone)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@strGUID", SqlDbType.VarChar, 50),
new SqlParameter("@strMsgContent", SqlDbType.VarChar, 200),
new SqlParameter("@strCallWorkGUID", SqlDbType.VarChar, 200),
new SqlParameter("@dtTime", SqlDbType.DateTime),
new SqlParameter("@nType", SqlDbType.Int, 4),
new SqlParameter("@nResult", SqlDbType.Int, 4),
new SqlParameter("@strSenderPhone", SqlDbType.VarChar, 20),
new SqlParameter("@strReceiverPhone", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.strGUID;
parameters[1].Value = model.strMsgContent;
parameters[2].Value = model.strCallWorkGUID;
parameters[3].Value = model.dtTime;
parameters[4].Value = model.nType;
parameters[5].Value = model.nResult;
parameters[6].Value = model.strSenderPhone;
parameters[7].Value = model.strReceiverPhone;
object obj = SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TF.RunSafty.Model.TAB_MsgCallWork_Record GetModel(int nId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 nId,strGUID,strMsgContent,strCallWorkGUID,dtTime,nType,nResult,strSenderPhone,strReceiverPhone from TAB_MsgCallWork_Record ");
strSql.Append(" where nId=@nId");
SqlParameter[] parameters =
{
new SqlParameter("@nId", SqlDbType.Int, 4)
};
parameters[0].Value = nId;
TF.RunSafty.Model.TAB_MsgCallWork_Record model = new TF.RunSafty.Model.TAB_MsgCallWork_Record();
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
