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