Beispiel #1
0
        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));
        }
Beispiel #2
0
        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);
            }
        }
Beispiel #3
0
        public JsonResult GetCowLiteInfo(string displayEarNum)
        {
            CowLite cow = this.bllCow.GetCowLiteInfo(displayEarNum);

            return(Json(cow, JsonRequestBehavior.AllowGet));
        }