public static recsys_quotation_package_items CopyQuotationPackageItem(recsys_quotation_package_items target)
{
recsys_quotation_package_items result = new recsys_quotation_package_items();
Member _member = new Member("users");
if (target != null)
{
result.code = target.code;
result.detail_chi = target.detail_chi;
result.detail_eng = target.detail_eng;
result.id = 0;
result.update_date = System.DateTime.Now;
result.nSequence = target.nSequence;
result.price = target.price;
result.update_by = (int)_member.infoBySession("id");
result.create_date = System.DateTime.Now;
result.create_by = (int)_member.infoBySession("id");
result.status = 1;
}
return result;
}
/// <summary>
/// Create a new recsys_quotation_package_items object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="quotation_package_id">Initial value of the quotation_package_id property.</param>
/// <param name="code">Initial value of the code property.</param>
/// <param name="create_date">Initial value of the create_date property.</param>
/// <param name="create_by">Initial value of the create_by property.</param>
/// <param name="status">Initial value of the status property.</param>
public static recsys_quotation_package_items Createrecsys_quotation_package_items(global::System.Int32 id, global::System.Int32 quotation_package_id, global::System.String code, global::System.DateTime create_date, global::System.Int32 create_by, global::System.Byte status)
{
recsys_quotation_package_items recsys_quotation_package_items = new recsys_quotation_package_items();
recsys_quotation_package_items.id = id;
recsys_quotation_package_items.quotation_package_id = quotation_package_id;
recsys_quotation_package_items.code = code;
recsys_quotation_package_items.create_date = create_date;
recsys_quotation_package_items.create_by = create_by;
recsys_quotation_package_items.status = status;
return recsys_quotation_package_items;
}
public JsonResult BatchInsertProcess(FormCollection elements)
{
bool isSuccess = false;
double? total = 0.0;
List<recsys_quotation_package_items> items = new List<recsys_quotation_package_items>();
string quotationPackageIDString = elements["hfQuotationPackageID"];
int quotationPackageID;
int maxItemSequence = 0;
if (int.TryParse(quotationPackageIDString, out quotationPackageID))
{
try
{
IEnumerable<int?> itemsSequences = from qpi in this._db.recsys_quotation_package_items
where qpi.quotation_package_id == quotationPackageID && qpi.status == 1
select qpi.nSequence;
maxItemSequence = itemsSequences.Where(theSequence => theSequence.HasValue).Max().Value;
}
catch
{
//# log down
}
try
{
IEnumerable<string> itemsCodes = from qpi in this._db.recsys_quotation_package_items
where qpi.quotation_package_id == quotationPackageID && qpi.status == 1
select qpi.code;
if (maxItemSequence >= 0)
{
string[] codes = elements.GetValues("tbCode");
foreach (string code in itemsCodes)
{
for (int i = 0; i < codes.Length; i++)
{
if (!string.IsNullOrEmpty(codes[i]) && !string.IsNullOrEmpty(codes[i].Trim()) && codes[i].Trim().ToUpper() == code.Trim().ToUpper())
{
string message = "已有Quotation Package item (" + codes[i] + ")";
return Json(new
{
bIsSuccess = false,
warningMessage = message
});
}
}
}
string[] details_chi = elements.GetValues("tbDetails_chi");
string[] details_eng = elements.GetValues("tbDetails_eng");
string[] prices = elements.GetValues("tbPrice");
int itemsCount = codes.Count();
int sequenceCumulation = maxItemSequence;
for (int i = 0; i < itemsCount; i++)
{
recsys_quotation_package_items item = new recsys_quotation_package_items();
double price = 0;
Member _member = new Member("users");
if (!string.IsNullOrEmpty(codes[i]))
item.code = codes[i].Trim();
else
item.code = "";
item.detail_chi = details_chi[i];
item.detail_eng = details_eng[i];
if (string.IsNullOrEmpty(prices[i]))
{
item.price = 0.00;
}
else
{
double.TryParse(prices[i], out price);
item.price = price;
}
item.status = 1;
item.create_date = DateTime.Now;
item.create_by = (int)_member.infoBySession("id");
item.update_date = DateTime.Now;
item.update_by = (int)_member.infoBySession("id");
if (!string.IsNullOrEmpty(item.detail_chi) ||
!string.IsNullOrEmpty(item.detail_eng) ||
!string.IsNullOrEmpty(item.code))
{
item.nSequence = ++sequenceCumulation;
item.quotation_package_id = quotationPackageID;
this._db.recsys_quotation_package_items.AddObject(item);
try
{
this._db.SaveChanges();
isSuccess = true;
}
catch (OptimisticConcurrencyException)
{
//# log down
}
}
}
//update quotation package total price
total = (from qpi in this._db.recsys_quotation_package_items
where qpi.quotation_package_id == quotationPackageID && qpi.status == 1
select qpi.price).Sum();
recsys_quotation_packages quotationPackage = this._db.recsys_quotation_packages.FirstOrDefault(qp => qp.id == quotationPackageID);
quotationPackage.price = total!=null?total:0.0;
try
{
this._db.SaveChanges();
isSuccess = true;
}
catch (OptimisticConcurrencyException)
{
//# log down
}
}
}
catch
{
//# log down
}
}
return Json(new
{
total = total,
isSuccess = isSuccess
});
}
/// <summary>
/// Deprecated Method for adding a new object to the recsys_quotation_package_items EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTorecsys_quotation_package_items(recsys_quotation_package_items recsys_quotation_package_items)
{
base.AddObject("recsys_quotation_package_items", recsys_quotation_package_items);
}
