public TrainmanDrink_Out GetTrainmanDrinkInfo(string input) { TrainmanDrink_Out json = new TrainmanDrink_Out(); TrainmanDrink_In model = null; RRsDrink drink = null; try { model = Newtonsoft.Json.JsonConvert.DeserializeObject <TrainmanDrink_In>(input); string strSql = ""; switch (model.WorkType) { case TRsWorkTypeID.wtBeginWork: strSql = @"select * from TAB_Drink_Information where strWorkID = ( select top 1 strBeginWorkGUID from TAB_Plan_BeginWork where strTrainPlanGUID =@strTrainPlanGUID and strTrainmanGUID =@strTrainmanGUID) ORDER BY dtCreateTime DESC"; break; case TRsWorkTypeID.wtEndWork: strSql = @"select * from TAB_Drink_Information where strWorkID = ( select top 1 strEndWorkGUID from TAB_Plan_EndWork where strTrainPlanGUID = @strTrainPlanGUID and strTrainmanGUID = @strTrainmanGUID) ORDER BY dtCreateTime DESC"; break; } SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strTrainPlanGUID", model.strTrainPlanGUID), new SqlParameter("strTrainmanGUID", model.strTrainmanGUID), }; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; if (table.Rows.Count > 0) { json.result = "0"; drink = new RRsDrink(); drink.nDrinkResult = Convert.ToInt32(table.Rows[0]["nDrinkResult"]); drink.dtCreateTime = Convert.ToDateTime(table.Rows[0]["dtCreateTime"]).ToString("yyyy-MM-dd HH:mm:ss"); drink.strPictureURL = table.Rows[0]["strImagePath"].ToString(); json.resultStr = "获取测酒信息成功"; } else { json.result = "1"; json.resultStr = "获取测酒信息失败"; } } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); throw ex; } return(json); }
public Query_Out QueryDrink(string input) { Query_Out json = new Query_Out(); json.data = new List <RRsDrink>(); RRsDrink drink = null; Query_In model = null; try { model = Newtonsoft.Json.JsonConvert.DeserializeObject <Query_In>(input); string strSql = "select * from VIEW_Drink_Query where dtCreateTime >= @dtBeginTime and dtCreateTime <=@dtEndTime "; strSql += GetWhere(model); strSql += " order by dtCreateTime desc"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("dtBeginTime", model.dtBeginTime), new SqlParameter("dtEndTime", model.dtEndTime), new SqlParameter("strWorkShopGUID", model.WorkShopGUID), new SqlParameter("strTrainmanNumber", model.TrainmanNumber), new SqlParameter("nVerifyID", model.VerifyID), new SqlParameter("nWorkTypeID", model.DrinkTypeID), new SqlParameter("nDrinkResult", model.DrinkResultID), new SqlParameter("strTrainmanName", model.TrainmanName), }; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; DateTime dtCreateTime; if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { drink = GetSingleDrinkInfo(row); json.data.Add(drink); } json.result = "0"; json.resultStr = "获取测酒记录成功"; } else { json.result = "1"; json.resultStr = "获取测酒记录失败"; } } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); throw ex; } return(json); }
public RRsDrink GetSingleDrinkInfo(DataRow row) { RRsDrink drink = new RRsDrink(); DateTime dtCreateTime; drink.strGUID = row["strGUID"].ToString(); drink.strTrainmanName = row["strTrainmanName"].ToString(); drink.strTrainmanNumber = row["strTrainmanNumber"].ToString(); drink.strWorkShopName = row["strWorkShopName"].ToString(); drink.strDrinkResultName = row["strDrinkResultName"].ToString(); drink.strVerifyName = row["strVerifyName"].ToString(); drink.strWorkTypeName = row["strWorkTypeName"].ToString(); drink.nDrinkResult = Convert.ToInt32(row["nDrinkResult"]); drink.nVerifyID = Convert.ToInt32(row["nVerifyID"]); drink.nWorkTypeID = Convert.ToInt32(row["nWorkTypeID"]); if (DBNull.Value != row["dtCreateTime"] && DateTime.TryParse(row["dtCreateTime"].ToString(), out dtCreateTime)) { drink.dtCreateTime = dtCreateTime.ToString("yyyy-MM-dd HH:mm:ss"); } drink.strPictureURL = row["strImagePath"].ToString(); return(drink); }
public bool InsertDrink(string TrainmanNumber, RRsDrink drink, string DutyUserGUID, int nVerifyID) { bool result = false; string strSql = @"insert into TAB_Drink_Information (strGUID,strTrainmanGUID, nDrinkResult,dtCreateTime, strAreaGUID,strDutyGUID,nVerifyID,strWorkID,nWorkTypeID,strImagePath) values (@strGUID,@strTrainmanGUID,@nDrinkResult,@dtCreateTime, @strAreaGUID,@strDutyGUID,@nVerifyID,@strWorkID,@nWorkTypeID,@strImagePath)"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strGUID", Guid.NewGuid().ToString()), new SqlParameter("strTrainmanGUID", TrainmanNumber), new SqlParameter("nDrinkResult", drink.nDrinkResult), new SqlParameter("strImagePath", drink.strPictureURL), new SqlParameter("dtCreateTime", drink.dtCreateTime), new SqlParameter("strAreaGUID", ""), new SqlParameter("strDutyGUID", DutyUserGUID), new SqlParameter("nVerifyID", nVerifyID), new SqlParameter("strWorkID", ""), new SqlParameter("nWorkTypeID", drink.nWorkTypeID), }; result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters) > 0; return(result); }
public DrinkInfo_Out GetDrinkInfo(string input) { DrinkInfo_Out json = new DrinkInfo_Out(); RRsDrink drink = null; DrinkInfo_In model = null; try { model = Newtonsoft.Json.JsonConvert.DeserializeObject <DrinkInfo_In>(input); string strSql = "select * From VIEW_Drink_Query where strGUID=@strGUID"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strGUID", model.strGUID), }; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; if (table.Rows.Count > 0) { drink = GetSingleDrinkInfo(table.Rows[0]); json.data = drink; json.result = "0"; json.resultStr = "获取测酒信息成功"; } else { json.result = "1"; json.resultStr = "获取测酒信息失败"; } } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); throw ex; } return(json); }