public ActionResult Update2(tbl_app_Versions tb) { //tbl_app_Versions ts = new tbl_app_Versions(); if (tb.UpdateConnent.ToString().Length == 0) { return(Content(@"<script>alert('修改内容不能为空');</script>")); } else { } if (tb.Version_Number == "" || tb.Version_Number == null) { return(Content(@"<script>alert('版本编号不能为空');location.href='Update'</script>")); } else if (tb.VersionCode == null) { return(Content(@"<script>alert('版本标识不能为空');location.href='Update'</script>")); } else { APPManager.upDate(tb); return(RedirectToAction("HistoryVersion")); } }
public static tbl_app_Versions load2(int PKID) { List <tbl_app_Versions> vers = new List <tbl_app_Versions>(); string sql = @" SELECT * FROM Configuration.dbo.tbl_app_Versions WITH (NOLOCK) WHERE PKID = @PKID "; List <SqlParameter> list = new List <SqlParameter>() { new SqlParameter("@PKID", PKID) }; tbl_app_Versions tb = new tbl_app_Versions(); DataTable dt = SqlHelper.ExecuteDataTable(connOnRead, CommandType.Text, sql, list.ToArray()); if (dt.Rows.Count > 0) { tb.Version_Number = dt.Rows[0]["Version_Number"].ToString(); tb.VersionCode = dt.Rows[0]["VersionCode"] != DBNull.Value ? Convert.ToInt32(dt.Rows[0]["VersionCode"]) : 0; tb.MustUpdate = dt.Rows[0]["MustUpdate"] != DBNull.Value ? Convert.ToInt32(dt.Rows[0]["MustUpdate"]) : 0; tb.CreateTime = Convert.ToDateTime(dt.Rows[0]["CreateTime"]); tb.LastUpdateTime = Convert.ToDateTime(dt.Rows[0]["LastUpdateTime"]); tb.Download_Number = Convert.ToInt32(dt.Rows[0]["Download_Number"]); tb.Download = dt.Rows[0]["Download"].ToString(); tb.UpdateConnent = dt.Rows[0]["UpdateConnent"].ToString(); tb.PKID = Convert.ToInt32(dt.Rows[0]["PKID"]); vers.Add(tb); } return(tb); }
public static int upDate(tbl_app_Versions tb) { string sql = @"UPDATE Configuration.dbo.tbl_app_Versions SET UpdateConnent = @UpdateConnent , Version_Number = @Version_Number , VersionCode = @VersionCode , MustUpdate = @MustUpdate , LastUpdateTime = GETDATE() WHERE PKID = @PKID"; var sqlparams = new SqlParameter[] { new SqlParameter("@UpdateConnent", tb.UpdateConnent), new SqlParameter("@Version_Number", tb.Version_Number), new SqlParameter("@MustUpdate", tb.MustUpdate), new SqlParameter("@VersionCode", tb.VersionCode), new SqlParameter("@PKID", tb.PKID), }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlparams)); }
public static int upDate(tbl_app_Versions tb) { return(APPDAL.upDate(tb)); }