/// <summary> /// 得到一个对象实体 /// </summary> public DBinterface.Model.Meter_Model GetModel(string MeterID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MeterID,waterMeterStartNumber,MeterState,waterUserId,waterMeterPositionName,waterMeterPositionId,waterMeterSizeId,waterMeterTypeId,WATERFIXVALUE,waterMeterProduct,waterMeterSerialNumber,waterMeterMode,isSummaryMeter,waterMeterParentId,waterMeterMagnification,waterMeterMaxRange,waterMeterProofreadingDate,waterMeteProofreadingPeriod,STARTUSEDATETIME,MEMO,CreateDate,ScrapDate,ScrapReason from Meter "); strSql.Append(" where MeterID=@MeterID "); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.VarChar, 50) }; parameters[0].Value = MeterID; DBinterface.Model.Meter_Model model = new DBinterface.Model.Meter_Model(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DBinterface.Model.Meter_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Meter("); strSql.Append("MeterID,waterMeterStartNumber,MeterState,waterUserId,waterMeterPositionName,waterMeterPositionId,waterMeterSizeId,waterMeterTypeId,WATERFIXVALUE,waterMeterProduct,waterMeterSerialNumber,waterMeterMode,isSummaryMeter,waterMeterParentId,waterMeterMagnification,waterMeterMaxRange,waterMeterProofreadingDate,waterMeteProofreadingPeriod,STARTUSEDATETIME,MEMO,CreateDate,ScrapDate,ScrapReason)"); strSql.Append(" values ("); strSql.Append("@MeterID,@waterMeterStartNumber,@MeterState,@waterUserId,@waterMeterPositionName,@waterMeterPositionId,@waterMeterSizeId,@waterMeterTypeId,@WATERFIXVALUE,@waterMeterProduct,@waterMeterSerialNumber,@waterMeterMode,@isSummaryMeter,@waterMeterParentId,@waterMeterMagnification,@waterMeterMaxRange,@waterMeterProofreadingDate,@waterMeteProofreadingPeriod,@STARTUSEDATETIME,@MEMO,@CreateDate,@ScrapDate,@ScrapReason)"); SqlParameter[] parameters = { new SqlParameter("@MeterID", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterStartNumber", SqlDbType.Int, 4), new SqlParameter("@MeterState", SqlDbType.TinyInt, 1), new SqlParameter("@waterUserId", SqlDbType.VarChar, 30), new SqlParameter("@waterMeterPositionName", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterPositionId", SqlDbType.VarChar, 30), new SqlParameter("@waterMeterSizeId", SqlDbType.VarChar, 30), new SqlParameter("@waterMeterTypeId", SqlDbType.VarChar, 30), new SqlParameter("@WATERFIXVALUE", SqlDbType.Int, 4), new SqlParameter("@waterMeterProduct", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterSerialNumber", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterMode", SqlDbType.VarChar, 50), new SqlParameter("@isSummaryMeter", SqlDbType.VarChar, 10), new SqlParameter("@waterMeterParentId", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterMagnification", SqlDbType.Int, 4), new SqlParameter("@waterMeterMaxRange", SqlDbType.Int, 4), new SqlParameter("@waterMeterProofreadingDate", SqlDbType.DateTime), new SqlParameter("@waterMeteProofreadingPeriod", SqlDbType.Int, 4), new SqlParameter("@STARTUSEDATETIME", SqlDbType.DateTime), new SqlParameter("@MEMO", SqlDbType.VarChar, 200), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ScrapDate", SqlDbType.DateTime), new SqlParameter("@ScrapReason", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.MeterID; parameters[1].Value = model.waterMeterStartNumber; parameters[2].Value = model.MeterState; parameters[3].Value = model.waterUserId; parameters[4].Value = model.waterMeterPositionName; parameters[5].Value = model.waterMeterPositionId; parameters[6].Value = model.waterMeterSizeId; parameters[7].Value = model.waterMeterTypeId; parameters[8].Value = model.WATERFIXVALUE; parameters[9].Value = model.waterMeterProduct; parameters[10].Value = model.waterMeterSerialNumber; parameters[11].Value = model.waterMeterMode; parameters[12].Value = model.isSummaryMeter; parameters[13].Value = model.waterMeterParentId; parameters[14].Value = model.waterMeterMagnification; parameters[15].Value = model.waterMeterMaxRange; parameters[16].Value = model.waterMeterProofreadingDate; parameters[17].Value = model.waterMeteProofreadingPeriod; parameters[18].Value = model.STARTUSEDATETIME; parameters[19].Value = model.MEMO; parameters[20].Value = model.CreateDate; parameters[21].Value = model.ScrapDate; parameters[22].Value = model.ScrapReason; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DBinterface.Model.Meter_Model DataRowToModel(DataRow row) { DBinterface.Model.Meter_Model model = new DBinterface.Model.Meter_Model(); if (row != null) { if (row["MeterID"] != null) { model.MeterID = row["MeterID"].ToString(); } if (row["waterMeterStartNumber"] != null && row["waterMeterStartNumber"].ToString() != "") { model.waterMeterStartNumber = int.Parse(row["waterMeterStartNumber"].ToString()); } if (row["MeterState"] != null && row["MeterState"].ToString() != "") { model.MeterState = int.Parse(row["MeterState"].ToString()); } if (row["waterUserId"] != null) { model.waterUserId = row["waterUserId"].ToString(); } if (row["waterMeterPositionName"] != null) { model.waterMeterPositionName = row["waterMeterPositionName"].ToString(); } if (row["waterMeterPositionId"] != null) { model.waterMeterPositionId = row["waterMeterPositionId"].ToString(); } if (row["waterMeterSizeId"] != null) { model.waterMeterSizeId = row["waterMeterSizeId"].ToString(); } if (row["waterMeterTypeId"] != null) { model.waterMeterTypeId = row["waterMeterTypeId"].ToString(); } if (row["WATERFIXVALUE"] != null && row["WATERFIXVALUE"].ToString() != "") { model.WATERFIXVALUE = int.Parse(row["WATERFIXVALUE"].ToString()); } if (row["waterMeterProduct"] != null) { model.waterMeterProduct = row["waterMeterProduct"].ToString(); } if (row["waterMeterSerialNumber"] != null) { model.waterMeterSerialNumber = row["waterMeterSerialNumber"].ToString(); } if (row["waterMeterMode"] != null) { model.waterMeterMode = row["waterMeterMode"].ToString(); } if (row["isSummaryMeter"] != null) { model.isSummaryMeter = row["isSummaryMeter"].ToString(); } if (row["waterMeterParentId"] != null) { model.waterMeterParentId = row["waterMeterParentId"].ToString(); } if (row["waterMeterMagnification"] != null && row["waterMeterMagnification"].ToString() != "") { model.waterMeterMagnification = int.Parse(row["waterMeterMagnification"].ToString()); } if (row["waterMeterMaxRange"] != null && row["waterMeterMaxRange"].ToString() != "") { model.waterMeterMaxRange = int.Parse(row["waterMeterMaxRange"].ToString()); } if (row["waterMeterProofreadingDate"] != null && row["waterMeterProofreadingDate"].ToString() != "") { model.waterMeterProofreadingDate = DateTime.Parse(row["waterMeterProofreadingDate"].ToString()); } if (row["waterMeteProofreadingPeriod"] != null && row["waterMeteProofreadingPeriod"].ToString() != "") { model.waterMeteProofreadingPeriod = int.Parse(row["waterMeteProofreadingPeriod"].ToString()); } if (row["STARTUSEDATETIME"] != null && row["STARTUSEDATETIME"].ToString() != "") { model.STARTUSEDATETIME = DateTime.Parse(row["STARTUSEDATETIME"].ToString()); } if (row["MEMO"] != null) { model.MEMO = row["MEMO"].ToString(); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["ScrapDate"] != null && row["ScrapDate"].ToString() != "") { model.ScrapDate = DateTime.Parse(row["ScrapDate"].ToString()); } if (row["ScrapReason"] != null) { model.ScrapReason = row["ScrapReason"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DBinterface.Model.Meter_Model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Meter set "); strSql.Append("waterMeterStartNumber=@waterMeterStartNumber,"); strSql.Append("MeterState=@MeterState,"); strSql.Append("waterUserId=@waterUserId,"); strSql.Append("waterMeterPositionName=@waterMeterPositionName,"); strSql.Append("waterMeterPositionId=@waterMeterPositionId,"); strSql.Append("waterMeterSizeId=@waterMeterSizeId,"); strSql.Append("waterMeterTypeId=@waterMeterTypeId,"); strSql.Append("WATERFIXVALUE=@WATERFIXVALUE,"); strSql.Append("waterMeterProduct=@waterMeterProduct,"); strSql.Append("waterMeterSerialNumber=@waterMeterSerialNumber,"); strSql.Append("waterMeterMode=@waterMeterMode,"); strSql.Append("isSummaryMeter=@isSummaryMeter,"); strSql.Append("waterMeterParentId=@waterMeterParentId,"); strSql.Append("waterMeterMagnification=@waterMeterMagnification,"); strSql.Append("waterMeterMaxRange=@waterMeterMaxRange,"); strSql.Append("waterMeterProofreadingDate=@waterMeterProofreadingDate,"); strSql.Append("waterMeteProofreadingPeriod=@waterMeteProofreadingPeriod,"); strSql.Append("STARTUSEDATETIME=@STARTUSEDATETIME,"); strSql.Append("MEMO=@MEMO,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("ScrapDate=@ScrapDate,"); strSql.Append("ScrapReason=@ScrapReason"); strSql.Append(" where MeterID=@MeterID "); SqlParameter[] parameters = { new SqlParameter("@waterMeterStartNumber", SqlDbType.Int, 4), new SqlParameter("@MeterState", SqlDbType.TinyInt, 1), new SqlParameter("@waterUserId", SqlDbType.VarChar, 30), new SqlParameter("@waterMeterPositionName", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterPositionId", SqlDbType.VarChar, 30), new SqlParameter("@waterMeterSizeId", SqlDbType.VarChar, 30), new SqlParameter("@waterMeterTypeId", SqlDbType.VarChar, 30), new SqlParameter("@WATERFIXVALUE", SqlDbType.Int, 4), new SqlParameter("@waterMeterProduct", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterSerialNumber", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterMode", SqlDbType.VarChar, 50), new SqlParameter("@isSummaryMeter", SqlDbType.VarChar, 10), new SqlParameter("@waterMeterParentId", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterMagnification", SqlDbType.Int, 4), new SqlParameter("@waterMeterMaxRange", SqlDbType.Int, 4), new SqlParameter("@waterMeterProofreadingDate", SqlDbType.DateTime), new SqlParameter("@waterMeteProofreadingPeriod", SqlDbType.Int, 4), new SqlParameter("@STARTUSEDATETIME", SqlDbType.DateTime), new SqlParameter("@MEMO", SqlDbType.VarChar, 200), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ScrapDate", SqlDbType.DateTime), new SqlParameter("@ScrapReason", SqlDbType.NVarChar, 50), new SqlParameter("@MeterID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.waterMeterStartNumber; parameters[1].Value = model.MeterState; parameters[2].Value = model.waterUserId; parameters[3].Value = model.waterMeterPositionName; parameters[4].Value = model.waterMeterPositionId; parameters[5].Value = model.waterMeterSizeId; parameters[6].Value = model.waterMeterTypeId; parameters[7].Value = model.WATERFIXVALUE; parameters[8].Value = model.waterMeterProduct; parameters[9].Value = model.waterMeterSerialNumber; parameters[10].Value = model.waterMeterMode; parameters[11].Value = model.isSummaryMeter; parameters[12].Value = model.waterMeterParentId; parameters[13].Value = model.waterMeterMagnification; parameters[14].Value = model.waterMeterMaxRange; parameters[15].Value = model.waterMeterProofreadingDate; parameters[16].Value = model.waterMeteProofreadingPeriod; parameters[17].Value = model.STARTUSEDATETIME; parameters[18].Value = model.MEMO; parameters[19].Value = model.CreateDate; parameters[20].Value = model.ScrapDate; parameters[21].Value = model.ScrapReason; parameters[22].Value = model.MeterID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }