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