public static void Pass(ReceiveFormEntity form)
{
var db = DatabaseFactory.CreateDatabase();
using (var conn = db.CreateConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
Update(form, db, trans);
//TODO: need to add inspection form
CreateIncomingForm(form, db, trans);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}
public static string PartPass(ReceiveFormEntity form, IList <string> barcodes, string userId)
{
var newSerialId = form.SerialId;
var db = DatabaseFactory.CreateDatabase();
using (var conn = db.CreateConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
newSerialId = ReceiveFormRepository.PartPass(form, barcodes, userId, db, trans);
var incomingService = new IncomingFormEntity
IncomingFormEntity formIncoming = incomingService.GetBySerialId(newSerialId);
formIncoming.ConfirmedTime = DateTime.Now;
incomingService.Pass(formIncoming);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(serialId);
}
private static ReceiveFormEntity Get(string id, Database db, DbTransaction trans)
{
var sql = string.Format("select {0} from receive_form where id=@p_id", COLUMN_SQL);
if (db == null)
{
db = DatabaseFactory.CreateDatabase();
}
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, id);
ReceiveFormEntity entity = null;
using (var reader = (trans == null ? db.ExecuteReader(dc) : db.ExecuteReader(dc, trans)))
{
while (reader.Read())
{
entity = new ReceiveFormEntity();
entity.Init(reader);
break;
}
}
return(entity);
}
public static IList <ReceiveFormEntity> GetReceives(int formNo, string hospitalID)
{
var sql = string.Format("select {0} from receive_form where order_form_no=@p_form_no and hospital_id=@p_hospital_id", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_form_no", DbType.Int32, formNo);
db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalID);
var list = new List <ReceiveFormEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new ReceiveFormEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
public static void Pass(ReceiveFormEntity form, Database db, DbTransaction trans)
{
Update(form, db, trans);
//TODO: need to add inspection form
CreateIncomingForm(form, db, trans);
}
public static string PartPass(ReceiveFormEntity form, IList <string> barcodes, string userId)
{
var serialId = form.SerialId;
var passedCount = SumPassed(form.Id);
if (form.ReceivedCount == passedCount)
{
return(serialId);
}
if (form.ReceivedCount == passedCount + barcodes.Count)
{
Pass(form);
return(serialId);
}
var goodsSerial = GoodsSerialRepository.Get(form.SerialId);
var db = DatabaseFactory.CreateDatabase();
using (var conn = db.CreateConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
var formItem = new ReceiveFormItemEntity
{
Id = Guid.NewGuid().ToString(),
ReceiveId = form.Id,
ReceivedCount = barcodes.Count,
ConfirmedId = userId,
ConfirmedTime = DateTime.Now
};
formItem.SerialId = CreateGoodsSerial(goodsSerial, formItem, barcodes, db, trans);
CreateItem(formItem, db, trans);
//TODO: need to add inspection form
CreateIncomingForm(form, formItem, db, trans);
trans.Commit();
serialId = formItem.SerialId;
}
catch
{
trans.Rollback();
throw;
}
}
}
return(serialId);
}
private static void Update(ReceiveFormEntity form, Database db, DbTransaction trans)
{
var sql = @"update receive_form set is_confirmed=@p_is_confirmed,confirmed_id=@p_confirmed_id,confirmed_time=@p_confirmed_time where id=@p_id";
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, form.Id);
db.AddInParameter(dc, "p_is_confirmed", DbType.String, form.IsConfirmed);
db.AddInParameter(dc, "p_confirmed_id", DbType.String, form.ConfirmedId);
db.AddInParameter(dc, "p_confirmed_time", DbType.DateTime, form.ConfirmedTime.Equals(DBNull.Value) ? DateTime.Now : form.ConfirmedTime);
db.ExecuteNonQuery(dc, trans);
}
private static void CreateReceiveForm(DispatchFormEntity form, DispatchFormItemEntity formItem, Database db, DbTransaction trans)
{
var receiveForm = new ReceiveFormEntity
{
OrderId = form.OrderId,
OrderFormNo = form.OrderFormNo,
OrderDetailId = form.OrderDetailId,
ApplyUnitId = form.ApplyUnitId,
SerialId = formItem.SerialId,
ProductId = form.ProductId,
ReceivedCount = formItem.Count,
HospitalId = form.HospitalId,
VendorId = form.VendorId,
CreatedId = form.ChangedId,
CreatedTime = form.ChangedTime
};
ReceiveFormRepository.Create(receiveForm, db, trans);
}
public static void Pass(ReceiveFormEntity form)
{
var db = DatabaseFactory.CreateDatabase();
using (var conn = db.CreateConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}
public static ReceiveFormEntity GetBySerialId(string serialId)
{
var sql = string.Format("select {0} from receive_form where serial_id=@p_serial_id", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "p_serial_id", DbType.String, serialId);
using (var reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
var entity = new ReceiveFormEntity();
entity.Init(reader);
return(entity);
}
}
return(null);
}
internal static void Create(ReceiveFormEntity entity, Database db, DbTransaction trans)
{
var sql = @"insert into receive_form
(
id,order_id,order_form_no,order_detail_id,apply_unit_id,serial_id,product_id,received_count,hospital_id,vendor_id,is_confirmed,created_id,created_time
)
values(
@p_id,@p_order_id,@p_order_form_no,@p_order_detail_id,@p_apply_unit_id,@p_serial_id,@p_product_id,@p_received_count,
@p_hospital_id,@p_vendor_id,@p_is_confirmed,@p_created_id,@p_created_time
)";
var dc = db.GetSqlStringCommand(sql);
entity.Id = Guid.NewGuid().ToString();
db.AddInParameter(dc, "p_id", DbType.String, entity.Id);
db.AddInParameter(dc, "p_order_id", DbType.String, entity.OrderId);
db.AddInParameter(dc, "p_order_form_no", DbType.Int32, entity.OrderFormNo);
db.AddInParameter(dc, "p_order_detail_id", DbType.String, entity.OrderDetailId);
db.AddInParameter(dc, "p_apply_unit_id", DbType.String, entity.ApplyUnitId);
db.AddInParameter(dc, "p_serial_id", DbType.String, entity.SerialId);
db.AddInParameter(dc, "p_product_id", DbType.String, entity.ProductId);
db.AddInParameter(dc, "p_received_count", DbType.Int32, entity.ReceivedCount);
db.AddInParameter(dc, "p_hospital_id", DbType.String, entity.HospitalId);
db.AddInParameter(dc, "p_vendor_id", DbType.String, entity.VendorId);
db.AddInParameter(dc, "p_is_confirmed", DbType.Boolean, entity.IsConfirmed);
db.AddInParameter(dc, "p_created_id", DbType.String, entity.CreatedId);
db.AddInParameter(dc, "p_created_time", DbType.DateTime, entity.CreatedTime);
db.ExecuteNonQuery(dc, trans);
GoodsSerialFormRepository.FlowNextForm(new GoodsSerialFormEntity
{
SerialId = entity.SerialId,
FormId = entity.Id,
FormKind = FormKind.Receive,
CreatedId = entity.CreatedId,
CreatedTime = entity.CreatedTime
}, db, trans);
}
private static string CreateIncomingForm(ReceiveFormEntity form, ReceiveFormItemEntity formItem, Database db, DbTransaction trans)
{
var incoming = new IncomingFormEntity
{
OrderId = form.OrderId,
OrderFormNo = form.OrderFormNo,
OrderDetailId = form.OrderDetailId,
ApplyUnitId = form.ApplyUnitId,
SerialId = formItem.SerialId,
ProductId = form.ProductId,
IncomingCount = formItem.ReceivedCount,
HospitalId = form.HospitalId,
VendorId = form.VendorId,
IsConfirmed = false,
CreatedId = formItem.ConfirmedId,
CreatedTime = formItem.ConfirmedTime
};
IncomingFormRepository.Create(incoming, db, trans);
return(incoming.Id);
}
public static string PartPass(ReceiveFormEntity form, IList <string> barcodes, string userId, Database db, DbTransaction trans)
{
var serialId = form.SerialId;
var passedCount = SumPassed(form.Id);
if (form.ReceivedCount == passedCount)
{
return(serialId);
}
if (form.ReceivedCount == passedCount + barcodes.Count)
{
Pass(form);
return(serialId);
}
var goodsSerial = GoodsSerialRepository.Get(form.SerialId);
var formItem = new ReceiveFormItemEntity
{
Id = Guid.NewGuid().ToString(),
ReceiveId = form.Id,
ReceivedCount = barcodes.Count,
ConfirmedId = userId,
ConfirmedTime = DateTime.Now
};
formItem.SerialId = CreateGoodsSerial(goodsSerial, formItem, barcodes, db, trans);
CreateItem(formItem, db, trans);
//TODO: need to add inspection form
CreateIncomingForm(form, formItem, db, trans);
serialId = formItem.SerialId;
return(serialId);
}
