private void Fill_Combo()
{
database1 clsdatabase1 = new database1();
INPR clsINPR = new INPR();
DataSet ds = clsINPR.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINPR.sErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
Set_Combo(lookBranch_ID, ds.Tables[0], "Branch_SName", "Branch_ID", true);
Set_Combo(lookCredit_ID, ds.Tables[1], "CreditD", "CReditID", true);
Set_Combo(lookDType, ds.Tables[2], "DType_DD", "DType_ID", true);
}
private void Fill_Combo()
{
database1 clsdatabase1 = new database1();
INItem_OB clsINItem_OB = new INItem_OB();
DataSet ds = new DataSet();
ds = clsINItem_OB.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINItem_OB.sErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
Set_Combo(lookBranch_ID, ds.Tables[0], "Branch_SName", "Branch_ID", true);
Set_Combo(lookDept_ID_Store, ds.Tables[1], "Dept_DD", "Dept_ID", true);
Set_Combo(lookGrade_ID, ds.Tables[2], "Grade_ID", "Grade_ID", false);
}
private void Fill_Combo()
{
AC_OB clsAC_OB = new AC_OB();
DataSet ds = clsAC_OB.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsAC_OB.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsAC_OB.sErrorCode, false);
return;
}
Set_Combo(lookBranch_ID, ds.Tables[0], "Branch_FName", "Branch_ID", true);
}
private void Fill_Combo()
{
database1 clsdatabase1 = new database1();
ACVoucher clsACVoucher = new ACVoucher();
DataSet ds = new DataSet();
ds = clsACVoucher.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsACVoucher.strErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
if (ds.Tables.Count > 0)
{
lookVrType.Properties.DataSource = ds.Tables[0];
lookVrType.Properties.DisplayMember = "VrTypeDD";
lookVrType.Properties.ValueMember = "VrType";
lookVrType_Serch.Properties.DataSource = ds.Tables[0];
lookVrType_Serch.Properties.DisplayMember = "VrTypeDD";
lookVrType_Serch.Properties.ValueMember = "VrType";
lookBranch_ID.Properties.DataSource = ds.Tables[1];
lookBranch_ID.Properties.DisplayMember = "Branch_FName";
lookBranch_ID.Properties.ValueMember = "Branch_ID";
lookBranch_Search.Properties.DataSource = ds.Tables[1];
lookBranch_Search.Properties.DisplayMember = "Branch_FName";
lookBranch_Search.Properties.ValueMember = "Branch_ID";
lookTrLevel.Properties.DataSource = ds.Tables[2];
lookTrLevel.Properties.DisplayMember = "TrLevelD";
lookTrLevel.Properties.ValueMember = "TrLevel";
//Set_Combo(lookVrType, ds.Tables[0], "VrTypeDD,", "VrType", true);
//Set_Combo(lookVrType_Serch, ds.Tables[0], "VrTypeDD,", "VrType", true);
//Set_Combo(lookBranch_ID, ds.Tables[1], "Branch_FName,", "Branch_ID", true);
//Set_Combo(lookBranch_Search, ds.Tables[1], "Branch_FName,", "Branch_ID", true);
//Set_Combo(lookTrLevel, ds.Tables[1], "TrLevelD,", "TrLevel", true);
}
}
private void Fill_Combo()
{
database1 clsdatabase1 = new database1();
INItem clsINItem = new INItem();
DataSet ds = new DataSet();
ds = clsINItem.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINItem.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsdatabase1.sErrorCode, false);
return;
}
Fill_Cat();
Fill_SCat();
Set_Combo(lookIType_ID, ds.Tables[0], "IType_DD", "IType_ID", true);
Set_Combo(lookSize_ID, ds.Tables[1], "Size_DD", "Size_ID", true);
Set_Combo(lookUnit_ID, ds.Tables[2], "Unit_DD", "Unit_ID", true);
Set_Combo(lookA_Unit_ID, ds.Tables[2], "Unit_DD", "Unit_ID", true);
}
private void get_Sale()
{
database1 clsdatabase1 = new database1();
INCSR clsINCSR = new INCSR();
DataSet ds = new DataSet();
ds = clsINCSR.Find_Sale(mSys_System.pComp_ID, txtDoc_Tr_No.Text.Trim());
if (clsINCSR.strErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
lblDoc_Inv_SqNo.Text = dt.Rows[i]["Inv_SqNo"].ToString();
txtDoc_Tr_No.Text = dt.Rows[i]["Tr_No"].ToString();
dtpDoc_Tr_Date.Text = dt.Rows[i]["Tr_Date"].ToString();
lookSub_ID.EditValue = dt.Rows[i]["Sub_ID"].ToString();
txtRef1.Text = dt.Rows[i]["Ref1"].ToString();
txtContact_Person.Text = dt.Rows[i]["Person"].ToString();
txtAddress1.Text = dt.Rows[i]["Address1"].ToString();
txtAddress2.Text = dt.Rows[i]["Address2"].ToString();
txtCell.Text = dt.Rows[i]["Cell"].ToString();
}
DataTable dt1 = ds.Tables[1];
gridControl1.DataSource = dt1;
}