public MDDrink4Msg getModel(DrinkInfo model)
{
MDDrink4Msg msg = new MDDrink4Msg();
msg.nLocalAreaTrainman = model.bLocalAreaTrainman == true ? 0 : 1;
msg.trainmanID = model.strTrainmanGUID;
msg.strTrainmanNumber = model.strTrainmanNumber;
msg.strTrainmanName = model.strTrainmanName;
msg.dwAlcoholicity = model.dwAlcoholicity.ToString();
msg.drinkResult = model.nDrinkResult.ToString();
msg.createTime = model.dtCreateTime.ToString();
msg.strTrainNo = model.strTrainNo;
msg.strTrainNumber = model.strTrainNumber;
msg.strTrainTypeName = model.strTrainTypeName;
msg.strPlaceID = model.strPlaceID;
msg.strPlaceName = model.strPlaceName;
msg.strSiteGUID = model.strSiteGUID;
msg.strSiteName = model.strSiteName;
msg.strWorkShopGUID = model.strWorkShopGUID;
msg.strWorkShopName = model.strWorkShopName;
msg.strAreaGUID = model.strAreaGUID;
msg.verifyID = model.nVerifyID;
msg.strWorkID = model.strWorkID;
msg.workTypeID = model.nWorkTypeID;
msg.imagePath = model.strImagePath;
msg.strDepartmentID = model.strDepartmentID;
msg.strDepartmentName = model.strDepartmentName;
msg.nCadreTypeID = model.nCadreTypeID;
msg.strCadreTypeName = model.strCadreTypeName;
msg.strGuid = model.strGUID;
msg.oPlaceId = "";
msg.dutyUserID = model.strDutyGUID;
msg.nWorkTypeID = model.nWorkTypeID;
msg.msgType = MSGTYPE.MSG_DRINK;
return(msg);
}
/// <summary>
/// 添加数据
/// </summary>
public bool AddDrinkInfo(DrinkInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Drink_Information");
strSql.Append("( strGUID,bLocalAreaTrainman,strTrainmanGUID,strTrainmanNumber,strTrainmanName ,dwAlcoholicity ,nDrinkResult,dtCreateTime ,");
strSql.Append(" strTrainNo , strTrainNumber , strTrainTypeName , strPlaceID , strPlaceName, strSiteGUID , strSiteNumber,strSiteName ,");
strSql.Append(" strWorkShopGUID , strWorkShopName ,strAreaGUID,strDutyNumber,strDutyName,nVerifyID,strWorkID,nWorkTypeID,strImagePath,strDepartmentID,strDepartmentName,nCadreTypeID,strCadreTypeName )");
strSql.Append("values (newid(),@bLocalAreaTrainman,@strTrainmanGUID,@strTrainmanNumber,@strTrainmanName,@dwAlcoholicity,@nDrinkResult,@dtCreateTime,");
strSql.Append(" @strTrainNo , @strTrainNumber , @strTrainTypeName , @strPlaceID , @strPlaceName, @strSiteGUID ,@strSiteNumber, @strSiteName ,");
strSql.Append(" @strWorkShopGUID , @strWorkShopName ,@strAreaGUID,@strDutyNumber,@strDutyName,@nVerifyID,@strWorkID,@nWorkTypeID,@strImagePath,@strDepartmentID,@strDepartmentName,@nCadreTypeID,@strCadreTypeName)");
SqlParameter[] parameters =
{
new SqlParameter("@bLocalAreaTrainman", model.bLocalAreaTrainman),
new SqlParameter("@strTrainmanGUID", model.strTrainmanGUID),
new SqlParameter("@strTrainmanNumber", model.strTrainmanNumber),
new SqlParameter("@strTrainmanName", model.strTrainmanName),
new SqlParameter("@dwAlcoholicity", model.dwAlcoholicity.ToString()),
new SqlParameter("@nDrinkResult", model.nDrinkResult),
new SqlParameter("@dtCreateTime", model.dtCreateTime),
new SqlParameter("@strTrainNo", model.strTrainNo),
new SqlParameter("@strTrainNumber", model.strTrainNumber),
new SqlParameter("@strTrainTypeName", model.strTrainTypeName),
new SqlParameter("@strPlaceID", model.strPlaceID),
new SqlParameter("@strPlaceName", model.strPlaceName),
new SqlParameter("@strSiteGUID", model.strSiteGUID),
new SqlParameter("@strSiteNumber", model.strSiteNumber),
new SqlParameter("@strSiteName", model.strSiteName),
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("@strWorkShopName", model.strWorkShopName),
new SqlParameter("@strAreaGUID", model.strAreaGUID),
new SqlParameter("@strDutyNumber", model.strDutyNumber),
new SqlParameter("@strDutyName", model.strDutyName),
new SqlParameter("@nVerifyID", model.nVerifyID),
new SqlParameter("@strWorkID", model.strWorkID),
new SqlParameter("@nWorkTypeID", model.nWorkTypeID),
new SqlParameter("@strImagePath", model.strImagePath),
new SqlParameter("strDepartmentID", model.strDepartmentID),
new SqlParameter("strDepartmentName", model.strDepartmentName),
new SqlParameter("nCadreTypeID", model.nCadreTypeID),
new SqlParameter("strCadreTypeName", model.strCadreTypeName)
//new SqlParameter("@strWorkTypeName", model.strWorkTypeName),
//new SqlParameter("@strDrinkResultName", model.strDrinkResultName),
//new SqlParameter("@strVerifyName", model.strVerifyName),
//new SqlParameter("@strDutyGUID", model.strDutyGUID),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
#region 插入消息记录
MDDrink4Msg MDMsg = new MDDrink4Msg();
MDMsg = this.getModel(model);
string strMsg = AttentionMsg.ReturnStrJson(MDMsg);
AttentionMsg msg = new AttentionMsg();
msg.msgType = MSGTYPE.MSG_DRINK;//测酒消息类别
msg.param = strMsg;
msg.CreatMsg();
#endregion
return(true);
}
