/// <summary> /// 更新一条数据 /// </summary> public bool Update(DBAccess.Model.BatteryModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Battery set "); strSql.Append("batModuleID=@batModuleID,"); strSql.Append("batPackID=@batPackID,"); strSql.Append("batModuleAsmTime=@batModuleAsmTime"); strSql.Append(" where batteryID=@batteryID "); SqlParameter[] parameters = { new SqlParameter("@batModuleID", SqlDbType.NVarChar, 50), new SqlParameter("@batPackID", SqlDbType.NVarChar, 50), new SqlParameter("@batModuleAsmTime", SqlDbType.DateTime), new SqlParameter("@batteryID", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.batModuleID; parameters[1].Value = model.batPackID; parameters[2].Value = model.batModuleAsmTime; parameters[3].Value = model.batteryID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DBAccess.Model.BatteryModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Battery("); strSql.Append("batteryID,batModuleID,batPackID,batModuleAsmTime)"); strSql.Append(" values ("); strSql.Append("@batteryID,@batModuleID,@batPackID,@batModuleAsmTime)"); SqlParameter[] parameters = { new SqlParameter("@batteryID", SqlDbType.NVarChar, 50), new SqlParameter("@batModuleID", SqlDbType.NVarChar, 50), new SqlParameter("@batPackID", SqlDbType.NVarChar, 50), new SqlParameter("@batModuleAsmTime", SqlDbType.DateTime) }; parameters[0].Value = model.batteryID; parameters[1].Value = model.batModuleID; parameters[2].Value = model.batPackID; parameters[3].Value = model.batModuleAsmTime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DBAccess.Model.BatteryModel DataRowToModel(DataRow row) { DBAccess.Model.BatteryModel model = new DBAccess.Model.BatteryModel(); if (row != null) { if (row["batteryID"] != null) { model.batteryID = row["batteryID"].ToString(); } if (row["batModuleID"] != null) { model.batModuleID = row["batModuleID"].ToString(); } if (row["batPackID"] != null) { model.batPackID = row["batPackID"].ToString(); } if (row["batModuleAsmTime"] != null && row["batModuleAsmTime"].ToString() != "") { model.batModuleAsmTime = DateTime.Parse(row["batModuleAsmTime"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public DBAccess.Model.BatteryModel GetModel(string batteryID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 batteryID,batModuleID,batPackID,batModuleAsmTime from Battery "); strSql.Append(" where batteryID=@batteryID "); SqlParameter[] parameters = { new SqlParameter("@batteryID", SqlDbType.NVarChar, 50) }; parameters[0].Value = batteryID; DBAccess.Model.BatteryModel model = new DBAccess.Model.BatteryModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }