/// <summary> /// 更新一条数据 /// </summary> public bool Update(PrinterManagerProject.Model.tBatch_for_View model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tBatch_for_View set "); strSql.Append("batch=@batch,"); strSql.Append("batch_name=@batch_name,"); strSql.Append("start_time=@start_time,"); strSql.Append("end_time=@end_time"); strSql.Append(" where batch=@batch and batch_name=@batch_name and start_time=@start_time and end_time=@end_time "); SqlParameter[] parameters = { new SqlParameter("@batch", SqlDbType.VarChar, 10), new SqlParameter("@batch_name", SqlDbType.VarChar, 10), new SqlParameter("@start_time", SqlDbType.VarChar, 10), new SqlParameter("@end_time", SqlDbType.VarChar, 10) }; parameters[0].Value = model.batch; parameters[1].Value = model.batch_name; parameters[2].Value = model.start_time; parameters[3].Value = model.end_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(PrinterManagerProject.Model.tBatch_for_View model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tBatch_for_View("); strSql.Append("batch,batch_name,start_time,end_time)"); strSql.Append(" values ("); strSql.Append("@batch,@batch_name,@start_time,@end_time)"); SqlParameter[] parameters = { new SqlParameter("@batch", SqlDbType.VarChar, 10), new SqlParameter("@batch_name", SqlDbType.VarChar, 10), new SqlParameter("@start_time", SqlDbType.VarChar, 10), new SqlParameter("@end_time", SqlDbType.VarChar, 10) }; parameters[0].Value = model.batch; parameters[1].Value = model.batch_name; parameters[2].Value = model.start_time; parameters[3].Value = model.end_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public PrinterManagerProject.Model.tBatch_for_View GetModel(string batch, string batch_name, string start_time, string end_time) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 batch,batch_name,start_time,end_time from tBatch_for_View "); strSql.Append(" where batch=@batch and batch_name=@batch_name and start_time=@start_time and end_time=@end_time "); SqlParameter[] parameters = { new SqlParameter("@batch", SqlDbType.VarChar, 10), new SqlParameter("@batch_name", SqlDbType.VarChar, 10), new SqlParameter("@start_time", SqlDbType.VarChar, 10), new SqlParameter("@end_time", SqlDbType.VarChar, 10) }; parameters[0].Value = batch; parameters[1].Value = batch_name; parameters[2].Value = start_time; parameters[3].Value = end_time; PrinterManagerProject.Model.tBatch_for_View model = new PrinterManagerProject.Model.tBatch_for_View(); 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 PrinterManagerProject.Model.tBatch_for_View DataRowToModel(DataRow row) { PrinterManagerProject.Model.tBatch_for_View model = new PrinterManagerProject.Model.tBatch_for_View(); if (row != null) { if (row["batch"] != null) { model.batch = row["batch"].ToString(); } if (row["batch_name"] != null) { model.batch_name = row["batch_name"].ToString(); } if (row["start_time"] != null) { model.start_time = row["start_time"].ToString(); } if (row["end_time"] != null) { model.end_time = row["end_time"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(PrinterManagerProject.Model.tBatch_for_View model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(PrinterManagerProject.Model.tBatch_for_View model) { return(dal.Add(model)); }