public InterfaceResult SubmitDrinkRec(string input)
{
input = HttpUtility.UrlDecode(input);
InterfaceResult jsonModel = new InterfaceResult();
try
{
SubmitDrinkRec paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <SubmitDrinkRec>(input);
DBSiteLogic dbSiteLogic = new DBSiteLogic();
dbSiteLogic.SubmitDrinkRecord(paramModel);
jsonModel.result = 0;
jsonModel.resultStr = "返回成功";
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交测酒事件失败" + ex.InnerException.Message.ToString();
}
return(jsonModel);
}
public void SubmitDrinkRecord(SubmitDrinkRec Rec)
{
SqlTrans sqlTrans = new SqlTrans();
sqlTrans.Begin();
try
{
if (Rec.workid != string.Empty)
{
string sql = @"select top 1 * from TAB_Plan_RunEvent_SiteInOut where
strInRoomSourceID1 = @workid or
strInRoomSourceID2= @workid or
strOutRoomSourceID1 = @workid or
strOutRoomSourceID2 = @workid";
SqlParameter[] sqlparam =
{
new SqlParameter("@workid", Rec.workid)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql, sqlparam).Tables[0];
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
if (dr["strInRoomSourceID1"].ToString() == Rec.workid)
{
sql = @"Update TAB_Plan_RunEvent_SiteInOut set strInBrief1 = @DrinResult where strTrainPlanGUID = @workid";
}
else
if (dr["strInRoomSourceID2"].ToString() == Rec.workid)
{
sql = @"Update TAB_Plan_RunEvent_SiteInOut set strInBrief2 = @DrinResult where strTrainPlanGUID = @workid";
}
else
if (dr["strOutRoomSourceID1"].ToString() == Rec.workid)
{
sql = @"Update TAB_Plan_RunEvent_SiteInOut set strOutBrief1 = @DrinResult where strTrainPlanGUID = @workid";
}
else
if (dr["strOutRoomSourceID2"].ToString() == Rec.workid)
{
sql = @"Update TAB_Plan_RunEvent_SiteInOut set strOutBrief2 = @DrinResult where strTrainPlanGUID = @workid";
}
SqlParameter[] uparams =
{
new SqlParameter("@workid", Rec.workid),
new SqlParameter("@DrinResult", Rec.ToResultString())
};
SqlHelper.ExecuteNonQuery(sqlTrans.trans, CommandType.Text, sql, uparams);
}
}
DBDrink.InsertDrinkRecord(Rec, sqlTrans.trans);
sqlTrans.Commit();
}
catch (Exception ex)
{
sqlTrans.RollBack();
throw ex;
}
}
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
}
private static string CreateImgPath(SubmitDrinkRec Rec)
{
return("/DrinkImage/" +
Rec.etime.Year.ToString() + "/" + Rec.etime.Month.ToString() + "/" +
Rec.etime.Day.ToString() + "/" + Rec.testid + ".jpg");
}