/// <summary>
/// 更新抄表本
/// </summary>
/// <param name="MODELmeterReading"></param>
/// <returns></returns>
public bool Update(MODELmeterReading MODELmeterReading)
{
StringBuilder str = new StringBuilder();
str.Append("UPDATE meterReading SET meterReadingNO=@meterReadingNO,loginId=@loginId,areaId=@areaId,CHARGERID=@CHARGERID,createDate=@createDate,MEMO=@MEMO ");
str.Append("WHERE meterReadingID=@meterReadingID");
SqlParameter[] para =
{
new SqlParameter("@meterReadingNO", SqlDbType.VarChar, 50),
new SqlParameter("@loginId", SqlDbType.VarChar, 50),
new SqlParameter("@areaId", SqlDbType.VarChar, 50),
new SqlParameter("@CHARGERID", SqlDbType.VarChar, 50),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@MEMO", SqlDbType.VarChar, 200),
new SqlParameter("@meterReadingID", SqlDbType.VarChar, 50)
};
para[0].Value = MODELmeterReading.meterReadingNO;
para[1].Value = MODELmeterReading.loginId;
para[2].Value = MODELmeterReading.AREAID;
para[3].Value = MODELmeterReading.CHARGERID;
para[4].Value = MODELmeterReading.createDate;
para[5].Value = MODELmeterReading.MEMO;
para[6].Value = MODELmeterReading.meterReadingID;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加新的抄表本
/// </summary>
/// <param name="MODELmeterReading"></param>
/// <returns></returns>
public bool Insert(MODELmeterReading MODELmeterReading)
{
StringBuilder str = new StringBuilder();
str.Append("INSERT INTO meterReading(meterReadingID,meterReadingNO,loginId,areaId,CHARGERID,createDate,MEMO) ");
str.Append("VALUES(@meterReadingID,@meterReadingNO,@loginId,@areaId,@CHARGERID,@createDate,@MEMO)");
SqlParameter[] para =
{
new SqlParameter("@meterReadingID", SqlDbType.VarChar, 50),
new SqlParameter("@meterReadingNO", SqlDbType.VarChar, 50),
new SqlParameter("@loginId", SqlDbType.VarChar, 50),
new SqlParameter("@areaId", SqlDbType.VarChar, 50),
new SqlParameter("@CHARGERID", SqlDbType.VarChar, 50),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@MEMO", SqlDbType.VarChar, 200)
};
para[0].Value = MODELmeterReading.meterReadingID;
para[1].Value = MODELmeterReading.meterReadingNO;
para[2].Value = MODELmeterReading.loginId;
para[3].Value = MODELmeterReading.AREAID;
para[4].Value = MODELmeterReading.CHARGERID;
para[5].Value = MODELmeterReading.createDate;
para[6].Value = MODELmeterReading.MEMO;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
