private void OpenFormSearchItem()
{
if (f_SearchItem != null)
{
if (!f_SearchItem.IsDisposed)
{
f_SearchItem.WindowState = FormWindowState.Normal;
f_SearchItem.BringToFront();
}
else
{
f_SearchItem = new FormSearchItem();
}
}
else
{
f_SearchItem = new FormSearchItem();
}
f_SearchItem.ItemHasSelected += new EventHandler(f_SearchItem_ItemHasSelected);
if (!trans.Equals(ListOfTransaction.Sales))
{
f_SearchItem.lbl_TempTransaction.Text = trans.ToString();
}
f_SearchItem.ShowInTaskbar = false;
f_SearchItem.ShowDialog();
}
private void SaveTransaction()
{
TTransaction t = new TTransaction();
t.TransactionId = transactionIdNumericUpDown.Value;
t.TransactionStatus = trans.ToString();
DataMaster.SavePersistence(t);
}
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 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 void BindData(object sender, EventArgs e)
{
string myKeyWord = "%" + txt_SearchById.Text.Trim() + "%";
if (txt_SearchById.Text.Equals("<Cari Berdasar No Faktur>"))
{
myKeyWord = "%%";
}
bindingSource_Search.Clear();
IList listSearch = null;
if (trans_Type == ListOfTransaction.Sales)
{
listSearch = new List <TTransaction>();
IList listTemp = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.Sales.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord);
TTransaction trans;
for (int i = 0; i < listTemp.Count; i++)
{
trans = (TTransaction)listTemp[i];
listSearch.Add(trans);
}
listTemp = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, ListOfTransaction.SalesVIP.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord);
for (int i = 0; i < listTemp.Count; i++)
{
trans = (TTransaction)listTemp[i];
listSearch.Add(trans);
}
}
else
{
listSearch = DataMaster.GetListBetweenEqLikeValue(typeof(TTransaction), TTransaction.ColumnNames.TransactionDate, dt_From.Value, dt_To.Value, TTransaction.ColumnNames.TransactionStatus, trans_Type.ToString(), TTransaction.ColumnNames.TransactionFactur, myKeyWord);
}
if (trans_Type == ListOfTransaction.SalesVIP || trans_Type == ListOfTransaction.Sales || trans_Type == ListOfTransaction.ReturSales || trans_Type == ListOfTransaction.ReturSalesVIP)
{
for (int i = 0; i < listSearch.Count; i++)
{
TTransaction t = listSearch[i] as TTransaction;
t.TransactionByName = AppCode.GetCustomerName(t.TransactionBy, true);
}
}
else
{
for (int i = 0; i < listSearch.Count; i++)
{
TTransaction t = listSearch[i] as TTransaction;
t.TransactionByName = AppCode.GetSupplierName(t.TransactionBy);
}
}
if (listSearch.Count > 0)
{
bindingSource_Search.DataSource = listSearch;
}
}
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 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 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("");
}
}
