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); } }