protected void btnSaveCharge_Click(object sender, EventArgs e)
{
ChargeEntity Result = GetChargeUI();
m_Charge.SaveCharge(Result);
ShowMessage("缴费信息数据保存成功!");
//int Succeed = m_Charge.SaveCharge(Result);
//if (Succeed > 0) ShowMessage("缴费信息数据保存成功!");
//if (Succeed < 0) ShowMessage("缴费信息数据保存失败!");
DataBind();
SetUIState("Default");
}
/// <summary>
/// 从界面获取缴费信息对象
/// </summary>
/// <returns></returns>
private ChargeEntity GetChargeUI()
{
ChargeEntity Result = new ChargeEntity();
Result.BillNo = BillNo;
Result.ChargeDeptID = EnvConverter.ToInt32(hDeptID.Value);
Result.Payer = txtPayer.Text;
Result.PackageID = EnvConverter.ToInt32(hPackageID.Value);
Result.CheckNum = EnvConverter.ToInt32(txtCheckNum.Text);
Result.Charge = EnvConverter.ToDecimal(txtCharge.Text);
Result.ActualCharge = EnvConverter.ToDecimal(txtActualCharge.Text);
Result.PaymentMethod = drpPaymentMethod.SelectedValue;
Result.PaymentDate = EnvConverter.ToDateTime(txtPaymentDate.Text);
Result.ChargePerson = txtChargePerson.Text;
return(Result);
}
public static ICharge GetChargeDetails(int ChargesID)
{
string strExecution = "[mst].[spGetChargeDetailsAndRate]";
ICharge Chrg = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@ChargeId", ChargesID);
oDq.AddIntegerParam("@Mode", 1); // @Mode = 1 to fetch ChargeDetails
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
Chrg = new ChargeEntity(reader);
}
reader.Close();
}
return(Chrg);
}
public static List <ICharge> GetAllCharges(int docTypeId)
{
string strExecution = "usp_Invoice_GetAllCharges";
List <ICharge> lstCharges = new List <ICharge>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddBigIntegerParam("@DocTypeId", docTypeId);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
ICharge charge = new ChargeEntity(reader);
lstCharges.Add(charge);
}
reader.Close();
}
return(lstCharges);
}
void FillChargeDetails(int ChargesID)
{
oChargeEntity = new ChargeEntity();
oChargeBLL = new ChargeBLL();
oChargeEntity = (ChargeEntity)oChargeBLL.GetChargeDetails(ChargesID);
//oChargeEntity.ChargeActive = true;
txtChargeName.Text = oChargeEntity.ChargeDescr;
//ddlChargeType.SelectedIndex = ddlChargeType.Items.IndexOf(ddlChargeType.Items.FindByValue(oChargeEntity.ChargeType.ToString()));
txtChgAbbr.Text = oChargeEntity.ChgAbbr;
ddlCurrency.SelectedIndex = ddlCurrency.Items.IndexOf(ddlCurrency.Items.FindByValue(oChargeEntity.Currency.ToString()));
txtEffectDate.Text = oChargeEntity.EffectDt.ToShortDateString();
//ddlInvLink.SelectedIndex = ddlInvLink.Items.IndexOf(ddlInvLink.Items.FindByValue(oChargeEntity.DocumentType.ToString()));
//ddlLine.SelectedIndex = ddlLine.Items.IndexOf(ddlLine.Items.FindByValue(oChargeEntity.NVOCCID.ToString()));
//ddlHeaderLocation.SelectedIndex = ddlHeaderLocation.Items.IndexOf(ddlHeaderLocation.Items.FindByValue(oChargeEntity.Location.ToString()));
rdbServiceTaxApplicable.Items.FindByValue(oChargeEntity.ServiceTax.ToString().ToLower() == "true" ? "1" : "0").Selected = true;
//rdbTerminalRequired.Items.FindByValue(oChargeEntity.IsTerminal.ToString().ToLower() == "true" ? "1" : "0").Selected = true;
rdbRateChange.Items.FindByValue(oChargeEntity.RateChangeable.ToString().ToLower() == "true" ? "1" : "0").Selected = true;
//rdbDestinationCharge.Items.FindByValue(oChargeEntity.DestinationCharge.ToString().ToLower() == "true" ? "1" : "0").Selected = true;
//hdnFPOD.Value = oChargeEntity.FPOD;
//if (oChargeEntity.FPOD != string.Empty)
//{
// hdnFPOD.Value = oChargeEntity.FPOD.Substring(oChargeEntity.FPOD.IndexOf('|') + 1);
// txtFPOD.Text = oChargeEntity.FPOD.Substring(0, oChargeEntity.FPOD.IndexOf('|'));
//}
//FillServices();
//if (ddlService.Items.Count > 0)
//{
// ddlService.SelectedIndex = ddlService.Items.IndexOf(ddlService.Items.FindByValue(oChargeEntity.Service.ToString()));
//}
hdnChargeID.Value = oChargeEntity.ChargesID.ToString();
}
public static List <ICharge> GetAllFwdCharges(int Currency)
{
string strExecution = "[fwd].[uspFwd_Invoice_GetAllCharges]";
List <ICharge> lstCharges = new List <ICharge>();
using (DbQuery oDq = new DbQuery(strExecution))
{
//oDq.AddBigIntegerParam("@DocTypeId", docTypeId);
//oDq.AddBigIntegerParam("@LineId", LineID);
oDq.AddBigIntegerParam("@CurrencyId", Currency);
//oDq.AddVarcharParam("@JobNo", 40, JobNo);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
ICharge charge = new ChargeEntity(reader);
lstCharges.Add(charge);
}
reader.Close();
}
return(lstCharges);
}
public static List <ICharge> GetAllExpCharges(int docTypeId, int LocationID, int LineID, string BookingNo)
{
string strExecution = "[exp].[uspExp_Invoice_GetAllCharges]";
List <ICharge> lstCharges = new List <ICharge>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddBigIntegerParam("@DocTypeId", docTypeId);
oDq.AddBigIntegerParam("@LineId", LineID);
oDq.AddBigIntegerParam("@LocationId", LocationID);
oDq.AddVarcharParam("@BookingNo", 40, BookingNo);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
ICharge charge = new ChargeEntity(reader);
lstCharges.Add(charge);
}
reader.Close();
}
return(lstCharges);
}
public void DeleteCharge(ChargeEntity Charge)
{
DataAccess.DeleteCharge(Charge);
}
public void SaveCharge(ChargeEntity Charge)
{
DataAccess.SaveCharge(Charge);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
oChargeEntity = new ChargeEntity();
oChargeBLL = new ChargeBLL();
//if (rdbRateChange.SelectedItem.Value == "0")
//{
// if (ViewState["ChargeRates"] == null)
// {
// lblMessage.Text = "Please enter rates!";
// return;
// }
// else
// {
// Rates = (List<IChargeRate>)ViewState["ChargeRates"];
// if (Rates.Count() <= 0)
// {
// lblMessage.Text = "Please enter rates!";
// return;
// }
// }
//}
oChargeEntity.ChargeActive = true;
oChargeEntity.ChargeDescr = txtChargeName.Text.Trim();
//oChargeEntity.ChargeType = Convert.ToInt32(ddlChargeType.SelectedValue);
//This ID will be the companyid of the currently loggedin user
//IUser user = (IUser)Session[Constants.SESSION_USER_INFO];
oChargeEntity.CompanyID = 1;
oChargeEntity.Currency = Convert.ToInt32(ddlCurrency.SelectedValue);
oChargeEntity.EffectDt = Convert.ToDateTime(txtEffectDate.Text.Trim());
oChargeEntity.IEC = 'F';
//oChargeEntity.IsTerminal = Convert.ToBoolean(Convert.ToInt32(rdbTerminalRequired.SelectedItem.Value));
//oChargeEntity.IsWashing = Convert.ToBoolean(Convert.ToInt32(rdbWashing.SelectedItem.Value));
//oChargeEntity.NVOCCID = Convert.ToInt32(ddlLine.SelectedValue);
oChargeEntity.RateChangeable = Convert.ToBoolean(Convert.ToInt32(rdbRateChange.SelectedItem.Value));
oChargeEntity.ServiceTax = Convert.ToBoolean(Convert.ToInt32(rdbServiceTaxApplicable.SelectedItem.Value));
//oChargeEntity.Location = Convert.ToInt32(ddlHeaderLocation.SelectedValue);
oChargeEntity.ChgAbbr = txtChgAbbr.Text;
//if (ddlService.SelectedIndex > 0)
// oChargeEntity.Service = Convert.ToInt32(ddlService.SelectedValue);
//oChargeEntity.DestinationCharge = Convert.ToBoolean(rdbDestinationCharge.SelectedValue == "1" ? true : false);
//oChargeEntity.FPOD = hdnFPOD.Value;
//if (ddlInvLink.Items != null)
// oChargeEntity.DocumentType = Convert.ToInt32(ddlInvLink.SelectedValue);
oChargeEntity.DeliveryMode = '0';
if (Convert.ToInt32(hdnChargeID.Value) <= 0) //insert
{
oChargeEntity.CreatedBy = _userId; // oUserEntity.Id;
oChargeEntity.CreatedOn = DateTime.Today.Date;
oChargeEntity.ModifiedBy = _userId; // oUserEntity.Id;
oChargeEntity.ModifiedOn = DateTime.Today.Date;
hdnChargeID.Value = oChargeBLL.AddEditCharge(oChargeEntity).ToString();
if (Convert.ToInt32(hdnChargeID.Value) > 0)
{
//AddRates();
lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00009");
ClearAll();
EnableAllField();
ViewState["ChargeRates"] = null;
//WashingSelection(rdbWashing);
}
else if (hdnChargeID.Value == "-1")
{
lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00076");
}
else
{
lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011");
}
}
else //update
{
oChargeEntity.ChargesID = Convert.ToInt32(hdnChargeID.Value);
oChargeEntity.ModifiedBy = _userId;// oUserEntity.Id;
oChargeEntity.ModifiedOn = DateTime.Today.Date;
switch (oChargeBLL.AddEditCharge(oChargeEntity))
{
case 0: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00011");
break;
case 1:
AddRates();
Response.Redirect("~/Forwarding/Master/FwdChargeList.aspx");
break;
case -1: lblMessage.Text = ResourceManager.GetStringWithoutName("ERR00076");
break;
}
}
}
}
