/// <summary>
/// 取得一個新銷貨退回單編號
/// </summary>
/// <returns></returns>
public string GetNewReturnID(string Track)
{
string NewID;
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ReturnID from Sales_Return");
strSql.Append(" where ReturnID like @ReturnID ");
strSql.Append(" order by ReturnID Desc ");
SqlParameter[] parameters = {
new SqlParameter("@ReturnID", SqlDbType.Char,11)};
parameters[0].Value = Track+"%";
RedGlovePermission.Model.Sales_Return model = new RedGlovePermission.Model.Sales_Return();
DataSet ds=SqlServerHelper.Query(strSql.ToString(),parameters);
if (ds.Tables[0].Rows.Count > 0)
{
NewID = (int.Parse(ds.Tables[0].Rows[0]["ReturnID"].ToString().Substring(10, 3)) + 1001).ToString();
NewID = Track + NewID.Substring(NewID.Length - 3);
}
else
{
NewID = Track + "001";
}
return NewID;
}
/// <summary>
/// 取得銷貨退回單細項編號
/// </summary>
/// <param name="OID">銷貨退回單編號</param>
/// <returns></returns>
public string GetNewReturnSeq(string OID)
{
string NewSEQ;
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Seq from Sales_Return_DTL");
strSql.Append(" where ReturnID = @ReturnID ");
strSql.Append(" order by Seq Desc ");
SqlParameter[] parameters = {
new SqlParameter("@ReturnID", SqlDbType.Char,13)};
parameters[0].Value = OID;
RedGlovePermission.Model.Sales_Return model = new RedGlovePermission.Model.Sales_Return();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
NewSEQ = (int.Parse(ds.Tables[0].Rows[0]["SEQ"].ToString()) + 1).ToString();
}
else
{
NewSEQ = "1";
} return NewSEQ;
}
/// <summary>
/// 得到一筆銷貨退回單單資料
/// </summary>
/// <param name="ReturnID">銷貨退回單單編號</param>
/// <returns></returns>
public RedGlovePermission.Model.Sales_Return GetReturnModel(string ReturnID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Sales_Return ");
strSql.Append(" where ReturnID=@ReturnID ");
SqlParameter[] parameters = {
new SqlParameter("@ReturnID", SqlDbType.Char,13)};
parameters[0].Value = ReturnID;
RedGlovePermission.Model.Sales_Return model = new RedGlovePermission.Model.Sales_Return();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
//if (ds.Tables[0].Rows[0]["MA001"].ToString() != "")
//{
model.ReturnID = ds.Tables[0].Rows[0]["ReturnID"].ToString();
//}
model.Return_Date = ds.Tables[0].Rows[0]["Return_Date"].ToString();
model.Company = ds.Tables[0].Rows[0]["Company"].ToString();
model.MA001 = ds.Tables[0].Rows[0]["MA001"].ToString();
model.CaseNo = ds.Tables[0].Rows[0]["CaseNo"].ToString();
model.Department = ds.Tables[0].Rows[0]["Department"].ToString();
model.TaxRate = float.Parse(ds.Tables[0].Rows[0]["TaxRate"].ToString());
model.Amount = float.Parse(ds.Tables[0].Rows[0]["Total"].ToString());
model.Tax = float.Parse(ds.Tables[0].Rows[0]["Tax"].ToString());
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
return model;
}
else
{
return null;
}
}
protected void gvChild_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow gvr = (GridViewRow)((GridView)sender).NamingContainer;
HiddenField _hfChildSearch = (HiddenField)gvr.FindControl("_hfChildSearch");
SqlDataSource dsChild = (SqlDataSource)gvr.FindControl("dsChild");
if (e.CommandName == "InsertNew")
{
//TextBox tbSeq = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbSeq");
TextBox tbMB001 = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbMB001");
TextBox tbQty = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbQty");
TextBox tbUnitPrice = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbUnitPrice");
TextBox tbDiscount = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbDiscount");
//if (tbSeq != null)
// dsChild.InsertParameters["Seq"].DefaultValue = tbSeq.Text;
RedGlovePermission.Model.Basic_Companies model = new RedGlovePermission.Model.Basic_Companies();
model = bll.GetCCompanyModel(CompanyList.SelectedItem.ToString());
dsChild.InsertParameters["Seq"].DefaultValue = bllReturn.GetNewReturnSeq(gvr.Cells[5].Text);
if (tbMB001 != null)
dsChild.InsertParameters["MB001"].DefaultValue = tbMB001.Text;
if (tbQty != null)
dsChild.InsertParameters["Qty"].DefaultValue = tbQty.Text;
if (tbUnitPrice != null)
dsChild.InsertParameters["unitPrice"].DefaultValue = tbUnitPrice.Text;
if (tbDiscount != null)
dsChild.InsertParameters["Discount"].DefaultValue = tbDiscount.Text;
else
dsChild.InsertParameters["Discount"].DefaultValue = "1";
dsChild.InsertParameters["ReturnId"].DefaultValue = gvr.Cells[5].Text;
UserSession user = SessionBox.GetUserSession();
dsChild.InsertParameters["CREATOR"].DefaultValue = user.LoginName.ToString();
dsChild.InsertParameters["CREATE_DATE"].DefaultValue = DateTime.Now.ToString("yyyyMMdd");
dsChild.Insert();
//處理單頭合計及稅額
if (bllReturn.ReturnTotal(gvr.Cells[5].Text) == 0)
ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_total_false") + "');", true);
else
{
RedGlovePermission.Model.Sales_Return Returnmodel = new RedGlovePermission.Model.Sales_Return();
Returnmodel = bllReturn.GetReturnModel(gvr.Cells[5].Text);
gvr.Cells[13].Text = Returnmodel.Amount.ToString();
gvr.Cells[14].Text = Returnmodel.Tax.ToString();
}
ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_update_true") + "');", true);
_hfChildSearch.Value = "";
BindChildData((GridView)sender);
}
if (e.CommandName == "InsertCancel")
{
_hfChildSearch.Value = "";
BindChildData((GridView)sender);
}
}
protected void gvChild_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
GridViewRow gvr = (GridViewRow)((GridView)sender).NamingContainer;
//處理單頭合計及稅額
if (bllReturn.ReturnTotal(gvr.Cells[5].Text) == 0)
ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_total_false") + "');", true);
else
{
RedGlovePermission.Model.Sales_Return Returnmodel = new RedGlovePermission.Model.Sales_Return();
Returnmodel = bllReturn.GetReturnModel(gvr.Cells[5].Text);
gvr.Cells[13].Text = Returnmodel.Amount.ToString();
gvr.Cells[14].Text = Returnmodel.Tax.ToString();
}
ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_update_true") + "');", true);
}
protected void gvChild_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow gvr = (GridViewRow)((GridView)sender).NamingContainer;
SqlDataSource dsChild = (SqlDataSource)gvr.FindControl("dsChild");
dsChild.DeleteParameters["ReturnID"].DefaultValue = gvr.Cells[5].Text;
dsChild.DeleteParameters["SEQM"].DefaultValue = ((GridView)sender).Rows[e.RowIndex].Cells[1].Text;
dsChild.Delete();
//處理單頭合計及稅額
if (bllReturn.ReturnTotal(gvr.Cells[5].Text) == 0)
ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_total_false") + "');", true);
else
{
RedGlovePermission.Model.Sales_Return Returnmodel = new RedGlovePermission.Model.Sales_Return();
Returnmodel = bllReturn.GetReturnModel(gvr.Cells[5].Text);
gvr.Cells[13].Text = Returnmodel.Amount.ToString();
gvr.Cells[14].Text = Returnmodel.Tax.ToString();
}
ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_delete_true") + "');", true);
}