public DrinkInfoArray GetTrainNoDrinkInfo(DateTime dtStartTime, string strTrainNo, string strPlaceID, int ncount)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top " + ncount + " strTrainmanNumber,strTrainmanName,strTrainmanGUID, dwAlcoholicity,nDrinkResult,dtCreateTime ");
strSql.Append(" from TAB_Drink_Information WHERE dtCreateTime in (select max(dtCreateTime) from TAB_Drink_Information");
strSql.Append(" where dtcreatetime >= @dtStartTime and strTrainNo = @strTrainNo ");
if (!string.IsNullOrEmpty(strPlaceID))
{
strSql.Append(" and strPlaceID=@strPlaceID");
}
strSql.Append(" group by strTrainmanNumber)");
SqlParameter[] sqlParams =
{
new SqlParameter("dtStartTime", dtStartTime),
new SqlParameter("strTrainNo", strTrainNo),
new SqlParameter("strPlaceID", strPlaceID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DrinkInfoArray list = new DrinkInfoArray();
foreach (DataRow dr in dt.Rows)
{
DrinkInfo _Drink_Query = new DrinkInfo();
_Drink_Query.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID"]);
_Drink_Query.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
_Drink_Query.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
_Drink_Query.dwAlcoholicity = ObjectConvertClass.static_ext_int(dr["dwAlcoholicity"]);
_Drink_Query.nDrinkResult = ObjectConvertClass.static_ext_int(dr["nDrinkResult"]);
_Drink_Query.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
list.Add(_Drink_Query);
}
return(list);
}
public DrinkInfoArray QueryNoPlanDrink(DateTime dtBeginTime, DateTime dtEndTime, string TrainmanNumber, int DrinkTypeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from VIEW_Drink_Query where dtCreateTime >= @dtBeginTime and dtCreateTime <= @dtEndTime ");
strSql.Append(!string.IsNullOrEmpty(TrainmanNumber) ? " and strTrainmanNumber = @strTrainmanNumber" : "");
strSql.Append(DrinkTypeID > -1 ? " and nWorkTypeID = @nWorkTypeID" : "");
strSql.Append(" and (strWorkID = '' or strWorkID is Null ) order by dtCreateTime desc");
SqlParameter[] sqlParams =
{
new SqlParameter("dtBeginTime", dtBeginTime),
new SqlParameter("dtEndTime", dtEndTime),
new SqlParameter("strTrainmanNumber", TrainmanNumber),
new SqlParameter("nWorkTypeID", DrinkTypeID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DrinkInfoArray list = new DrinkInfoArray();
foreach (DataRow dr in dt.Rows)
{
DrinkInfo _Drink_Query = new DrinkInfo();
DrinkDataRowToModel(_Drink_Query, dr);
list.Add(_Drink_Query);
}
return(list);
}
public DrinkInfo GetTMLastDrinkInfo(string strSiteNumber, string strTrainmanNumber, DateTime dtStartTime, out Boolean bExist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 strTrainmanGUID, strTrainmanNumber,strTrainmanName,dwAlcoholicity,nDrinkResult,dtCreateTime");
strSql.Append(" from TAB_Drink_Information where dtcreatetime >= @dtStartTime and strTrainmanNumber = @strTrainmanNumber and strSiteNumber = @strSiteNumber");
strSql.Append(" order by dtcreateTime desc");
SqlParameter[] sqlParams =
{
new SqlParameter("dtStartTime", dtStartTime),
new SqlParameter("strTrainmanNumber", strTrainmanNumber),
new SqlParameter("strSiteNumber", strSiteNumber),
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DrinkInfo _Drink_Query = null;
if (dt.Rows.Count > 0)
{
bExist = true;
_Drink_Query = new DrinkInfo();
_Drink_Query.strTrainmanGUID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanGUID"]);
_Drink_Query.strTrainmanNumber = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber"]);
_Drink_Query.strTrainmanName = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanName"]);
_Drink_Query.dwAlcoholicity = ObjectConvertClass.static_ext_int(dt.Rows[0]["dwAlcoholicity"]);
_Drink_Query.nDrinkResult = ObjectConvertClass.static_ext_int(dt.Rows[0]["nDrinkResult"]);
_Drink_Query.dtCreateTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtCreateTime"]);
}
else
{
bExist = false;
}
return(_Drink_Query);
}
private void Awake()
{
instance = this;
List <string[]> tagDataList = InstanceLoad.GetInstanceData("Texts/TagData");
foreach (string[] insDataArr in tagDataList)
{
Tag tag = new Tag(int.Parse(insDataArr[0]), insDataArr[1], insDataArr[2]);
tags.Add(tag);
}
List <string[]> drinkDataList = InstanceLoad.GetInstanceData("Texts/DrinkData");
foreach (string[] insDataArr in drinkDataList)
{
DrinkInfo drink = new DrinkInfo(int.Parse(insDataArr[0]), int.Parse(insDataArr[1]), insDataArr[2], insDataArr[3]);
drinks.Add(drink);
}
List <string[]> drinkTagList = InstanceLoad.GetInstanceData("Texts/DrinkTagData");
foreach (string[] insDataArr in drinkTagList)
{
DrinkTag drinkTag = new DrinkTag(int.Parse(insDataArr[0].ToString().Trim()), insDataArr[1], insDataArr[2], insDataArr[3]);
drinkTags.Add(drinkTag);
}
}
/// <summary>
/// 获得数据List
/// </summary>
public DrinkInfoArray GetDrinkDataList(DrinkQueryParam QueryCondition)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from VIEW_Drink_query where dtCreateTime >= @dtBeginTime and dtCreateTime <= @dtEndTime ");
strSql.Append(GetWhere(QueryCondition));
strSql.Append(" order by dtCreateTime desc");
SqlParameter[] sqlParams =
{
new SqlParameter("dtBeginTime", QueryCondition.dtBeginTime),
new SqlParameter("dtEndTime", QueryCondition.dtEndTime),
new SqlParameter("strPlaceID", QueryCondition.PlaceId),
new SqlParameter("strAreaGUID", QueryCondition.strJwdId),
new SqlParameter("strWorkShopGUID", QueryCondition.WorkShopGUID),
new SqlParameter("strTrainmanNumber", QueryCondition.TrainmanNumber),
new SqlParameter("nVerifyID", QueryCondition.VerifyID),
new SqlParameter("nWorkTypeID", QueryCondition.DrinkTypeID),
new SqlParameter("nDrinkResult", QueryCondition.DrinkResultID),
new SqlParameter("strTrainmanName", QueryCondition.TrainmanName + "%"),
new SqlParameter("nCadreTypeID", QueryCondition.CadreTypeID),
new SqlParameter("strDepartmentID", QueryCondition.DepartmentID),
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DrinkInfoArray list = new DrinkInfoArray();
foreach (DataRow dr in dt.Rows)
{
DrinkInfo _Drink_Query = new DrinkInfo();
DrinkDataRowToModel(_Drink_Query, dr);
list.Add(_Drink_Query);
}
return(list);
}
private Dictionary <string, int> ToDrinkDict(DrinkInfo drink)
//get a dictionary and translate that to a drinkInfo
{
Dictionary <string, int> info = new Dictionary <string, int>();
info.Add("Poison", drink.ingredient1);
info.Add("Apple", drink.ingredient2);
info.Add("Sth", drink.ingredient3);
info.Add("4", drink.ingredient4);
info.Add("5", drink.ingredient5);
return(info);
}
static DrinkTag Func1(DrinkInst inst)
{
//蜂蜜数量大于等于2，得到甜蜜十足tag
DrinkInfo targetDrink = DrinkData.instance.GetDrinkInfo(inst.drinkName);
if (DrinkData.instance.itemData[16].itemNumber >= 2)
{
return(DrinkData.instance.drinkTags[1]);
}
else
{
return(null);
}
}
static DrinkTag Func0(DrinkInst inst)
{
//冰块数量大于等于2，得到冰凉一夏tag
DrinkInfo targetDrink = DrinkData.instance.GetDrinkInfo(inst.drinkName);
if (DrinkData.instance.itemData[4].itemNumber >= 2)
{
return(DrinkData.instance.drinkTags[0]);
}
else
{
return(null);
}
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DrinkDataRowToModel(DrinkInfo model, DataRow dr)
{
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.nDrinkResult = ObjectConvertClass.static_ext_int(dr["nDrinkResult"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.nVerifyID = ObjectConvertClass.static_ext_int(dr["nVerifyID"]);
model.nWorkTypeID = ObjectConvertClass.static_ext_int(dr["nWorkTypeID"]);
model.strWorkTypeName = ObjectConvertClass.static_ext_string(dr["strWorkTypeName"]);
model.strDrinkResultName = ObjectConvertClass.static_ext_string(dr["strDrinkResultName"]);
model.strVerifyName = ObjectConvertClass.static_ext_string(dr["strVerifyName"]);
model.strImagePath = ObjectConvertClass.static_ext_string(dr["strImagePath"]);
model.nid = ObjectConvertClass.static_ext_int(dr["nid"]);
//人员
model.strTrainmanGUID = ObjectConvertClass.static_ext_string(dr["strTrainmanGUID"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
//车次
model.strTrainNo = ObjectConvertClass.static_ext_string(dr["strTrainNo"]);
model.strTrainNumber = ObjectConvertClass.static_ext_string(dr["strTrainNumber"]);
model.strTrainTypeName = ObjectConvertClass.static_ext_string(dr["strTrainTypeName"]);
//出勤点
model.strPlaceID = ObjectConvertClass.static_ext_string(dr["strPlaceID"]);
model.strPlaceName = ObjectConvertClass.static_ext_string(dr["strPlaceName"]);
model.strSiteGUID = ObjectConvertClass.static_ext_string(dr["strSiteGUID"]);
model.strSiteName = ObjectConvertClass.static_ext_string(dr["strSiteName"]);
//车间
model.strWorkShopGUID = ObjectConvertClass.static_ext_string(dr["strWorkShopGUID"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
//酒精度
model.dwAlcoholicity = ObjectConvertClass.static_ext_int(dr["dwAlcoholicity"]);
model.strWorkID = ObjectConvertClass.static_ext_string(dr["strWorkID"]);
model.strAreaGUID = ObjectConvertClass.static_ext_string(dr["strAreaGUID"]);
model.strDutyGUID = ObjectConvertClass.static_ext_string(dr["strDutyGUID"]);
model.strDutyName = ObjectConvertClass.static_ext_string(dr["strDutyName"]);
model.strDutyNumber = ObjectConvertClass.static_ext_string(dr["strDutyNumber"]);
if (!(dr["bLocalAreaTrainman"] is DBNull))
{
model.bLocalAreaTrainman = Convert.ToBoolean(dr["bLocalAreaTrainman"]);
}
model.strSiteNumber = ObjectConvertClass.static_ext_string(dr["strSiteNumber"]);
model.strDepartmentID = ObjectConvertClass.static_ext_string(dr["strDepartmentID"]);
model.strDepartmentName = ObjectConvertClass.static_ext_string(dr["strDepartmentName"]);
model.nCadreTypeID = ObjectConvertClass.static_ext_string(dr["nCadreTypeID"]);
model.strCadreTypeName = ObjectConvertClass.static_ext_string(dr["strCadreTypeName"]);
}
public void Set(DrinkInfo drinkInfo)
{
GetComponent <Image>().color = new Color(0, 0, 0, 0.5f);
Transform baseInfo = transform.GetChild(1);
baseInfo.gameObject.SetActive(true);
// 画像
StartCoroutine(SetImage(drinkInfo.imageUrl, baseInfo.GetChild(0).GetComponent <RawImage>()));
// 名前、カテゴリー、ベース
baseInfo.GetChild(1).GetComponent <Text>().text = drinkInfo.primaryName != "" ? drinkInfo.primaryName : "ー";
baseInfo.GetChild(1).GetChild(0).GetComponent <Text>().text = drinkInfo.category.name != "" ? drinkInfo.category.name : "ー";
baseInfo.GetChild(1).GetChild(1).GetComponent <Text>().text = drinkInfo.drinkBase.name != "" ? drinkInfo.drinkBase.name : "ー";
// 味
baseInfo.GetChild(3).GetChild(0).GetComponent <Text>().text = drinkInfo.taste != "" ? drinkInfo.taste : "ー";
// 度数
SetDegreeGauge(baseInfo.GetChild(4).GetChild(0), drinkInfo.minDegree, drinkInfo.maxDegree);
// パターンA
if (drinkInfo.category.viewType == DrinkInfo.ViewType.Cocktail)
{
// 構成要素
SetCompornents(baseInfo.GetChild(5), drinkInfo.compornents);
// パターンB
}
else
{
baseInfo.GetChild(5).gameObject.SetActive(false);
Transform patternB = baseInfo.GetChild(6);
patternB.gameObject.SetActive(true);
// 産地
patternB.GetChild(0).GetChild(0).GetComponent <Text>().text = drinkInfo.location != "" ? drinkInfo.location : "ー";
// 出典
sourceUrl = drinkInfo.source.url;
if (sourceUrl == "")
{
patternB.GetChild(1).gameObject.SetActive(false);
}
else
{
patternB.GetChild(1).GetChild(0).GetComponent <Text>().text = sourceUrl;
}
}
}
private void DrinkInfoDataRowToModel(DrinkInfo model, DataRow dr)
{
model.strGUID = ObjectConvertClass.static_ext_string(dr["strGUID"]);
model.strTrainmanNumber = ObjectConvertClass.static_ext_string(dr["strTrainmanNumber"]);
model.strTrainmanName = ObjectConvertClass.static_ext_string(dr["strTrainmanName"]);
model.strWorkShopName = ObjectConvertClass.static_ext_string(dr["strWorkShopName"]);
model.nDrinkResult = ObjectConvertClass.static_ext_int(dr["nDrinkResult"]);
model.strDrinkResultName = ObjectConvertClass.static_ext_string(dr["strDrinkResultName"]);
model.dtCreateTime = ObjectConvertClass.static_ext_date(dr["dtCreateTime"]);
model.nVerifyID = ObjectConvertClass.static_ext_int(dr["nVerifyID"]);
model.strVerifyName = ObjectConvertClass.static_ext_string(dr["strVerifyName"]);
model.nWorkTypeID = ObjectConvertClass.static_ext_int(dr["nWorkTypeID"]);
model.strWorkTypeName = ObjectConvertClass.static_ext_string(dr["strWorkTypeName"]);
model.strImagePath = ObjectConvertClass.static_ext_string(dr["strImagePath"]);
model.strDepartmentID = ObjectConvertClass.static_ext_string(dr["strDepartmentID"]);
model.strDepartmentName = ObjectConvertClass.static_ext_string(dr["strDepartmentName"]);
model.nCadreTypeID = ObjectConvertClass.static_ext_string(dr["nCadreTypeID"]);
model.strCadreTypeName = ObjectConvertClass.static_ext_string(dr["strCadreTypeName"]);
}
/// <summary>
/// 获得一个实体对象
/// </summary>
public DrinkInfo GetDrinkInfo(string strGUID, out Boolean bExist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * FROM VIEW_Drink_Query where strGUID='" + strGUID + "'");
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0];
DrinkInfo _Drink_Query = null;
if (dt.Rows.Count > 0)
{
bExist = true;
_Drink_Query = new DrinkInfo();
DrinkInfoDataRowToModel(_Drink_Query, dt.Rows[0]);
}
else
{
bExist = false;
}
return(_Drink_Query);
}
public DrinkInfo GetTrainmanDrinkInfo(string strTrainmanGUID, string strTrainPlanGUID, int WorkType, out Boolean bExist)
{
StringBuilder strSql = new StringBuilder();
switch (WorkType)
{
case 2: //出勤
strSql.Append("select * from TAB_Drink_Information where strWorkID = (");
strSql.Append("select top 1 strBeginWorkGUID from TAB_Plan_BeginWork where ");
strSql.Append(" strTrainPlanGUID = @strTrainPlanGUID and strTrainmanGUID = @strTrainmanGUID) ORDER BY dtCreateTime DESC");
break;
case 3: //退勤
strSql.Append("select * from TAB_Drink_Information where strWorkID = (");
strSql.Append("select top 1 strEndWorkGUID from TAB_Plan_EndWork where ");
strSql.Append(" strTrainPlanGUID = @strTrainPlanGUID and strTrainmanGUID = @strTrainmanGUID) ORDER BY dtCreateTime DESC");
break;
}
SqlParameter[] sqlParams =
{
new SqlParameter("strTrainPlanGUID", strTrainPlanGUID),
new SqlParameter("strTrainmanGUID", strTrainmanGUID),
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
DrinkInfo _Drink_Query = null;
if (dt.Rows.Count > 0)
{
bExist = true;
_Drink_Query = new DrinkInfo();
_Drink_Query.nDrinkResult = ObjectConvertClass.static_ext_int(dt.Rows[0]["nDrinkResult"]);
_Drink_Query.dtCreateTime = ObjectConvertClass.static_ext_date(dt.Rows[0]["dtCreateTime"]);
_Drink_Query.strImagePath = ObjectConvertClass.static_ext_string(dt.Rows[0]["strImagePath"]);
//DrinkDataRowToModel(_Drink_Query, dt.Rows[0]);
}
else
{
bExist = false;
}
return(_Drink_Query);
}
public async Task <JsonResult> Drinks()
{
//string emailAddress = HttpContext.User.Identity.Name;
string emailAddress = Request.Headers["emailAddress"];
var restaurant = await _context.Restaurant
.Where(rest => rest.Id == 1)
.FirstOrDefaultAsync();
List <DrinkInfo> drinksToReturn = new List <DrinkInfo>();
List <Drink> restaurantDrinks = await _context.Drink
.Where(d => d.RestaurantId == restaurant.Id)
.ToListAsync();
foreach (Drink drink in restaurantDrinks)
{
DrinkInfo drinkInfo = new DrinkInfo(drink.Name, drink.Price, drink.Description, drink.HouseSpecial, drink.AgeRestricted);
drinksToReturn.Add(drinkInfo);
}
return(new JsonResult(drinksToReturn));
}
//[ValidateAntiForgeryToken]
public async Task <JsonResult> CreateDrink([FromBody] DrinkInfo drinkInfo)
{
string emailAddress = HttpContext.User.Identity.Name;
var restaurant = await _context.Restaurant
.Where(rest => rest.EmailAddress.Equals(emailAddress))
.FirstOrDefaultAsync();
if (checkDrinkNameInSameRestaurant(drinkInfo.Name, restaurant.Id))
{
HttpContext.Response.StatusCode = 400;
return(new JsonResult("Drink " + drinkInfo.Name + " already exists in restaurant"));
}
Drink newDrink = new Drink
{
Name = drinkInfo.Name,
Description = drinkInfo.Description,
Price = drinkInfo.Price,
HouseSpecial = drinkInfo.HouseSpecial,
AgeRestricted = drinkInfo.AgeRestricted
};
if (ModelState.IsValid)
{
newDrink.RestaurantId = restaurant.Id;
_context.Add(newDrink);
await _context.SaveChangesAsync();
//return RedirectToAction(nameof(Index), new { id = id });
}
HttpContext.Response.StatusCode = 200;
return(new JsonResult("Drink successfully created"));
}
public async Task <IActionResult> EditDrink([FromBody] DrinkInfo drinkInfo)
{
string emailAddress = HttpContext.User.Identity.Name;
var restaurant = await _context.Restaurant
.Where(rest => rest.EmailAddress.Equals(emailAddress))
.FirstOrDefaultAsync();
string drinkName = Request.Headers["drinkName"];
Drink drinkToUpdate = await _context.Drink
.Where(d => d.Name.Equals(drinkName))
.FirstOrDefaultAsync();
drinkToUpdate.Name = drinkInfo.Name;
drinkToUpdate.Price = drinkInfo.Price;
drinkToUpdate.Description = drinkInfo.Description;
drinkToUpdate.HouseSpecial = drinkInfo.HouseSpecial;
drinkToUpdate.AgeRestricted = drinkInfo.AgeRestricted;
if (ModelState.IsValid)
{
try
{
_context.Update(drinkToUpdate);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
}
HttpContext.Response.StatusCode = 200;
return(new JsonResult("Drink successfully updated"));
}
public MDDrink4Msg getModel(DrinkInfo model)
{
MDDrink4Msg msg = new MDDrink4Msg();
msg.nLocalAreaTrainman = model.bLocalAreaTrainman == true ? 0 : 1;
msg.trainmanID = model.strTrainmanGUID;
msg.strTrainmanNumber = model.strTrainmanNumber;
msg.strTrainmanName = model.strTrainmanName;
msg.dwAlcoholicity = model.dwAlcoholicity.ToString();
msg.drinkResult = model.nDrinkResult.ToString();
msg.createTime = model.dtCreateTime.ToString();
msg.strTrainNo = model.strTrainNo;
msg.strTrainNumber = model.strTrainNumber;
msg.strTrainTypeName = model.strTrainTypeName;
msg.strPlaceID = model.strPlaceID;
msg.strPlaceName = model.strPlaceName;
msg.strSiteGUID = model.strSiteGUID;
msg.strSiteName = model.strSiteName;
msg.strWorkShopGUID = model.strWorkShopGUID;
msg.strWorkShopName = model.strWorkShopName;
msg.strAreaGUID = model.strAreaGUID;
msg.verifyID = model.nVerifyID;
msg.strWorkID = model.strWorkID;
msg.workTypeID = model.nWorkTypeID;
msg.imagePath = model.strImagePath;
msg.strDepartmentID = model.strDepartmentID;
msg.strDepartmentName = model.strDepartmentName;
msg.nCadreTypeID = model.nCadreTypeID;
msg.strCadreTypeName = model.strCadreTypeName;
msg.strGuid = model.strGUID;
msg.oPlaceId = "";
msg.dutyUserID = model.strDutyGUID;
msg.nWorkTypeID = model.nWorkTypeID;
msg.msgType = MSGTYPE.MSG_DRINK;
return(msg);
}
public async Task insert(TABLE type, List <string> data)
{
print_info("inserting data into database");
switch (type)
{
case TABLE.DRINKS:
DrinkInfo drink = new DrinkInfo
{
UserId = data.ElementAt(0),
Gin = data.ElementAt(1),
Tonic = data.ElementAt(2),
Garnish = data.ElementAt(3),
Description = data.ElementAt(4),
Id = data.ElementAt(1) + data.ElementAt(2) + data.ElementAt(3)
};
var drink_collection = database.GetCollection <DrinkInfo>("drinks");
if (search(TABLE.DRINKS, drink.Id).Count() > 0)
{
print_error("drink already exists");
return;
}
print_info("adding drink to database");
drink_collection.InsertOne(drink);
break;
case TABLE.RATING:
RatingInfo rating = new RatingInfo
{
Id = ObjectId.GenerateNewId(),
UserId = data.ElementAt(0),
DrinkId = data.ElementAt(1),
Rating = int.Parse(data.ElementAt(2)),
Comment = data.ElementAt(3),
Helpfull = 0,
Unhelpfull = 0
};
var rating_collection = database.GetCollection <RatingInfo>("ratings");
var rating_result = search(TABLE.RATING, rating.UserId);
foreach (var r in rating_result)
{
var res = (RatingInfo)r;
if (res.DrinkId == rating.DrinkId)
{
print_error("rating for drink by user already exists");
return;
}
}
print_info("adding rating to database");
rating_collection.InsertOne(rating);
break;
case TABLE.USER:
UserInfo user = new UserInfo
{
Id = data.ElementAt(0)
};
var user_collection = database.GetCollection <UserInfo>("users");
if (search(TABLE.USER, user.Id).Count() > 0)
{
print_error("user already exists");
return;
}
print_info("adding user to database");
user_collection.InsertOne(user);
break;
default:
print_error("OBI-WAN");
break;
}
}
/// <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);
}
public virtual SimpleDrink Create(DrinkInfo drink)
{
return(new SimpleDrink(drink));
}
