public bool add(CallNotify model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tab_MsgCallWork");
strSql.Append("(strTrainPlanGUID,strMsgGUID,strTrainmanGUID,strSendMsgContent,strRecvMsgContent,dtSendTime,strSendUser,dtRecvTime,strRecvUser,eCallState,eCallType,nCancel,strCancelReason,dtCancelTime,strCancelUser)");
strSql.Append("values(@strTrainPlanGUID,@strMsgGUID,@strTrainmanGUID,@strSendMsgContent,@strRecvMsgContent,@dtSendTime,@strSendUser,@dtRecvTime,@strRecvUser,@eCallState,@eCallType,@nCancel,@strCancelReason,@dtCancelTime,@strCancelUser)");
SqlParameter[] parameters =
{
new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID),
new SqlParameter("@strMsgGUID", model.strMsgGUID),
new SqlParameter("@strTrainmanGUID", model.strTrainmanGUID),
new SqlParameter("@strSendMsgContent", model.strSendMsgContent),
new SqlParameter("@strRecvMsgContent", model.strRecvMsgContent),
new SqlParameter("@dtSendTime", model.dtSendTime),
new SqlParameter("@strSendUser", model.strSendUser),
new SqlParameter("@dtRecvTime", model.dtRecvTime),
new SqlParameter("@strRecvUser", model.strRecvUser),
new SqlParameter("@eCallState", model.eCallState),
new SqlParameter("@eCallType", model.eCallType),
new SqlParameter("@nCancel", model.nCancel),
new SqlParameter("@strCancelReason", model.strCancelReason),
new SqlParameter("@dtCancelTime", model.dtCancelTime),
new SqlParameter("@strCancelUser", model.strCancelUser)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
public CallNotify GetByStateSecDRToModelDTToList(DataRow dr)
{
CallNotify model = new CallNotify();
if (dr != null)
{
model.nId = ObjectConvertClass.static_ext_int(dr["nId"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.strMsgGUID = ObjectConvertClass.static_ext_string(dr["strMsgGUID"]);
model.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID"]);
model.strSendMsgContent = ObjectConvertClass.static_ext_string(dr["strSendMsgContent"]);
model.strRecvMsgContent = ObjectConvertClass.static_ext_string(dr["strRecvMsgContent"]);
model.dtSendTime = ObjectConvertClass.static_ext_date(dr["dtSendTime"]);
model.strSendUser = ObjectConvertClass.static_ext_string(dr["strSendUser"]);
model.dtRecvTime = ObjectConvertClass.static_ext_date(dr["dtRecvTime"]);
model.strRecvUser = ObjectConvertClass.static_ext_string(dr["strRecvUser"]);
model.eCallState = ObjectConvertClass.static_ext_int(dr["eCallState"]);
model.eCallType = ObjectConvertClass.static_ext_int(dr["eCallType"]);
model.nCancel = ObjectConvertClass.static_ext_int(dr["nCancel"]);
model.strCancelReason = ObjectConvertClass.static_ext_string(dr["strCancelReason"]);
model.strCancelUser = ObjectConvertClass.static_ext_string(dr["strCancelUser"]);
model.dtCancelTime = ObjectConvertClass.static_ext_date(dr["dtCancelTime"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.dtStartTime = ObjectConvertClass.static_ext_date(dr["dtStartTime"]);
model.strMobileNumber = ObjectConvertClass.static_ext_string(dr["strMobileNumber"]);
model.dtChuQinTime = ObjectConvertClass.static_ext_date(dr["dtChuQinTime"]);
model.dtCallTime = ObjectConvertClass.static_ext_date(dr["dtCallTime"]);
}
return(model);
}
public CallNotify FindUnCancelforNone_dtToModel(DataTable dt)
{
CallNotify model = new CallNotify();
if (dt.Rows.Count > 0)
{
model.nId = ObjectConvertClass.static_ext_int(dt.Rows[0]["nId"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainPlanGUID"]);
model.strMsgGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strMsgGUID"]);
model.strTrainmanGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanGUID"]);
model.strSendMsgContent = ObjectConvertClass.static_ext_string(dt.Rows[0]["strSendMsgContent"]);
model.strRecvMsgContent = ObjectConvertClass.static_ext_string(dt.Rows[0]["strRecvMsgContent"]);
model.dtSendTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtSendTime"]);
model.strSendUser = ObjectConvertClass.static_ext_string(dt.Rows[0]["strSendUser"]);
model.dtRecvTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtRecvTime"]);
model.strRecvUser = ObjectConvertClass.static_ext_string(dt.Rows[0]["strRecvUser"]);
model.eCallState = ObjectConvertClass.static_ext_int(dt.Rows[0]["eCallState"]);
model.eCallType = ObjectConvertClass.static_ext_int(dt.Rows[0]["eCallType"]);
model.nCancel = ObjectConvertClass.static_ext_int(dt.Rows[0]["nCancel"]);
model.strCancelReason = ObjectConvertClass.static_ext_string(dt.Rows[0]["strCancelReason"]);
model.strCancelUser = ObjectConvertClass.static_ext_string(dt.Rows[0]["strCancelUser"]);
model.dtCancelTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtCancelTime"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanName"]);
model.strTrainNo = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainNo"]);
model.dtStartTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtStartTime"]);
model.strMobileNumber = ObjectConvertClass.static_ext_string(dt.Rows[0]["strMobileNumber"]);
model.dtChuQinTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtChuQinTime"]);
model.dtCallTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtCallTime"]);
}
return(model);
}
public bool AddNotify(CallNotify model)
{
DataTable dtCallNotify = null;
if (FindUnCancel(model.strTrainmanGUID, model.strTrainPlanGUID, ref dtCallNotify))
{
string strMsgGUID = dtCallNotify.Rows[0]["strMsgGUID"].ToString();
string strCancelUser = dtCallNotify.Rows[0]["strCancelUser"].ToString();
string strCancelReason = dtCallNotify.Rows[0]["strCancelReason"].ToString();
DateTime dateTimeNow = DateTime.Now;
CancelNotify(strMsgGUID, strCancelUser, dateTimeNow, strCancelReason);
}
if (add(model))
{
return(true);
}
else
{
return(false);
}
}