/// <summary>
/// 更¨1新?一°?条??数oy据Y
/// </summary>
public bool Update(Parking.Core.Model.FN_MONITOR_VERSION_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FN_MONITOR_VERSION_INFO set ");
strSql.Append("VERSION_NUMBER=@VERSION_NUMBER,");
strSql.Append("RELEASE_TIME=@RELEASE_TIME,");
strSql.Append("UPLOAD_TIME=@UPLOAD_TIME,");
strSql.Append("VERSION_DESC=@VERSION_DESC,");
strSql.Append("DOWNLOAD_URL=@DOWNLOAD_URL,");
strSql.Append("CHECK_CODE=@CHECK_CODE,");
strSql.Append("FILE_SIZE=@FILE_SIZE,");
strSql.Append("UPLOAD_USERID=@UPLOAD_USERID,");
strSql.Append("UPGRADE_DESC=@UPGRADE_DESC");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@VERSION_NUMBER", SqlDbType.VarChar, 100),
new SqlParameter("@RELEASE_TIME", SqlDbType.DateTime),
new SqlParameter("@UPLOAD_TIME", SqlDbType.DateTime),
new SqlParameter("@VERSION_DESC", SqlDbType.VarChar, 4000),
new SqlParameter("@DOWNLOAD_URL", SqlDbType.VarChar, 4000),
new SqlParameter("@CHECK_CODE", SqlDbType.VarChar, 100),
new SqlParameter("@FILE_SIZE", SqlDbType.Decimal, 9),
new SqlParameter("@UPLOAD_USERID", SqlDbType.VarChar, 32),
new SqlParameter("@UPGRADE_DESC", SqlDbType.Text),
new SqlParameter("@ID", SqlDbType.VarChar, 32)
};
parameters[0].Value = model.VERSION_NUMBER;
parameters[1].Value = model.RELEASE_TIME;
parameters[2].Value = model.UPLOAD_TIME;
parameters[3].Value = model.VERSION_DESC;
parameters[4].Value = model.DOWNLOAD_URL;
parameters[5].Value = model.CHECK_CODE;
parameters[6].Value = model.FILE_SIZE;
parameters[7].Value = model.UPLOAD_USERID;
parameters[8].Value = model.UPGRADE_DESC;
parameters[9].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得ì?到ì?一°?个?对?象¨?实o|ì体??
/// </summary>
public Parking.Core.Model.FN_MONITOR_VERSION_INFO DataRowToModel(DataRow row)
{
Parking.Core.Model.FN_MONITOR_VERSION_INFO model = new Parking.Core.Model.FN_MONITOR_VERSION_INFO();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["VERSION_NUMBER"] != null)
{
model.VERSION_NUMBER = row["VERSION_NUMBER"].ToString();
}
if (row["RELEASE_TIME"] != null && row["RELEASE_TIME"].ToString() != "")
{
model.RELEASE_TIME = DateTime.Parse(row["RELEASE_TIME"].ToString());
}
if (row["UPLOAD_TIME"] != null && row["UPLOAD_TIME"].ToString() != "")
{
model.UPLOAD_TIME = DateTime.Parse(row["UPLOAD_TIME"].ToString());
}
if (row["VERSION_DESC"] != null)
{
model.VERSION_DESC = row["VERSION_DESC"].ToString();
}
if (row["DOWNLOAD_URL"] != null)
{
model.DOWNLOAD_URL = row["DOWNLOAD_URL"].ToString();
}
if (row["CHECK_CODE"] != null)
{
model.CHECK_CODE = row["CHECK_CODE"].ToString();
}
if (row["FILE_SIZE"] != null && row["FILE_SIZE"].ToString() != "")
{
model.FILE_SIZE = decimal.Parse(row["FILE_SIZE"].ToString());
}
if (row["UPLOAD_USERID"] != null)
{
model.UPLOAD_USERID = row["UPLOAD_USERID"].ToString();
}
if (row["UPGRADE_DESC"] != null)
{
model.UPGRADE_DESC = row["UPGRADE_DESC"].ToString();
}
}
return(model);
}
/*
* /// <summary>
* /// 分¤?页°3获?取¨?数oy据Y列￠D表à¨a
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "FN_MONITOR_VERSION_INFO";
* parameters[1].Value = "ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
public Parking.Core.Model.FN_MONITOR_VERSION_INFO GetByVersion(string Version)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from FN_MONITOR_VERSION_INFO WHERE VERSION_NUMBER = '" + Version + "'");
Parking.Core.Model.FN_MONITOR_VERSION_INFO model = new Parking.Core.Model.FN_MONITOR_VERSION_INFO();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增?加¨?一°?条??数oy据Y
/// </summary>
public bool Add(Parking.Core.Model.FN_MONITOR_VERSION_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FN_MONITOR_VERSION_INFO(");
strSql.Append("ID,VERSION_NUMBER,RELEASE_TIME,UPLOAD_TIME,VERSION_DESC,DOWNLOAD_URL,CHECK_CODE,FILE_SIZE,UPLOAD_USERID,UPGRADE_DESC)");
strSql.Append(" values (");
strSql.Append("@ID,@VERSION_NUMBER,@RELEASE_TIME,@UPLOAD_TIME,@VERSION_DESC,@DOWNLOAD_URL,@CHECK_CODE,@FILE_SIZE,@UPLOAD_USERID,@UPGRADE_DESC)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 32),
new SqlParameter("@VERSION_NUMBER", SqlDbType.VarChar, 100),
new SqlParameter("@RELEASE_TIME", SqlDbType.DateTime),
new SqlParameter("@UPLOAD_TIME", SqlDbType.DateTime),
new SqlParameter("@VERSION_DESC", SqlDbType.VarChar, 4000),
new SqlParameter("@DOWNLOAD_URL", SqlDbType.VarChar, 4000),
new SqlParameter("@CHECK_CODE", SqlDbType.VarChar, 100),
new SqlParameter("@FILE_SIZE", SqlDbType.Decimal, 9),
new SqlParameter("@UPLOAD_USERID", SqlDbType.VarChar, 32),
new SqlParameter("@UPGRADE_DESC", SqlDbType.Text)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.VERSION_NUMBER;
parameters[2].Value = model.RELEASE_TIME;
parameters[3].Value = model.UPLOAD_TIME;
parameters[4].Value = model.VERSION_DESC;
parameters[5].Value = model.DOWNLOAD_URL;
parameters[6].Value = model.CHECK_CODE;
parameters[7].Value = model.FILE_SIZE;
parameters[8].Value = model.UPLOAD_USERID;
parameters[9].Value = model.UPGRADE_DESC;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得ì?到ì?一°?个?对?象¨?实o|ì体??
/// </summary>
public Parking.Core.Model.FN_MONITOR_VERSION_INFO GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,VERSION_NUMBER,RELEASE_TIME,UPLOAD_TIME,VERSION_DESC,DOWNLOAD_URL,CHECK_CODE,FILE_SIZE,UPLOAD_USERID,UPGRADE_DESC from FN_MONITOR_VERSION_INFO ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 32)
};
parameters[0].Value = ID;
Parking.Core.Model.FN_MONITOR_VERSION_INFO model = new Parking.Core.Model.FN_MONITOR_VERSION_INFO();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
