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);
}
