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