/// <summary> /// 增加一条数据 /// </summary> public int Add(TF.RunSafty.Model.TAB_MsgCallWork model) { string sqlText = "delete from TAB_MsgCallWork where strPlanGUID=@strPlanGUID and strTrainmanGUID=@strTrainmanGUID"; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_MsgCallWork("); strSql.Append("strMsgGUID,strPlanGUID,strTrainmanGUID,strSendMsgContent,strRecvMsgContent,dtCallTime,nCallTimes,nSendCount,nRecvCount,eCallState,eCallType,dtSendTime,strSendUser,strRecvUser,dtRecvTime)"); strSql.Append(" values ("); strSql.Append("@strMsgGUID,@strPlanGUID,@strTrainmanGUID,@strSendMsgContent,@strRecvMsgContent,@dtCallTime,@nCallTimes,@nSendCount,@nRecvCount,@eCallState,@eCallType,@dtSendTime,@strSendUser,@strRecvUser,@dtRecvTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@strMsgGUID", SqlDbType.VarChar, 50), new SqlParameter("@strPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@strTrainmanGUID", SqlDbType.VarChar, 50), new SqlParameter("@strSendMsgContent", SqlDbType.VarChar, 200), new SqlParameter("@strRecvMsgContent", SqlDbType.VarChar, 200), new SqlParameter("@dtCallTime", SqlDbType.DateTime), new SqlParameter("@nCallTimes", SqlDbType.Int, 4), new SqlParameter("@nSendCount", SqlDbType.Int, 4), new SqlParameter("@nRecvCount", SqlDbType.Int, 4), new SqlParameter("@eCallState", SqlDbType.Int, 4), new SqlParameter("@eCallType", SqlDbType.Int, 4), new SqlParameter("@dtSendTime", SqlDbType.DateTime), new SqlParameter("@strSendUser", SqlDbType.VarChar, 50), new SqlParameter("@strRecvUser", SqlDbType.VarChar, 50), new SqlParameter("@dtRecvTime", SqlDbType.DateTime) }; parameters[0].Value = model.strMsgGUID; parameters[1].Value = model.strPlanGUID; parameters[2].Value = model.strTrainmanGUID; parameters[3].Value = model.strSendMsgContent; parameters[4].Value = model.strRecvMsgContent; parameters[5].Value = model.dtCallTime; parameters[6].Value = model.nCallTimes; parameters[7].Value = model.nSendCount; parameters[8].Value = model.nRecvCount; parameters[9].Value = model.eCallState; parameters[10].Value = model.eCallType; parameters[11].Value = model.dtSendTime; parameters[12].Value = model.strSendUser; parameters[13].Value = model.strRecvUser; parameters[14].Value = model.dtRecvTime; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sqlText, parameters); 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 DataRowToModel(DataRow row) { TF.RunSafty.Model.TAB_MsgCallWork model = new TF.RunSafty.Model.TAB_MsgCallWork(); if (row != null) { if (row["nId"] != null && row["nId"].ToString() != "") { model.nId = int.Parse(row["nId"].ToString()); } if (row["strMsgGUID"] != null) { model.strMsgGUID = row["strMsgGUID"].ToString(); } if (row["strPlanGUID"] != null) { model.strPlanGUID = row["strPlanGUID"].ToString(); } if (row["strTrainmanGUID"] != null) { model.strTrainmanGUID = row["strTrainmanGUID"].ToString(); } if (row["strSendMsgContent"] != null) { model.strSendMsgContent = row["strSendMsgContent"].ToString(); } if (row["strRecvMsgContent"] != null) { model.strRecvMsgContent = row["strRecvMsgContent"].ToString(); } if (row["dtCallTime"] != null && row["dtCallTime"].ToString() != "") { model.dtCallTime = DateTime.Parse(row["dtCallTime"].ToString()); } if (row["nCallTimes"] != null && row["nCallTimes"].ToString() != "") { model.nCallTimes = int.Parse(row["nCallTimes"].ToString()); } if (row["nSendCount"] != null && row["nSendCount"].ToString() != "") { model.nSendCount = int.Parse(row["nSendCount"].ToString()); } if (row["nRecvCount"] != null && row["nRecvCount"].ToString() != "") { model.nRecvCount = int.Parse(row["nRecvCount"].ToString()); } if (row["eCallState"] != null && row["eCallState"].ToString() != "") { model.eCallState = int.Parse(row["eCallState"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TF.RunSafty.Model.TAB_MsgCallWork model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TAB_MsgCallWork set "); strSql.Append("strMsgGUID=@strMsgGUID,"); strSql.Append("strPlanGUID=@strPlanGUID,"); strSql.Append("strTrainmanGUID=@strTrainmanGUID,"); strSql.Append("strSendMsgContent=@strSendMsgContent,"); strSql.Append("strRecvMsgContent=@strRecvMsgContent,"); strSql.Append("dtCallTime=@dtCallTime,"); strSql.Append("nCallTimes=@nCallTimes,"); strSql.Append("nSendCount=@nSendCount,"); strSql.Append("nRecvCount=@nRecvCount,"); strSql.Append("eCallState=@eCallState"); strSql.Append(" where nId=@nId"); SqlParameter[] parameters = { new SqlParameter("@strMsgGUID", SqlDbType.VarChar, 50), new SqlParameter("@strPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@strTrainmanGUID", SqlDbType.VarChar, 50), new SqlParameter("@strSendMsgContent", SqlDbType.VarChar, 200), new SqlParameter("@strRecvMsgContent", SqlDbType.VarChar, 200), new SqlParameter("@dtCallTime", SqlDbType.DateTime), new SqlParameter("@nCallTimes", SqlDbType.Int, 4), new SqlParameter("@nSendCount", SqlDbType.Int, 4), new SqlParameter("@nRecvCount", SqlDbType.Int, 4), new SqlParameter("@eCallState", SqlDbType.Int, 4), new SqlParameter("@nId", SqlDbType.Int, 4) }; parameters[0].Value = model.strMsgGUID; parameters[1].Value = model.strPlanGUID; parameters[2].Value = model.strTrainmanGUID; parameters[3].Value = model.strSendMsgContent; parameters[4].Value = model.strRecvMsgContent; parameters[5].Value = model.dtCallTime; parameters[6].Value = model.nCallTimes; parameters[7].Value = model.nSendCount; parameters[8].Value = model.nRecvCount; parameters[9].Value = model.eCallState; parameters[10].Value = model.nId; int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
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); }
public NeedCallWork_Out SubmitNeededCallWork(string input) { NeedCallWork_Out jsonModel = new NeedCallWork_Out(); TF.RunSafty.BLL.TAB_MsgCallWork bllCallWork = new TF.RunSafty.BLL.TAB_MsgCallWork(); TF.Api.Utilities.Validation validater = new TF.Api.Utilities.Validation(); try { NeedCallWork_In paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <NeedCallWork_In>(input); //验证数据正确性,非空字段不能为空 if (validater.IsNotNullPropertiesValidated(paramModel.data)) { TF.RunSafty.Model.TAB_MsgCallWork work = new TF.RunSafty.Model.TAB_MsgCallWork(); work.strTrainmanGUID = paramModel.data.strTrainmanGUID; work.strPlanGUID = paramModel.data.strPlanGUID; work.strSendMsgContent = paramModel.data.strMsgContent; work.dtCallTime = DateTime.Parse(paramModel.data.dtCreateTime); //work.strGUID = "";//paramModel.data.strMsgGUID; work.nCallTimes = 0; work.nRecvCount = 0; work.nSendCount = 0; //work.nState = 1; bllCallWork.Add(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 TF.RunSafty.Model.TAB_MsgCallWork GetModel(int nId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 nId,strMsgGUID,strPlanGUID,strTrainmanGUID,strSendMsgContent,strRecvMsgContent,dtCallTime,nCallTimes,nSendCount,nRecvCount,eCallState from TAB_MsgCallWork "); strSql.Append(" where nId=@nId"); SqlParameter[] parameters = { new SqlParameter("@nId", SqlDbType.Int, 4) }; parameters[0].Value = nId; TF.RunSafty.Model.TAB_MsgCallWork model = new TF.RunSafty.Model.TAB_MsgCallWork(); 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); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.TAB_MsgCallWork DataRowToModelForAllMsg(DataRow row) { TF.RunSafty.Model.TAB_MsgCallWork model = new TF.RunSafty.Model.TAB_MsgCallWork(); if (row != null) { if (row["nId"] != null && row["nId"].ToString() != "") { model.nId = int.Parse(row["nId"].ToString()); } if (row["strMsgGUID"] != null) { model.strMsgGUID = row["strMsgGUID"].ToString(); } if (row["strPlanGUID"] != null) { model.strPlanGUID = row["strPlanGUID"].ToString(); } if (row["strTrainmanGUID"] != null) { model.strTrainmanGUID = row["strTrainmanGUID"].ToString(); } if (row["strTrainmanName"] != null) { model.strTrainmanName = row["strTrainmanName"].ToString(); } if (row["strTrainmanNumber"] != null) { model.strTrainmanNumber = row["strTrainmanNumber"].ToString(); } if (row["strMobileNumber"] != null) { model.strMobileNumber = row["strMobileNumber"].ToString(); } if (row["dtSendTime"] != null) { model.dtSendTime = row["dtSendTime"].ToString(); } if (row["strSendUser"] != null) { model.strSendUser = row["strSendUser"].ToString(); } if (row["strRecvUser"] != null) { model.strRecvUser = row["strRecvUser"].ToString(); } if (row["dtRecvTime"] != null) { model.dtRecvTime = row["dtRecvTime"].ToString(); } if (row["eCallType"] != null) { model.eCallType = row["eCallType"].ToString(); } if (row["dtRealStartTime"] != null) { model.dtStartTime = row["dtRealStartTime"].ToString(); } if (row["dtStartTime"] != null) { model.dtChuQinTime = row["dtStartTime"].ToString(); } if (row["strTrainNo"] != null) { model.strTrainNo = row["strTrainNo"].ToString(); } if (row["strSendMsgContent"] != null) { model.strSendMsgContent = row["strSendMsgContent"].ToString(); } if (row["strRecvMsgContent"] != null) { model.strRecvMsgContent = row["strRecvMsgContent"].ToString(); } if (row["dtCallTime"] != null && row["dtCallTime"].ToString() != "") { model.dtCallTime = DateTime.Parse(row["dtCallTime"].ToString()); } if (row["nCallTimes"] != null && row["nCallTimes"].ToString() != "") { model.nCallTimes = int.Parse(row["nCallTimes"].ToString()); } if (row["nSendCount"] != null && row["nSendCount"].ToString() != "") { model.nSendCount = int.Parse(row["nSendCount"].ToString()); } if (row["nRecvCount"] != null && row["nRecvCount"].ToString() != "") { model.nRecvCount = int.Parse(row["nRecvCount"].ToString()); } if (row["eCallState"] != null && row["eCallState"].ToString() != "") { model.eCallState = int.Parse(row["eCallState"].ToString()); } } return(model); }