/// <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
}
public static void InsertDrinkRecord(SubmitDrinkRec Rec, SqlTransaction trans)
{
string placeName = DBDictionary.GetDutyPlaceID(Rec.stmis);
Trainman trainman = new Trainman();
DBDictionary.GetTrainman(Rec.tmid, trainman);
#region 添加测酒记录
MDDrink MDDr = new MDDrink();
TF.Runsafty.Plan.DB.DBDrink DBDr = new Runsafty.Plan.DB.DBDrink();
//职位信息----- 开始----------
DBDrinkLogic dbdl = new DBDrinkLogic();
MDDrinkLogic mddl = new MDDrinkLogic();
mddl = dbdl.GetDrinkCadreEntity(Rec.tmid);
if (mddl != null)
{
MDDr.strDepartmentID = mddl.strDepartmentID;
MDDr.strDepartmentName = mddl.strDepartmentName;
MDDr.nCadreTypeID = mddl.nCadreTypeID;
MDDr.strCadreTypeName = mddl.strCadreTypeName;
}
//职位信息----- 结束----------
//是否是本段
MDDr.nLocalAreaTrainman = 0;
MDDr.trainmanID = trainman.tmGUID;
MDDr.createTime = DateTime.Now.ToString();
MDDr.verifyID = 0;
MDDr.oPlaceId = "";
MDDr.strGuid = Guid.NewGuid().ToString();
MDDr.drinkResult = Rec.nresult.ToString();
MDDr.strAreaGUID = "";
MDDr.dutyUserID = "";
MDDr.strTrainmanName = trainman.tmname;
MDDr.strTrainmanNumber = Rec.tmid;
MDDr.strTrainNo = "";
MDDr.strTrainNumber = "";
MDDr.strTrainTypeName = "";
MDDr.strWorkShopGUID = trainman.workShopID;
MDDr.strWorkShopName = trainman.workShopName;
MDDr.strPlaceID = Rec.stmis;
MDDr.strPlaceName = placeName;
MDDr.strSiteGUID = "";
MDDr.strSiteName = "";
MDDr.dwAlcoholicity = "";
MDDr.strWorkID = "";
MDDr.nWorkTypeID = Rec.workType;//工作类型为退勤
MDDr.imagePath = CreateImgPath(Rec);
SqlTrans sqltrans = new SqlTrans();
sqltrans.Begin();
try
{
DBDr.SubmitDrink(MDDr, sqltrans.trans);
sqltrans.Commit();
}
catch (Exception ex)
{
sqltrans.RollBack();
throw ex;
}
#endregion
}
