/// <summary>
/// 数据条数
/// </summary>
/// <param name="model">模型</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>对象列表</returns>
public int SelectCount(Sales_Return model = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Sales_Return>();
if (model != null)
{
if (!model.Id.IsNullOrEmpty())
{
query.Where(p => p.Id == model.Id);
}
if (!model.DetailId.IsNullOrEmpty())
{
query.Where(p => p.DetailId == model.DetailId);
}
if (!model.ReturnText.IsNullOrEmpty())
{
query.Where(p => p.ReturnText == model.ReturnText);
}
if (!model.ISRetuen.IsNullOrEmpty())
{
query.Where(p => p.ISRetuen == model.ISRetuen);
}
if (!model.ReturnReason.IsNullOrEmpty())
{
query.Where(p => p.ReturnReason == model.ReturnReason);
}
}
return(query.GetQueryCount(connection, transaction));
}
/// <summary>
/// 根据模型删除数据
/// </summary>
/// <param name="model">模型</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>是否成功</returns>
public bool DeleteModel(Sales_Return model = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var delete = new LambdaDelete <Sales_Return>();
if (model != null)
{
if (!model.Id.IsNullOrEmpty())
{
delete.Where(p => p.Id == model.Id);
}
if (!model.DetailId.IsNullOrEmpty())
{
delete.Where(p => p.DetailId == model.DetailId);
}
if (!model.ReturnText.IsNullOrEmpty())
{
delete.Where(p => p.ReturnText == model.ReturnText);
}
if (!model.ISRetuen.IsNullOrEmpty())
{
delete.Where(p => p.ISRetuen == model.ISRetuen);
}
if (!model.ReturnReason.IsNullOrEmpty())
{
delete.Where(p => p.ReturnReason == model.ReturnReason);
}
}
return(delete.GetDeleteResult(connection, transaction));
}
/// <summary>
/// 根据模型更新
/// </summary>
/// <param name="model">模型</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>是否成功</returns>
public bool Update(Sales_Return model, IDbConnection connection = null, IDbTransaction transaction = null)
{
var update = new LambdaUpdate <Sales_Return>();
if (!model.Id.IsNullOrEmpty())
{
update.Where(p => p.Id == model.Id);
}
if (!model.DetailId.IsNullOrEmpty())
{
update.Set(p => p.DetailId == model.DetailId);
}
if (!model.ReturnText.IsNullOrEmpty())
{
update.Set(p => p.ReturnText == model.ReturnText);
}
if (!model.ISRetuen.IsNullOrEmpty())
{
update.Set(p => p.ISRetuen == model.ISRetuen);
}
if (!model.ReturnReason.IsNullOrEmpty())
{
update.Set(p => p.ReturnReason == model.ReturnReason);
}
return(update.GetUpdateResult(connection, transaction));
}
private void btn_Cancel_Click(object sender, EventArgs e)
{
var form2 = new Sales_Return();
form2.Closed += (sender1, args) => this.Close();
this.Close();
}
private void getItemDetails()
{
var ds = Sales_Return.RetrieveData(oCon, txtSearchInput.Text);
grvItemDetails.DataSource = ds;
grvItemDetails.DataBind();
}
private void dgv_Item_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
string itemcode = dgv_Item.CurrentRow.Cells["id"].Value.ToString();
if (itemcode != "")
{
var form2 = new Sales_Return(itemcode);
form2.Closed += (sender1, args) => this.Close();
this.Close();
}
}
/// <summary>
/// 筛选全部数据
/// </summary>
/// <param name="model">模型</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>对象列表</returns>
public List <Sales_Return> SelectAll(Sales_Return model = null, string SelectFiled = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Sales_Return>();
if (model != null)
{
if (!model.Id.IsNullOrEmpty())
{
query.Where(p => p.Id == model.Id);
}
if (!model.DetailId.IsNullOrEmpty())
{
query.Where(p => p.DetailId == model.DetailId);
}
if (!model.ReturnText.IsNullOrEmpty())
{
query.Where(p => p.ReturnText == model.ReturnText);
}
if (!model.ISRetuen.IsNullOrEmpty())
{
query.Where(p => p.ISRetuen == model.ISRetuen);
}
if (!model.ReturnReason.IsNullOrEmpty())
{
query.Where(p => p.ReturnReason == model.ReturnReason);
}
}
if (SelectFiled != null)
{
SelectFiled = SelectFiled.ToLowerInvariant();
if (SelectFiled.Contains("id,"))
{
query.Select(p => new { p.Id });
}
if (SelectFiled.Contains("detailid,"))
{
query.Select(p => new { p.DetailId });
}
if (SelectFiled.Contains("returntext,"))
{
query.Select(p => new { p.ReturnText });
}
if (SelectFiled.Contains("isretuen,"))
{
query.Select(p => new { p.ISRetuen });
}
if (SelectFiled.Contains("returnreason,"))
{
query.Select(p => new { p.ReturnReason });
}
}
return(query.GetQueryList(connection, transaction));
}
private void dgv_sales_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (dgv_sales.CurrentCell.OwningColumn.Name == "RetNumber")
{
int Ret_no = Convert.ToInt32(dgv_sales.CurrentRow.Cells["RetNumber"].Value.ToString());
if (Ret_no > 0)
{
var form2 = new Sales_Return(Ret_no);
form2.ShowDialog();
form2.Dispose();
}
}
}
}
/// <summary>
/// 进行提交退货
/// </summary>
/// <param name="res"></param>
/// <returns></returns>
public string ReturnInfo(Sales_Return res)
{
if (!ReturnCount(res.DetailId.Value))
{
if (Sales_ReturnOper.Instance.Insert(res))
{
return("true");
}
else
{
return("退货信息插入失败！");
}
}
else
{
return("该记录已有退款信息，无法重复提交！");
}
}
private void btn_OK_Click(object sender, EventArgs e)
{
decimal qty = 0;
dtb.Columns.Clear();
dtb.Rows.Clear();
foreach (DataGridViewRow dr in dgv_batchSale.Rows)
{
if (dr.Cells["colReturnQty"].Value != null && dr.Cells["colReturnQty"].Value.ToString() != "")
{
qty = qty + Convert.ToDecimal(dr.Cells["colReturnQty"].Value.ToString());
}
}
if (qty == TotalQty)
{
if (dgv_batchSale.Rows.Count > 0)
{
foreach (DataGridViewColumn col in dgv_batchSale.Columns)
{
dtb.Columns.Add(col.Name);
}
foreach (DataGridViewRow row in dgv_batchSale.Rows)
{
DataRow dRow = dtb.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
dtb.Rows.Add(dRow);
}
}
if (dtb.Rows.Count > 0)
{
var form2 = new Sales_Return(dtb);
form2.Closed += (sender1, args) => this.Close();
this.Close();
}
}
else
{
MessageBox.Show("Please make sure the quanties are equall !..", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 根据模型插入
/// </summary>
/// <param name="model">模型</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>是否成功</returns>
public int InsertReturnKey(Sales_Return model, IDbConnection connection = null, IDbTransaction transaction = null)
{
var insert = new LambdaInsert <Sales_Return>();
if (!model.DetailId.IsNullOrEmpty())
{
insert.Insert(p => p.DetailId == model.DetailId);
}
if (!model.ReturnText.IsNullOrEmpty())
{
insert.Insert(p => p.ReturnText == model.ReturnText);
}
if (!model.ISRetuen.IsNullOrEmpty())
{
insert.Insert(p => p.ISRetuen == model.ISRetuen);
}
if (!model.ReturnReason.IsNullOrEmpty())
{
insert.Insert(p => p.ReturnReason == model.ReturnReason);
}
return(insert.GetInsertResult(connection, transaction));
}
// RequiredFieldValidator rv;
protected void btn1_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
var gvrow = (GridViewRow)btn.NamingContainer;
if (gvrow != null)
{
txtReturn = (gvrow.FindControl("txtAddReturn") as TextBox);
// rv = (gvrow.FindControl("rvReturn") as RequiredFieldValidator);
}
//if (txtReturn.Text.Length < 1)
//{
// //rv.ErrorMessage = "Please enter Value";
// rv.Visible = true;
//}
var sa = (from a in dc.Sales
join s in dc.Order_By_Medical_Stores on a.OrderIDByMS equals s.OrderIDByMS
join obmp in dc.Order_by_Medical_Store_Per_Medicines on s.OrderIDByMS equals obmp.OrderIDByMS
join medi in dc.Medicine_In_Stocks on obmp.MedicineID equals medi.MedicineID
where s.OrderIDByMS == Convert.ToDecimal(Session["OrderID"]) && medi.MedicineName == btn.CommandArgument
select a.SaleID).Single();
var msa = from a in dc.Sales
join sr in dc.Sales_Returns on a.SaleID equals sr.SaleID
join s in dc.Order_By_Medical_Stores on a.OrderIDByMS equals s.OrderIDByMS
join obmp in dc.Order_by_Medical_Store_Per_Medicines on s.OrderIDByMS equals obmp.OrderIDByMS
join medi in dc.Medicine_In_Stocks on obmp.MedicineID equals medi.MedicineID
where sr.SaleID == sa && medi.MedicineName == btn.CommandArgument && obmp.ReturnStatus == "Returned"
select sr;
if (txtReturn.Text != string.Empty)
{
if (msa.Any())
{
foreach (Sales_Return sr in msa)
{
sr.ReturnAmount = sr.ReturnAmount + Convert.ToDecimal(txtReturn.Text);
sr.ReturnDate = DateTime.Now.Date;
}
try
{
dc.SubmitChanges();
}
catch (Exception ex)
{
lblerr.Text = ex.ToString();
}
}
else
{
Sales_Return sr = new Sales_Return
{
SaleID = sa,
ReturnAmount = Convert.ToDecimal(txtReturn.Text),
ReturnDate = DateTime.Now.Date
};
dc.Sales_Returns.InsertOnSubmit(sr);
dc.SubmitChanges();
//mp1.Hide();
}
var ord = from a in dc.Sales
join s in dc.Order_By_Medical_Stores on a.OrderIDByMS equals s.OrderIDByMS
join obmp in dc.Order_by_Medical_Store_Per_Medicines on s.OrderIDByMS equals obmp.OrderIDByMS
join medi in dc.Medicine_In_Stocks on obmp.MedicineID equals medi.MedicineID
where s.OrderIDByMS == Convert.ToDecimal(Session["OrderID"]) && medi.MedicineName == btn.CommandArgument
select obmp; ///get order with the specific medicine
var price = (from a in dc.Medicine_In_Stocks
join b in dc.Order_by_Medical_Store_Per_Medicines on a.MedicineID equals b.MedicineID
where b.OrderIDByMS == Convert.ToDecimal(Session["OrderID"]) && a.MedicineName == btn.CommandArgument
select a.Price).Single();/// get price of that medicine
var orpm = (from a in dc.Medicine_In_Stocks
join b in dc.Order_by_Medical_Store_Per_Medicines on a.MedicineID equals b.MedicineID
where b.OrderIDByMS == Convert.ToDecimal(Session["OrderID"]) && a.MedicineName == btn.CommandArgument
select b.OrderIDByMS).Single(); ///get orderidbymsp of that medicine
foreach (Order_by_Medical_Store_Per_Medicine ords in ord) //make modifications in order per medicine
{
var s = (from a in dc.Medicine_In_Stocks
where a.MedicineID == ords.MedicineID
select a.Price).First();
if (ords.Discount > 0)
{
if (ords.Amount - Convert.ToDecimal(txtReturn.Text) > 0) //discount calculation discountamount=((price*quantity)*discount%)/100)
{ //discount finalized=((price*quantity)-discountamount)
ords.Amount = ords.Amount - Convert.ToDecimal(txtReturn.Text);
ords.ReturnStatus = "Returned";
ords.ReturnDate = DateTime.Now.Date;
ords.ReturnAmount = Convert.ToDecimal(txtReturn.Text);
ords.DiscountAmount = ((price * (ords.Amount - Convert.ToDecimal(txtReturn.Text))) * Convert.ToInt32(ords.Discount)) / 100;
ords.NetAmount = ((ords.Amount - Convert.ToDecimal(txtReturn.Text)) * s) - ords.DiscountAmount;//(price * (ords.Amount - Convert.ToDecimal(txtReturn.Text))) - (((price * (ords.Amount - Convert.ToDecimal(txtReturn.Text))) * Convert.ToInt32(ords.Discount)) / 100);
ords.ReturnNetAmount = price * Convert.ToDecimal(txtReturn.Text);
}
}
else
{
if (ords.Amount - Convert.ToDecimal(txtReturn.Text) > 0) //without discount calculation
{
ords.Amount = ords.Amount - Convert.ToDecimal(txtReturn.Text);
ords.ReturnStatus = "Returned";
ords.ReturnDate = DateTime.Now.Date;
ords.ReturnAmount = Convert.ToDecimal(txtReturn.Text);
//ords.DiscountAmount = ((price * (ords.Amount - Convert.ToDecimal(txtReturn.Text))) * Convert.ToInt32(ords.Discount)) / 100;
ords.NetAmount = (ords.Amount - Convert.ToDecimal(txtReturn.Text)) * s; //(price * (ords.Amount - Convert.ToDecimal(txtReturn.Text))) - (((price * (ords.Amount - Convert.ToDecimal(txtReturn.Text)))));
ords.ReturnNetAmount = price * Convert.ToDecimal(txtReturn.Text);
}
}
lblReturnMessage.Text = "Return Added";
}
try
{
dc.SubmitChanges();
//txtReturn.Text = "Return Added";
}
catch (Exception ex)
{
lblerr.Text = ex.ToString();
}
}
string popupScript = "";
popupScript = "<script language='javascript'>" +
"showSuccessToast();" +
"</script>";
Page.ClientScript.RegisterStartupScript(typeof(Page), "popupScript", popupScript);
}
/// <summary>
/// 根据模型删除数据
/// </summary>
/// <param name="model">模型</param>
/// <returns>是否成功</returns>
public bool DeleteModel(Sales_Return model)
{
return(Sales_ReturnOper.Instance.DeleteModel(model));
}
/// <summary>
/// 根据模型更新
/// </summary>
/// <param name="model">模型</param>
/// <returns>是否成功</returns>
public bool Update(Sales_Return model)
{
return(Sales_ReturnOper.Instance.Update(model));
}
/// <summary>
/// 根据分页筛选数据
/// </summary>
/// <param name="Key">主键</param>
/// <param name="start">开始数据</param>
/// <param name="PageSize">页面长度</param>
/// <param name="desc">排序</param>
/// <param name="model">对象</param>
/// <param name="connection">连接</param>
/// <param name="transaction">事务</param>
/// <returns>对象列表</returns>
public List <Sales_Return> SelectByPage(string Key, int start, int PageSize, bool desc = true, Sales_Return model = null, string SelectFiled = null, IDbConnection connection = null, IDbTransaction transaction = null)
{
var query = new LambdaQuery <Sales_Return>();
if (model != null)
{
if (!model.Id.IsNullOrEmpty())
{
query.Where(p => p.Id == model.Id);
}
if (!model.DetailId.IsNullOrEmpty())
{
query.Where(p => p.DetailId == model.DetailId);
}
if (!model.ReturnText.IsNullOrEmpty())
{
query.Where(p => p.ReturnText == model.ReturnText);
}
if (!model.ISRetuen.IsNullOrEmpty())
{
query.Where(p => p.ISRetuen == model.ISRetuen);
}
if (!model.ReturnReason.IsNullOrEmpty())
{
query.Where(p => p.ReturnReason == model.ReturnReason);
}
}
if (SelectFiled != null)
{
SelectFiled = SelectFiled.ToLowerInvariant();
if (SelectFiled.Contains("id,"))
{
query.Select(p => new { p.Id });
}
if (SelectFiled.Contains("detailid,"))
{
query.Select(p => new { p.DetailId });
}
if (SelectFiled.Contains("returntext,"))
{
query.Select(p => new { p.ReturnText });
}
if (SelectFiled.Contains("isretuen,"))
{
query.Select(p => new { p.ISRetuen });
}
if (SelectFiled.Contains("returnreason,"))
{
query.Select(p => new { p.ReturnReason });
}
}
if (Key != null)
{
query.OrderByKey(Key, desc);
}
return(query.GetQueryPageList(start, PageSize, connection, transaction));
}
/// <summary>
/// 根据模型插入
/// </summary>
/// <param name="model">模型</param>
/// <returns>是否成功</returns>
public bool Insert(Sales_Return model)
{
return(Sales_ReturnOper.Instance.Insert(model));
}
/// <summary>
/// 根据模型插入
/// </summary>
/// <param name="model">模型</param>
/// <returns>是否成功</returns>
public int InsertReturnKey(Sales_Return model)
{
return(Sales_ReturnOper.Instance.InsertReturnKey(model));
}
/// <summary>
/// 筛选全部数据
/// </summary>
/// <param name="model">模型</param>
/// <returns>对象列表</returns>
public List <Sales_Return> SelectByModel(Sales_Return model)
{
return(Sales_ReturnOper.Instance.SelectAll(model));
}
protected void Page_Load(object sender, EventArgs e)
{
string SLRNumber = "";
HttpRequest q = Request;
NameValueCollection n = q.QueryString;
if (n.HasKeys())
{
if (n.GetKey(0) != "")
{
SLRNumber = n.Get(0);
}
//string SLRNumber = Session["SLRNumber"].ToString();
if (SLRNumber != "")
{
var lData = Sales_Return.RetreiveDataForPrinting(oCon, SLRNumber);
string DocNumber = "";
string RefNum = "";
string isReplacement = "";
string Site = "";
string TransDate = "";
string Address1 = "";
string Address2 = "";
string Address3 = "";
string Address4 = "";
string SupplierName = "";
string Remarks = "";
var listData = Return_Header.RetrieveData(oCon, "", SLRNumber);
RefNum = listData[0].Document_Number;
isReplacement = listData[0].isReplacement;
DocNumber = listData[0].Auth_Number;
TransDate = listData[0].Date_Returned.ToShortDateString();
Remarks = listData[0].Remarks;
var listSite = Site_Loc.RetrieveData(oCon, listData[0].Site);
Site = listSite.Rows[0][2].ToString();
var reselleraddress = Customer_Details.RetrieveData(oCon, 0, listData[0].Customer_Code);
SupplierName = reselleraddress[0].Company_Name;
Address1 = reselleraddress[0].Address1;
Address2 = reselleraddress[0].Address2;
Address3 = reselleraddress[0].Address3;
Address4 = reselleraddress[0].Address4;
Microsoft.Reporting.WebForms.ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
viewer.LocalReport.ReportPath = Server.MapPath(@"~\Resources\SalesReturn.rdlc");
if (Address1 == "")
{
Address1 = "N/A";
}
if (Address2 == "")
{
Address2 = "N/A";
}
if (Address3 == "")
{
Address3 = "N/A";
}
if (Address4 == "")
{
Address4 = "N/A";
}
if (SupplierName == "")
{
SupplierName = "N/A";
}
if (Remarks == "")
{
Remarks = "N/A";
}
ReportParameter p1 = new ReportParameter("DocNumber", DocNumber);
ReportParameter p2 = new ReportParameter("RefNum", RefNum);
ReportParameter p3 = new ReportParameter("isReplacement", isReplacement);
ReportParameter p4 = new ReportParameter("Site", Site);
ReportParameter p5 = new ReportParameter("TransDate", TransDate);
ReportParameter p6 = new ReportParameter("Address1", Address1);
ReportParameter p7 = new ReportParameter("Address2", Address2);
ReportParameter p8 = new ReportParameter("Address3", Address3);
ReportParameter p9 = new ReportParameter("Address4", Address4);
ReportParameter p10 = new ReportParameter("SupplierName", SupplierName);
ReportParameter p11 = new ReportParameter("Remarks", Remarks);
ReportParameter p12 = new ReportParameter("SLRNumber", SLRNumber);
ReportDataSource repDataSource = new ReportDataSource("DataSet1", lData);
viewer.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12 });
viewer.LocalReport.DataSources.Clear();
viewer.LocalReport.DataSources.Add(repDataSource);
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = "pdf";
try
{
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename= " + SLRNumber + "." + extension);
Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file
Response.Flush(); // send it to the client to download
Response.End();
}
catch
{
HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Download not successful!" + ControlChars.Quote + ");</script>");
}
finally
{
}
//Microsoft.Reporting.WebForms.Warning[] warnings = null;
//string[] streamids = null;
//string mimeType = null;
//string encoding = null;
//string extension = null;
//string deviceInfo;
//byte[] bytes;
//Microsoft.Reporting.WebForms.LocalReport lr = new Microsoft.Reporting.WebForms.LocalReport();
//Warning[] warnings;
//string[] streamIds;
//string mimeType = string.Empty;
//string encoding = string.Empty;
//string extension = "pdf";
//// byte[] bytes = viewer.LocalReport.Render("Excel", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
//// Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
//// System.Web.HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
//Response.Buffer = true;
//Response.Clear();
//Response.ContentType = mimeType;
//Response.AddHeader("content-disposition", "attachment; filename= " + SLRNumber + "." + extension);
//Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file
//Response.Flush(); // send it to the client to download
//Response.End();
}
}
}
/// <summary>
/// 数据条数
/// </summary>
/// <param name="model">模型</param>
/// <returns>对象列表</returns>
public int SelectCount(Sales_Return model)
{
return(Sales_ReturnOper.Instance.SelectCount(model));
}
/// <summary>
/// 根据分页筛选数据
/// </summary>
/// <param name="Key">主键</param>
/// <param name="start">开始数据</param>
/// <param name="PageSize">页面长度</param>
/// <param name="desc">排序</param>
/// <param name="model">对象</param>
/// <returns>对象列表</returns>
public List <Sales_Return> SelectByPage(string Key, int start, int PageSize, bool desc, Sales_Return model, string SelectFiled)
{
return(Sales_ReturnOper.Instance.SelectByPage(Key, start, PageSize, desc, model));
}
