/// <summary>
/// 添加消息
/// </summary>
/// <param name="trans"></param>
/// <param name="model"></param>
/// <param name="strAskLeaveGUID"></param>
private void CreatMsg(SqlTransaction trans, string strMsg)
{
AttentionMsg msg = new AttentionMsg();
msg.msgType = MSGTYPE.MSG_LEAVE;//请销假消息类别
msg.param = strMsg;
msg.CreatMsg(trans);
}
/// <summary>
/// 提交测酒记录
/// </summary>
/// <param name="?"></param>
public void SubmitDrink(MDDrink MDR, SqlTransaction trans)
{
#region 添加测酒记录
MDR.strPlaceName = MDR.strPlaceName != "" ? MDR.strPlaceName : getPlaceName(MDR.strPlaceID);
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("strTrainmanGUID", MDR.trainmanID),
new SqlParameter("dtCreateTime", MDR.createTime),
new SqlParameter("nVerifyID", MDR.verifyID),
new SqlParameter("strPlaceID", MDR.oPlaceId.ToString()),
new SqlParameter("strGUID", MDR.strGuid),
new SqlParameter("nDrinkResult", MDR.drinkResult),
new SqlParameter("strAreaGUID", MDR.strAreaGUID),
new SqlParameter("strDutyGUID", MDR.dutyUserID),
new SqlParameter("bLocalAreaTrainman", MDR.nLocalAreaTrainman),
new SqlParameter("strTrainmanName", MDR.strTrainmanName),
new SqlParameter("strTrainmanNumber", MDR.strTrainmanNumber),
new SqlParameter("strTrainNo", MDR.strTrainNo),
new SqlParameter("strTrainNumber", MDR.strTrainNumber),
new SqlParameter("strTrainTypeName", MDR.strTrainTypeName),
new SqlParameter("strWorkShopGUID", MDR.strWorkShopGUID),
new SqlParameter("strWorkShopName", MDR.strWorkShopName),
new SqlParameter("strPlaceIDs", MDR.strPlaceID),
new SqlParameter("strPlaceName", MDR.strPlaceName),
new SqlParameter("strSiteGUID", MDR.strSiteGUID),
new SqlParameter("strSiteName", MDR.strSiteName),
new SqlParameter("dwAlcoholicity", MDR.dwAlcoholicity),
new SqlParameter("strWorkID", MDR.strWorkID),
new SqlParameter("nWorkTypeID", MDR.nWorkTypeID),
new SqlParameter("strImagePath", MDR.imagePath),
new SqlParameter("strDepartmentID", MDR.strDepartmentID),
new SqlParameter("strDepartmentName", MDR.strDepartmentName),
new SqlParameter("nCadreTypeID", MDR.nCadreTypeID),
new SqlParameter("strCadreTypeName", MDR.strCadreTypeName)
};
string sqlText = @"insert into TAB_Drink_Information (strGUID,strTrainmanGUID,nDrinkResult,dtCreateTime,strAreaGUID,strDutyGUID,nVerifyID,strWorkID,nWorkTypeID,
strImagePath,strTrainmanName,strTrainmanNumber,strTrainNo,strTrainNumber,strTrainTypeName,strWorkShopGUID,strWorkShopName,strPlaceID,
strPlaceName,strSiteGUID,strSiteName,dwAlcoholicity,bLocalAreaTrainman,strDepartmentID,strDepartmentName,nCadreTypeID,strCadreTypeName)
values (@strGUID,@strTrainmanGUID,@nDrinkResult,@dtCreateTime,
@strAreaGUID,@strDutyGUID,@nVerifyID,@strWorkID,@nWorkTypeID,@strImagePath,@strTrainmanName,@strTrainmanNumber,
@strTrainNo,@strTrainNumber,@strTrainTypeName,@strWorkShopGUID,@strWorkShopName,@strPlaceIDs,@strPlaceName,@strSiteGUID,@strSiteName,
@dwAlcoholicity,@bLocalAreaTrainman,@strDepartmentID,@strDepartmentName,@nCadreTypeID,@strCadreTypeName)";
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sqlText, sqlParams);
#endregion
#region 插入消息记录
MDR.msgType = MSGTYPE.MSG_DRINK;
MDR.workTypeID = MDR.nWorkTypeID;
string strMsg = AttentionMsg.ReturnStrJson(MDR);
AttentionMsg msg = new AttentionMsg();
msg.msgType = MSGTYPE.MSG_DRINK;//测酒消息类别
msg.param = strMsg;
msg.CreatMsg(trans);
#endregion
}
/// <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);
}
/// <summary>
/// 添加数据
/// </summary>
public bool AddDrinkInfo(MDBianXie.DrinkInfo model)
{
SqlTrans sqltrans = new SqlTrans();
sqltrans.Begin();
try
{
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),
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)
};
SqlHelper.ExecuteNonQuery(sqltrans.trans, CommandType.Text, strSql.ToString(), parameters);
#region 插入消息记录
string strMsg = Newtonsoft.Json.JsonConvert.SerializeObject(model);
AttentionMsg msg = new AttentionMsg();
msg.msgType = MSGTYPE.MSG_DRINK;//测酒消息类别
msg.param = strMsg;
msg.CreatMsg(sqltrans.trans);
#endregion
sqltrans.Commit();
return(true);
}
catch (Exception ex)
{
sqltrans.RollBack();
throw ex;
}
}
