/// <summary>
/// Saves a record to the T_CusSettle table.
/// </summary>
public Boolean Savet_CusSettleSP(T_CusSettle t_CusSettle, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_CusSettleSave";
scom.Parameters.Add("@DocNo", SqlDbType.VarChar, 20).Value = t_CusSettle.DocNo;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_CusSettle.Customer;
scom.Parameters.Add("@Type", SqlDbType.VarChar, 20).Value = t_CusSettle.Type;
scom.Parameters.Add("@RefNo", SqlDbType.VarChar, 20).Value = t_CusSettle.RefNo;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_CusSettle.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_CusSettle.LocaCode;
scom.Parameters.Add("@NetAmt", SqlDbType.Decimal, 9).Value = t_CusSettle.NetAmt;
scom.Parameters.Add("@PaidAmt", SqlDbType.Decimal, 9).Value = t_CusSettle.PaidAmt;
scom.Parameters.Add("@DueAmt", SqlDbType.Decimal, 9).Value = t_CusSettle.DueAmt;
scom.Parameters.Add("@Settlement", SqlDbType.Decimal, 9).Value = t_CusSettle.Settlement;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_CusSettle.Datex;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public T_CusSettle Selectt_CusSettle(T_CusSettle objt_CusSettle)
{
try
{
strquery = @"select * from t_CusSettle where Customer = '" + objt_CusSettle.Customer + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objt_CusSettle.DocNo = drType["DocNo"].ToString();
objt_CusSettle.Customer = drType["Customer"].ToString();
objt_CusSettle.Type = drType["Type"].ToString();
objt_CusSettle.RefNo = drType["RefNo"].ToString();
objt_CusSettle.CompCode = drType["CompCode"].ToString();
objt_CusSettle.LocaCode = drType["LocaCode"].ToString();
objt_CusSettle.NetAmt = decimal.Parse(drType["NetAmt"].ToString());
objt_CusSettle.PaidAmt = decimal.Parse(drType["PaidAmt"].ToString());
objt_CusSettle.DueAmt = decimal.Parse(drType["DueAmt"].ToString());
objt_CusSettle.Settlement = decimal.Parse(drType["Settlement"].ToString());
objt_CusSettle.Datex = DateTime.Parse(drType["Datex"].ToString());
return(objt_CusSettle);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public List <T_CusSettle> SelectT_CusSettleMulti(T_CusSettle objt_CusSettle2)
{
List <T_CusSettle> retval = new List <T_CusSettle>();
try
{
strquery = @"select * from t_CusSettle where Customer = '" + objt_CusSettle2.Customer + "'";
DataTable dtt_CusSettle = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtt_CusSettle.Rows)
{
if (drType != null)
{
T_CusSettle objt_CusSettle = new T_CusSettle();
objt_CusSettle.DocNo = drType["DocNo"].ToString();
objt_CusSettle.Customer = drType["Customer"].ToString();
objt_CusSettle.Type = drType["Type"].ToString();
objt_CusSettle.RefNo = drType["RefNo"].ToString();
objt_CusSettle.CompCode = drType["CompCode"].ToString();
objt_CusSettle.LocaCode = drType["LocaCode"].ToString();
objt_CusSettle.NetAmt = decimal.Parse(drType["NetAmt"].ToString());
objt_CusSettle.PaidAmt = decimal.Parse(drType["PaidAmt"].ToString());
objt_CusSettle.DueAmt = decimal.Parse(drType["DueAmt"].ToString());
objt_CusSettle.Settlement = decimal.Parse(drType["Settlement"].ToString());
objt_CusSettle.Datex = DateTime.Parse(drType["Datex"].ToString());
retval.Add(objt_CusSettle);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
