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