private static void Add(MoveoutFormEntity entity) { var sql = string.Format(@"insert into moveout_form({0}) values(@p_id, @p_hospital_id, @p_form_no, @p_applyer, @p_apply_time, @p_new_storeroom_id, @p_scan_over, @p_confirm_user_id, @p_confirm_datetime, @p_created_id, @p_created_time, @p_updated_id, @p_updated_time)", COLUMN_SQL); entity.Id = Guid.NewGuid().ToString(); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, entity.Id); db.AddInParameter(dc, "p_hospital_id", DbType.String, entity.HospitalId); db.AddInParameter(dc, "p_form_no", DbType.Int32, entity.FormNo); db.AddInParameter(dc, "p_applyer", DbType.String, entity.Applyer); db.AddInParameter(dc, "p_apply_time", DbType.DateTime, entity.ApplyTime); db.AddInParameter(dc, "p_new_storeroom_id", DbType.String, entity.NewStoreroomId); db.AddInParameter(dc, "p_scan_over", DbType.Boolean, entity.ScanOver); db.AddInParameter(dc, "p_confirm_user_id", DbType.String, DBNull.Value); db.AddInParameter(dc, "p_confirm_datetime", DbType.DateTime, DBNull.Value); db.AddInParameter(dc, "p_created_id", DbType.String, entity.CreatedId); db.AddInParameter(dc, "p_created_time", DbType.DateTime, entity.CreatedTime); db.AddInParameter(dc, "p_updated_id", DbType.String, entity.UpdatedId); db.AddInParameter(dc, "p_updated_time", DbType.DateTime, entity.UpdatedTime); db.ExecuteNonQuery(dc); }
public static void Save(MoveoutFormEntity entity) { if (string.IsNullOrEmpty(entity.Id)) { Add(entity); } else { Update(entity); } }
public static IList <MoveoutFormEntity> Query(DateRangeCondition condition, PagerInfo pager) { pager.ComputePageCount(QueryCount(condition)); var list = new List <MoveoutFormEntity>(); var orderSql = " ORDER BY "; if (pager.OrderFields.Count > 0) { foreach (var field in pager.OrderFields) { orderSql += field.Field + (field.Desc ? " DESC" : "") + ","; } } else { orderSql += "form_no DESC"; } var sql = string.Format(@"SELECT {0} FROM moveout_form WHERE is_active = 1 and {1}", COLUMN_SQL, GetConditionSql(condition)); sql = @"SELECT * FROM ( SELECT ROW_NUMBER() OVER(" + orderSql + @") pid," + COLUMN_SQL + @" FROM (" + sql + @") t ) t1 WHERE t1.pid BETWEEN @p_pageNo * @p_pageSize + 1 AND (@p_pageNo + 1) * @p_pageSize "; var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); AddParameter(dc, db, condition); db.AddInParameter(dc, "p_pageNo", DbType.Int32, pager.PageIndex); db.AddInParameter(dc, "p_pageSize", DbType.Int32, pager.PageSize); using (IDataReader reader = db.ExecuteReader(dc)) { while (reader.Read()) { var entity = new MoveoutFormEntity(); entity.Init(reader); list.Add(entity); } } return(list); }
private static void Update(MoveoutFormEntity entity) { var sql = @"update moveout_form set new_storeroom_id=@p_new_storeroom_id, updated_id=@p_updated_id, updated_time=@p_updated_time where id=@p_id"; var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, entity.Id); db.AddInParameter(dc, "p_new_storeroom_id", DbType.String, entity.NewStoreroomId); db.AddInParameter(dc, "p_updated_id", DbType.String, entity.UpdatedId); db.AddInParameter(dc, "p_updated_time", DbType.DateTime, entity.UpdatedTime); db.ExecuteNonQuery(dc); }
private static string CreateMoveinForm(MoveoutFormEntity moveout, string userId, Database db, DbTransaction trans) { var now = DateTime.Now; var movein = new MoveinFormEntity { MoveoutFormNo = moveout.FormNo, MoveoutId = moveout.Id, ScanOver = false, CreatedId = userId, CreatedTime = now, UpdatedId = userId, UpdatedTime = now }; MoveinFormRepository.Save(movein, db, trans); return(movein.Id); }
public static MoveoutFormEntity Get(string id) { var sql = string.Format("select {0} from moveout_form where is_active=1 and id=@p_id", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, id); using (var reader = db.ExecuteReader(dc)) { if (reader.Read()) { var entity = new MoveoutFormEntity(); entity.Init(reader); return(entity); } } return(null); }
public void Save(MoveoutFormEntity entity) { MoveoutFormRepository.Save(entity); }