public FormTransaction(ListOfTransaction tr)
{
InitializeComponent();
trans = tr;
this.Icon = Properties.Resources.sales_ico;
this.MinimumSize = new Size(this.Size.Width, this.Size.Height);
}
public FormTransaction(ListOfTransaction tr)
{
InitializeComponent();
trans = tr;
SetInitialSettings();
//set event
SetEvent();
}
private void OpenFormTransaction(ListOfTransaction trans)
{
if (f_Transaction != null)
{
if (!f_Transaction.IsDisposed)
{
f_Transaction.Close();
}
}
f_Transaction = new FormTransaction(trans);
f_Transaction.lbl_UserName.Text = toolStripStatusLabelLoginName.Text;
}
private void OpenFormTransaction(ListOfTransaction trans)
{
if (f_Transaction != null)
{
if (!f_Transaction.IsDisposed)
{
f_Transaction.Close();
}
}
f_Transaction = new FormTransaction(trans);
//if (set != null)
// f_Transaction.companyNameLabel.Text = set.CompanyName;
//f_Transaction.trans = trans;
f_Transaction.lbl_UserName.Text = toolStripStatusLabelLoginName.Text;
}
public static void SetTransactionTextBoxSuggest(TextBox txt, ListOfTransaction tr, string SupplierId)
{
txt.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt.AutoCompleteCustomSource.Clear();
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
IList listTrans = DataMaster.GetListEq(typeof(TTransaction), TTransaction.ColumnNames.TransactionStatus, tr.ToString(), TTransaction.ColumnNames.TransactionBy, SupplierId);
TTransaction trans;
for (int i = 0; i < listTrans.Count; i++)
{
trans = (TTransaction)listTrans[i];
txt.AutoCompleteCustomSource.Add(trans.TransactionFactur);
}
}
public static DataTable GetTransactionAveragePrice(ListOfTransaction trans, DateTime dateFrom, DateTime dateTo)
{
//ISession m_session = NHibernateHttpModule.CurrentSession;
////string queryStr = "SELECT AVG(DET.Price) ,DET.ItemId " +
//string queryStr = "FROM TTransactionDetail DET, TTransaction TRANS " +
// "WHERE DET.TransactionId = TRANS.TransactionId " +
// "AND TRANS.TransactionStatus = :trans " +
// "AND TRANS.TransactionDate BETWEEN :dateFrom AND :dateTo " +
// "GROUP BY DET.ItemId";
////string queryStr = "SELECT DET.ItemId FROM TTransactionDetail DET";
//IQuery query = m_session.CreateQuery(queryStr);
//query.SetString("trans", trans.ToString());
//query.SetDateTime("dateFrom", dateFrom);
//query.SetDateTime("dateTo", dateTo);
ISession m_session = NHibernateHttpModule.CurrentSession;
SqlConnection cn = (SqlConnection)m_session.Connection;
string q = @"SELECT DET.ITEM_ID as ItemId, AVG(DET.PRICE) as AvgPrice
FROM T_TRANSACTION_DETAIL DET, T_TRANSACTION TRANS
WHERE DET.TRANSACTION_ID = TRANS.TRANSACTION_ID
AND TRANS.TRANSACTION_STATUS = @trans
AND TRANS.TRANSACTION_DATE BETWEEN @dateFrom AND @dateTo
GROUP BY DET.ITEM_ID";
SqlCommand cmd = new SqlCommand(q, cn);
cmd.Parameters.Add(new SqlParameter("@trans", SqlDbType.VarChar));
cmd.Parameters.Add(new SqlParameter("@dateFrom", SqlDbType.DateTime));
cmd.Parameters.Add(new SqlParameter("@dateTo", SqlDbType.DateTime));
cmd.Parameters["@trans"].Value = trans.ToString();
cmd.Parameters["@dateFrom"].Value = dateFrom;
cmd.Parameters["@dateTo"].Value = dateTo;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public static string GenerateFacturNo(ListOfTransaction tr, string DeskNo)
{
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSetting set = (MSetting)DataMaster.GetObjectById(typeof(MSetting), AssemblyProduct);
TReference refer = (TReference)DataMaster.GetObjectByProperty(typeof(TReference), TReference.ColumnNames.ReferenceType, tr.ToString());
if (refer == null)
{
refer = new TReference();
refer.NextId = decimal.Zero.ToString();
}
string facturNoTemplate = set.FacturNoFormat;
decimal no = Convert.ToDecimal(refer.NextId) + 1;
int len = set.FacturNoLength - no.ToString().Length;
string factur = no.ToString();
for (int i = 0; i < len; i++)
{
factur = "0" + factur;
}
refer.NextId = no.ToString();
refer.ReferenceType = tr.ToString();
DataMaster.SaveOrUpdate(refer);
string tipeTrans = string.Empty;
char[] charTransArray = tr.ToString().ToCharArray();
char charTrans;
for (int i = 0; i < tr.ToString().Length; i++)
{
charTrans = charTransArray[i];
if (char.IsUpper(tr.ToString(), i))
{
tipeTrans += tr.ToString().Substring(i, 1);
}
}
return(facturNoTemplate.Replace("[xxx]", factur).Replace("[meja]", DeskNo).Replace("[tanggal]", DateTime.Now.Day.ToString()).Replace("[bulan]", DateTime.Now.Month.ToString()).Replace("[tahun]", DateTime.Now.Year.ToString()).Replace("[Tipe]", tipeTrans));
}
public FormSearchTransaction(ListOfTransaction TransactionType)
{
InitializeComponent();
trans_Type = TransactionType;
DataGridViewColumn grid_Col;
//add kolom kode
grid_Col = new DataGridViewColumn();
grid_Col.CellTemplate = new DataGridViewTextBoxCell();
grid_Col.DataPropertyName = TTransaction.ColumnNames.TransactionId;
grid_Col.HeaderText = "Kode Transaksi";
grid_Search.Columns.Add(grid_Col);
//add kolom no faktur
grid_Col = new DataGridViewColumn();
grid_Col.CellTemplate = new DataGridViewTextBoxCell();
grid_Col.DataPropertyName = TTransaction.ColumnNames.TransactionFactur;
grid_Col.HeaderText = "No Faktur";
grid_Search.Columns.Add(grid_Col);
//add kolom supplier
grid_Col = new DataGridViewColumn();
grid_Col.CellTemplate = new DataGridViewTextBoxCell();
grid_Col.DataPropertyName = TTransaction.ColumnNames.TransactionByName;
if (trans_Type == ListOfTransaction.SalesVIP || trans_Type == ListOfTransaction.Sales || trans_Type == ListOfTransaction.ReturSales || trans_Type == ListOfTransaction.ReturSalesVIP)
{
grid_Col.HeaderText = "Pelanggan";
}
else
{
grid_Col.HeaderText = "Supplier";
}
grid_Search.Columns.Add(grid_Col);
}
private void FillTTransactionDataSource(ListOfTransaction trans)
{
bs = new BindingSource();
bs.DataSource = DataMaster.GetListEq(typeof(TTransaction), TTransaction.ColumnNames.TransactionStatus, trans.ToString());
reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("Inventori_Data_TTransaction", bs));
}
public static string GenerateFacturNo(ListOfTransaction tr, string DeskNo)
{
//return "";
DataMasterMgtServices DataMaster = new DataMasterMgtServices();
MSetting set = (MSetting)DataMaster.GetObjectByProperty(typeof(MSetting), MSetting.ColumnNames.SettingId, AssemblyProduct);
if (set != null)
{
IList listTrans = DataMaster.GetListEq(typeof(TTransaction), TTransaction.ColumnNames.TransactionStatus, tr.ToString());
string facturNoTemplate = set.FacturNoFormat;
int no = listTrans.Count + 1;
int len = set.FacturNoLength - no.ToString().Length;
string factur = no.ToString();
for (int i = 0; i < len; i++)
{
factur = "0" + factur;
}
string typeTrans = "";
switch (tr)
{
case ListOfTransaction.Correction:
typeTrans = "Kor";
break;
case ListOfTransaction.Purchase:
typeTrans = "P";
break;
case ListOfTransaction.PurchaseOrder:
typeTrans = "PO";
break;
case ListOfTransaction.ReturPurchase:
typeTrans = "RP";
break;
case ListOfTransaction.ReturSales:
typeTrans = "RS";
break;
case ListOfTransaction.ReturSalesVIP:
typeTrans = "RSVIP";
break;
case ListOfTransaction.Sales:
typeTrans = "S";
break;
case ListOfTransaction.SalesVIP:
typeTrans = "SVIP";
break;
case ListOfTransaction.Usage:
typeTrans = "U";
break;
default:
break;
}
return(facturNoTemplate.Replace("[xxx]", factur).Replace("[meja]", DeskNo).Replace("[tanggal]", DateTime.Now.Day.ToString()).Replace("[bulan]", DateTime.Now.Month.ToString()).Replace("[tahun]", DateTime.Now.Year.ToString()).Replace("[TipeTransaksi]", typeTrans));
}
else
{
return("");
}
}
