public bool DeleteSerialBookByBookNumber(string strBook_Number, string strSavedBy, DateTime dtFrom, DateTime dtTo, ref string strResponse)
{
bool result = false;
strResponse = string.Empty;
using (Promotion.DataModel.SerialResult_BO objSerialResult_BO = new SerialResult_BO())
{
DataModel.SerialResult objSerialResult = objSerialResult_BO.GetByBook_numberAndInput_time(strBook_Number, dtFrom, dtTo);
if (objSerialResult != null)
{
string strSerials = objSerialResult.Serials;
string[] Serials = null;
if (strSerials.Length > 0)
{
strSerials = strSerials.Substring(0, strSerials.Length - 1);
Serials = strSerials.Split("|".ToCharArray());
}
else
{
ArrayList arrTmp = new ArrayList();
Serials = (string[])arrTmp.ToArray(typeof(string));
}
log.Info(strSerials);
using (Promotion.DataModel.DelSerial_BO objDelSerial_BO = new DelSerial_BO())
{
for (int nIndex = 0; nIndex < Serials.Length; nIndex++)
{
DelSerial objDelSerial = new DelSerial();
objDelSerial.book_number = objSerialResult.book_number;
objDelSerial.Serial = Serials[nIndex];
objDelSerial.input_time = DateTime.Now;
objDelSerial.SavedBy = strSavedBy;
objDelSerial_BO.CreateDelSerial(objDelSerial);
log.Info(strBook_Number + ": Xóa " + Serials[nIndex]);
}
}
objSerialResult.DeletedBy = strSavedBy;
objSerialResult.DeletedDate = DateTime.Now;
objSerialResult_BO.DeleteSerialResult(objSerialResult);
result = true;
}
else
{
strResponse = string.Format("Số sổ {0} không tồn tại.", strBook_Number);
log.Info(strResponse);
}
}
return(result);
}
public SerialBook GetSerialBookResultByBookNumber(string strBookNumber, DateTime dtFrom, DateTime dtTo)
{
SerialBook arr = new SerialBook();
using (DataModel.SerialResult_BO objSerialResult_BO = new SerialResult_BO())
{
DataModel.SerialResult objSerialResult = objSerialResult_BO.GetByBook_numberAndInput_time(strBookNumber, dtFrom, dtTo);
if (objSerialResult != null)
{
arr = ConvertTo(objSerialResult);
}
else
{
arr = null;
}
}
return(arr);
}
private SerialBook ConvertTo(DataModel.SerialResult objSerialResult)
{
SerialBook oItem = new SerialBook();
oItem.ID = objSerialResult.id;
oItem.Customer_Id = objSerialResult.customer_id;
oItem.Customer_Name = objSerialResult.customer_name;
oItem.CMTND = objSerialResult.CMND;
oItem.Telephone = objSerialResult.tel;
oItem.Book_Number = objSerialResult.book_number;
oItem.TotalAmount = objSerialResult.amount.Value;
oItem.Period = objSerialResult.kyhan;
oItem.Currency = objSerialResult.currency;
oItem.ValueDate = objSerialResult.EFFECT_DATE.Value;
oItem.PeriodInWord = objSerialResult.TERM;
oItem.MaturityDate = objSerialResult.MATURITY_DATE.Value;
oItem.Sector = objSerialResult.Sector;
oItem.TERM = objSerialResult.TERM;
oItem.CO_CODE = objSerialResult.CO_CODE;
oItem.ACCOUNT_NUMBER = objSerialResult.ACCT_NUM;
oItem.DAO_CODE = objSerialResult.DAO_CODE;
oItem.ACCOUNT_NUMBER = objSerialResult.DEPT_CODE;
try
{
oItem.Times = objSerialResult.Times.Value;
}
catch { oItem.Times = 1; }
try
{
oItem.InputTime = objSerialResult.Input_time.Value;
}
catch { }
try
{
oItem.SavedBy = objSerialResult.SavedBy;
}
catch
{
}
//process serials
string strSerials = objSerialResult.Serials;
if (strSerials.Length > 0)
{
strSerials = strSerials.Substring(0, strSerials.Length - 1);
string[] Serials = strSerials.Split("|".ToCharArray());
oItem.Masoduthuongs = Serials;
}
else
{
ArrayList arrTmp = new ArrayList();
oItem.Masoduthuongs = (string[])arrTmp.ToArray(typeof(string));
}
try
{
oItem.cMoney = objSerialResult.cMoney.Value;
}
catch { oItem.cMoney = 0; }
try
{
oItem.Seq = objSerialResult.Seq.Value;
}
catch { oItem.Seq = 0; }
return(oItem);
}
