public int UpdateCowLiteInfo(CowLite cowLite) { string sql = string.Format(@"UPDATE Base_Cow SET GroupID ={0},HouseID = {1} WHERE EarNum = '{2}'", cowLite.GroupID, cowLite.HouseID, cowLite.EarNum); return(dataProvider1mutong.ExecuteNonQuery(sql, CommandType.Text)); }
public CowLite GetCowLiteInfo(string displayEarNum) { int earNum = ConvertDislayEarNumToEarNum(displayEarNum, UserBLL.Instance.CurrentUser.Pasture.ID); DataTable dt = this.dalCow.GetCowLiteInfo(earNum); if (dt.Rows.Count == 0) { return(null); } else { CowLite cow = new CowLite(); cow.DisplayEarNum = displayEarNum; cow.HouseID = Convert.ToInt32(dt.Rows[0]["HouseID"]); cow.HouseName = dt.Rows[0]["HouseName"].ToString(); cow.GroupID = Convert.ToInt32(dt.Rows[0]["GroupID"]); cow.GroupName = dt.Rows[0]["GroupName"].ToString(); return(cow); } }
public JsonResult GetCowLiteInfo(string displayEarNum) { CowLite cow = this.bllCow.GetCowLiteInfo(displayEarNum); return(Json(cow, JsonRequestBehavior.AllowGet)); }