public frmShow_Out(BL_BASEFIELD objBL)
{
InitializeComponent(); this.Tran_cd = objBL.Code;
objBASEFILEDS.HTMAIN["TRAN_CD"] = this.tran_cd;
//if (objBASEFILEDS.HTMAIN.Contains(objBL.Primary_id.ToString()))
//{
// objBASEFILEDS.HTMAIN[objBL.Primary_id.ToString()] = this.tran_id.ToString();
//}
this.objBASEFILEDS = objBL;
}
public frmProjectMast(BL_BASEFIELD objBL)
{
InitializeComponent(); this.Tran_cd = objBL.Code;
objBASEFILEDS.HTMAIN["TRAN_CD"] = this.tran_cd;
if (objBASEFILEDS.HTMAIN.Contains(objBL.Primary_id.ToString()))
{
objBASEFILEDS.HTMAIN[objBL.Primary_id.ToString()] = this.tran_id.ToString();
}
this.objBASEFILEDS = objBL;
}
public frmGeneralLedger(BL_BASEFIELD objBF)
{
InitializeComponent();
this.Tran_cd = objBF.TRAN_CD;
objBASEFILEDS = objBF;
objBASEFILEDS.HTMAIN["tran_cd"] = this.Tran_cd;
if (objBASEFILEDS.HTMAIN.Contains(objBF.Primary_id.ToString()))
{
objBASEFILEDS.HTMAIN[objBF.Primary_id.ToString()] = this.tran_id.ToString();
}
}
public frmPrintPreview(BL_BASEFIELD objbl, bool flgDocorRep, bool PreviewOrSendMail)
{
InitializeComponent();
objBLFD = objbl;
flgDocorReport = flgDocorRep;
flgPreviewOrSendMail = PreviewOrSendMail;
ctrlhgt = this.ClientSize.Height;
hgt = 0;
ctrlwid = this.ClientSize.Width;
wid = this.ClientSize.Width / 2;
}
public DataSet Get_Rep_Documents(BL_BASEFIELD objBLFD)
{
DataSet dsSet = new DataSet();
htFieldscond.Clear();
htFieldscond.Add("@atran_id", objBLFD.HTMAIN[objBLFD.Primary_id.ToString()].ToString());
htFieldscond.Add("@atran_cd", objBLFD.Code);
htFieldscond.Add("@adef_rep_nm", objBLFD.Defrep_nm);
htFieldscond.Add("@acompid", objBLFD.ObjCompany.Compid);
dsSet = objDLAdapter.dsprocedure("ISP_Get_Rep_Documents", htFieldscond);
return(dsSet);
}
public override bool SendMessageToClient(BL_BASEFIELD objBLFD, string msg)
{
objBASEFILEDS = objBLFD;
if (msg != "SAVE")
{
DisplayControlsonMode(objBLFD.Tran_mode);
}
else
{
return(Click_Save());
}
return(true);
}
public DataSet Get_Ref_main_Details(BL_BASEFIELD objBLFD, string ac_nm, string _rule, string ref_type)
{
htFieldscond.Clear();
htFieldscond.Add("@atran_id", objBLFD.HTMAIN[objBLFD.Primary_id.ToString()].ToString());
htFieldscond.Add("@atran_cd", objBLFD.Code);
htFieldscond.Add("@abehaiver_cd", objBLFD.Behavier_cd);
htFieldscond.Add("@areftran_cd", ref_type);
htFieldscond.Add("@arefbehaiver_cd", objBLFD.Ref_behaiver_cd);
htFieldscond.Add("@atran_mode", objBLFD.Tran_mode);
htFieldscond.Add("@aac_nm", ac_nm);
htFieldscond.Add("@arule", _rule);
htFieldscond.Add("@acompid", objBLFD.ObjCompany.Compid);
htFieldscond.Add("@atran_dt", objBLFD.HTMAIN["tran_dt"].ToString());
return(objdlAdapter.dsprocedure("ISP_GET_Ref_Header_Details", htFieldscond));
}
public string Validate_Fields(BL_BASEFIELD objBF)
{
foreach (DataRow row in objBF.dsBASEFIELDMAIN.Tables[0].Rows)
{
if (row["data_ty"].ToString().ToLower() == "decimal")
{
Regex rgx = new Regex(@"[0-9]+[\.]?[0-9]*");
if (!rgx.IsMatch(objBF.HTMAIN[row["fld_nm"].ToString().ToUpper()].ToString()))
{
return(row["head_nm"].ToString());
}
}
}
return("");
}
public int Get_Company_Name(BL_BASEFIELD objBLFD)
{
try
{
GetCorrectCon();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select count(*)+1 cnt from ORG_MAST where comp_nm like left('" + objBLFD.HTMAIN["COMP_NM"].ToString() + "',1)+'%' and year('" + DateTime.Parse(objBLFD.HTMAIN["FIN_YR_STA"].ToString()).ToString("yyyy/MM/dd") + "')=year(fin_yr_sta) and year('" + DateTime.Parse(objBLFD.HTMAIN["FIN_YR_END"].ToString()).ToString("yyyy/MM/dd") + "')=year(fin_yr_end)", con);
da.Fill(ds);
return(int.Parse(ds.Tables[0].Rows[0]["cnt"].ToString()));
}
catch (Exception ex)
{
AutoClosingMessageBox.Show("Connection Error : " + ex.Message, "Error", 5000);
return(0);
}
}
//public void SaveGenInvoiceNumber(Hashtable HTMAIN, int gen_no)
public void SaveGenInvoiceNumber(BL_BASEFIELD objBSFD, int gen_no)
{
try
{
GetCorrectCon();
DataSet dsGEN_NO = new DataSet();
SqlCommand cmdinsert;
gen_no = Find_Gen_Miss(objBSFD.HTMAIN);
if (gen_no == 0)
{
//HTMAIN["TRAN_NO"] = Gen_Number(HTMAIN["TRAN_CD"].ToString(), HTMAIN["TRAN_SR"].ToString(), HTMAIN["fin_yr"].ToString(), HTMAIN["compid"].ToString());
objBSFD.HTMAIN["TRAN_NO"] = Gen_Number(objBSFD, objBSFD.HTMAIN["TRAN_SR"].ToString());
}
SqlDataAdapter da = new SqlDataAdapter("select tran_no from gen_tran where tran_cd='" + objBSFD.Code + "' and tran_sr='" + objBSFD.HTMAIN["TRAN_SR"].ToString() + "' and compid='" + objBSFD.ObjCompany.Compid.ToString() + "'", con);
//SqlDataAdapter da = new SqlDataAdapter("select MAX(tran_no) tran_no from (select isnull(max(tran_no),0)+1 tran_no from GEN_TRAN where tran_cd='" + objBSFD.Code + "' and tran_sr='" + objBSFD.HTMAIN["TRAN_SR"].ToString() + "' and fin_yr='" + objBSFD.ObjCompany.Fin_yr + "' and compid='" + objBSFD.ObjCompany.Compid.ToString() + "' union all select isnull(max(tran_no),0)+1 tran_no from GEN_MISS where tran_cd='" + objBSFD.Code + "' and tran_sr='" + objBSFD.HTMAIN["TRAN_SR"].ToString() + "' and fin_yr='" + objBSFD.ObjCompany.Fin_yr + "' and compid='" + objBSFD.ObjCompany.Compid.ToString() + "' and flg='Y')vw", con);
da.Fill(dsGEN_NO);
string tran_no;
tran_no = Regex.Match(objBSFD.HTMAIN["TRAN_NO"].ToString(), @"\d+").Value;
if (dsGEN_NO != null && dsGEN_NO.Tables[0].Rows.Count > 0)
{
if (int.Parse(dsGEN_NO.Tables[0].Rows[0]["tran_no"].ToString()) < int.Parse(tran_no.TrimStart('0')))
{
cmdinsert = new SqlCommand("update gen_tran set tran_no='" + tran_no.TrimStart('0') + "' where tran_cd='" + objBSFD.Code + "' and tran_sr='" + objBSFD.HTMAIN["TRAN_SR"].ToString() + "' and compid='" + objBSFD.ObjCompany.Compid.ToString() + "'", con);
con.Open();
cmdinsert.ExecuteNonQuery();
}
}
else
{
cmdinsert = new SqlCommand("insert into gen_tran values('" + objBSFD.ObjCompany.Compid.ToString() + "','" + objBSFD.Code + "','" + objBSFD.HTMAIN["TRAN_DT"].ToString() + "','" + (tran_no.TrimStart('0')) + "','" + objBSFD.HTMAIN["TRAN_SR"].ToString() + "','" + objBSFD.ObjCompany.Fin_yr + "')", con);
con.Open();
cmdinsert.ExecuteNonQuery();
}
}
catch (Exception ex)
{
AutoClosingMessageBox.Show("Connection Error : " + ex.Message, "Error", 5000);
}
finally
{
con.Close();
}
}
public string Gen_Number(BL_BASEFIELD objBSFD, string tran_sr)//, string tran_cd, string tran_sr, string fin_yr, string compid)
{
GetCorrectCon();
DataSet dsGENNO = new DataSet();
DataSet dsSER = new DataSet();
string tran_no = "1";
try
{
//SqlDataAdapter da = new SqlDataAdapter("select isnull(max(tran_no),0)+1 from GEN_TRAN where tran_cd='" + objBSFD.Code + "' and tran_sr='" + tran_sr + "' and fin_yr='" + objBSFD.ObjCompany.Fin_yr + "' and compid='" + objBSFD.ObjCompany.Compid.ToString() + "'", con);
SqlDataAdapter da = new SqlDataAdapter("select MAX(tran_no) tran_no from (select isnull(max(tran_no),0)+1 tran_no from GEN_TRAN where tran_cd='" + objBSFD.Code + "' and tran_sr='" + tran_sr + "' and fin_yr='" + objBSFD.ObjCompany.Fin_yr + "' and compid='" + objBSFD.ObjCompany.Compid.ToString() + "' union all select isnull(max(tran_no),0)+1 tran_no from GEN_MISS where tran_cd='" + objBSFD.Code + "' and tran_sr='" + tran_sr + "' and fin_yr='" + objBSFD.ObjCompany.Fin_yr + "' and compid='" + objBSFD.ObjCompany.Compid.ToString() + "' and flg='Y')vw", con);
SqlDataAdapter ds = new SqlDataAdapter("select Prefix,Suffix from SERIES where tran_sr='" + tran_sr + "' and fin_yr='" + objBSFD.ObjCompany.Fin_yr + "' and compid='" + objBSFD.ObjCompany.Compid.ToString() + "'", con);
da.Fill(dsGENNO);
ds.Fill(dsSER);
if (dsGENNO != null && dsGENNO.Tables[0].Rows.Count != 0)
{
foreach (DataRow row in dsGENNO.Tables[0].Rows)
{
tran_no = row[0].ToString();
}
}
if (dsSER != null && dsSER.Tables[0].Rows.Count != 0)
{
if ((dsSER.Tables[0].Rows[0]["Prefix"].ToString() == "" && dsSER.Tables[0].Rows[0]["Prefix"] == null) && (dsSER.Tables[0].Rows[0]["Suffix"].ToString() == "" && dsSER.Tables[0].Rows[0]["Suffix"] == null))
{
tran_no = tran_no.PadLeft(int.Parse(objBSFD.Tran_no_wid), '0');
}
if (dsSER.Tables[0].Rows[0]["Prefix"].ToString() != "" && dsSER.Tables[0].Rows[0]["Prefix"] != null)
{
tran_no = dsSER.Tables[0].Rows[0]["Prefix"].ToString() + "-" + tran_no.PadLeft(int.Parse(objBSFD.Tran_no_wid), '0');
}
if (dsSER.Tables[0].Rows[0]["Suffix"].ToString() != "" && dsSER.Tables[0].Rows[0]["Suffix"] != null)
{
tran_no = tran_no.PadLeft(int.Parse(objBSFD.Tran_no_wid), '0') + "-" + dsSER.Tables[0].Rows[0]["Suffix"].ToString();
}
}
}
catch (Exception ex)
{
AutoClosingMessageBox.Show("Connection Error : " + ex.Message, "Error", 5000);
}
return(tran_no.PadLeft(int.Parse(objBSFD.Tran_no_wid), '0'));
}
//public void SaveGenInvoiceNumber(Hashtable HTMAIN, int gen_no)
public void SaveGenInvoiceNumber(BL_BASEFIELD objBSFD, int gen_no)
{
objgen_invoice.SaveGenInvoiceNumber(objBSFD, gen_no);
}
public string Gen_Number(BL_BASEFIELD objBSFD, string tran_sr) //string tran_cd, string tran_sr, string fin_yr, string compid)
{
return(objgen_invoice.Gen_Number(objBSFD, tran_sr)); //tran_cd, tran_sr, fin_yr,compid);
}
public DataSet Get_Rep_Documents(BL_BASEFIELD objBLFD)
{
return(objRep.Get_Rep_Documents(objBLFD));
}
public DataSet GET_GRIDDATA(BL_BASEFIELD objBLBF)
{
return(objDL_BASEFIELD.GET_GRIDDATA(objBLBF));
}
public DataSet GetFile_List(BL_BASEFIELD objBF)
{
return(objDLGeneral.GetFile_List(objBF));
}
//public bool BindTransactionSetting(BL_BASEFIELD objBASEFILEDS, string tran_cd)
//{
// DataSet dset = objFLTransaction.GetTrans_Settings(tran_cd, objBASEFILEDS.ObjCompany.Compid.ToString());
// Type t = typeof(BL_BASEFIELD);
// PropertyInfo[] publicFieldInfos = t.GetProperties(BindingFlags.Instance | BindingFlags.Public);
// if (dset != null && dset.Tables[0].Rows.Count != 0)
// {
// foreach (PropertyInfo field in publicFieldInfos)
// {
// foreach (DataColumn col in dset.Tables[0].Columns)
// {
// if (null != field && field.CanWrite && field.Name.ToLower() == col.ColumnName.ToLower())
// {
// if (field.PropertyType.Name.ToLower() != "string")
// {
// if (dset.Tables[0].Rows[0][col.ColumnName] != null && dset.Tables[0].Rows[0][col.ColumnName].ToString() != "")
// {
// objBASEFILEDS.GetType().GetProperty(field.Name).SetValue(objBASEFILEDS, Convert.ChangeType(dset.Tables[0].Rows[0][col.ColumnName].ToString(), field.PropertyType), null);
// }
// }
// else
// objBASEFILEDS.GetType().GetProperty(field.Name).SetValue(objBASEFILEDS, Convert.ChangeType(dset.Tables[0].Rows[0][col.ColumnName].ToString(), field.PropertyType), null);
// }
// }
// }
// }
// else
// {
// return false;
// }
// return true;
//}
private void treeView1_DoubleClick(object sender, EventArgs e)
{
try
{
objIni.SetKeyFieldValue("SQL", "initial catalog", ((frm_mainmenu)this.MdiParent).ObjBLComp.Db_nm);
BL_BASEFIELD objBASEFILEDS = new BL_BASEFIELD();
objBASEFILEDS.ObjCompany = ((frm_mainmenu)this.MdiParent).ObjBLComp;
if (((frm_mainmenu)this.MdiParent).BindTransactionSetting(objBASEFILEDS, treeView1.SelectedNode.Name))
{
objRoles.ObjMainFields = ((frm_mainmenu)this.MdiParent).ObjBLMainFields;
if (objRoles.CheckPermisson("view," + objBASEFILEDS.Tran_nm))
{
objBASEFILEDS.Tran_mode = "view_mode";
objBASEFILEDS.Primary_id = objFLTransaction.GetPrimaryKeyFldNm(objBASEFILEDS.Main_tbl_nm, objBASEFILEDS.Tbl_catalog).ToUpper();
objBASEFILEDS.dsNavigation = objFLTransaction.GET_ALL_NAVIGATION_DATA(objBASEFILEDS, "");
objBASEFILEDS.Curr_date_time = DateTime.Now.ToString();
((frm_mainmenu)this.MdiParent).ActiveBLBF = objBASEFILEDS; ((frm_mainmenu)this.MdiParent).ActiveBLBF.ObjCompany = ((frm_mainmenu)this.MdiParent).ObjBLComp;
((frm_mainmenu)this.MdiParent).ActiveBLBF.ObjControlSet = ((frm_mainmenu)this.MdiParent).ObjControlSetTran;
((frm_mainmenu)this.MdiParent).ActiveBLBF.ObjLoginUser = ((frm_mainmenu)this.MdiParent).ObjBLMainFields;
ifrm_transaction objtransaction = new ifrm_transaction(objBASEFILEDS);
objtransaction.Tran_cd = treeView1.SelectedNode.Name;
if (((frm_mainmenu)this.MdiParent).ActiveBLBF.dsNavigation.Tables[0].Rows.Count > 0)
{
objtransaction.Tran_id = ((frm_mainmenu)this.MdiParent).ActiveBLBF.dsNavigation.Tables[0].Rows.Count > 0 ? ((frm_mainmenu)this.MdiParent).ActiveBLBF.dsNavigation.Tables[0].Rows[((frm_mainmenu)this.MdiParent).ActiveBLBF.dsNavigation.Tables[0].Rows.Count - 1][((frm_mainmenu)this.MdiParent).ActiveBLBF.Primary_id].ToString() : "0";
((frm_mainmenu)this.MdiParent).ActiveBLBF.Tran_id = objtransaction.Tran_id;
((frm_mainmenu)this.MdiParent).ObjBLMainFields.HASHTOOL[objtransaction.Tran_cd + ((frm_mainmenu)this.MdiParent).ObjBLMainFields.CurUser + ((frm_mainmenu)this.MdiParent).ActiveBLBF.Curr_date_time] = ((frm_mainmenu)this.MdiParent).ActiveBLBF.dsNavigation.Tables[0].Rows.Count - 1;//+objtransaction.objBASEFILEDS.GetHashCode().ToString()
}
else
{
objtransaction.Tran_id = "0";
((frm_mainmenu)this.MdiParent).ActiveBLBF.Tran_id = objtransaction.Tran_id;
((frm_mainmenu)this.MdiParent).ObjBLMainFields.HASHTOOL[objtransaction.Tran_cd + ((frm_mainmenu)this.MdiParent).ObjBLMainFields.CurUser + ((frm_mainmenu)this.MdiParent).ActiveBLBF.Curr_date_time] = 0;
}
objtransaction.Tran_mode = "view_mode";
objtransaction.Name = objBASEFILEDS.Tran_nm;
// objtransaction.Text = objBASEFILEDS.Tran_nm;
objtransaction.MdiParent = ((frm_mainmenu)this.MdiParent);
objtransaction.Show();
}
else
{
AutoClosingMessageBox.Show("Access Denied", "Access Rights", 3000);
}
}
else
{
AutoClosingMessageBox.Show("Transaction is not exist", "Invalid Transaction", 3000);
}
}
catch (Exception ex)
{
}
finally
{
this.Activate();
}
#region
//try
//{
// // objIni.SetKeyFieldValue("SQL", "initial catalog", objBLComp.Db_nm);
// BL_BASEFIELD objBASEFILEDS = new BL_BASEFIELD();
// objBASEFILEDS.ObjCompany = objBSFD.ObjCompany;
// if (((frm_mainmenu)this.MdiParent).ActiveMdiChild != null)
// {
// if (((frm_mainmenu)this.MdiParent).BindTransactionSetting(objBASEFILEDS, cmbtran_nm.SelectedValue.ToString()))// efreshToolbar(this.tran_cd, this.tran_mode);)
// {
// objRoles.ObjMainFields = ((frm_mainmenu)this.MdiParent).ObjBLMainFields;
// if (objRoles.CheckPermisson("view," + objBASEFILEDS.Tran_nm))
// {
// objBASEFILEDS.Tran_mode = "view_mode";
// objBASEFILEDS.Primary_id = objFLTransaction.GetPrimaryKeyFldNm(objBASEFILEDS.Main_tbl_nm, objBASEFILEDS.Tbl_catalog).ToUpper();
// objBASEFILEDS.Curr_date_time = DateTime.Now.ToString();
// ((frm_mainmenu)this.MdiParent).ActiveBLBF = objBASEFILEDS;
// ((frm_mainmenu)this.MdiParent).ActiveBLBF.ObjCompany = objBSFD.ObjCompany;
// objBASEFILEDS.ObjLoginUser = ((frm_mainmenu)this.MdiParent).ObjBLMainFields;
// ifrm_transaction objtransaction = new ifrm_transaction(objBASEFILEDS);
// objtransaction.Tran_cd = cmbtran_nm.SelectedValue.ToString();
// objtransaction.Tran_id = dgvApprove.CurrentRow.Cells["tran_id"].Value.ToString();
// objBASEFILEDS.Tran_id = objtransaction.Tran_id;
// ((frm_mainmenu)this.MdiParent).ActiveBLBF.Tran_id = objtransaction.Tran_id;
// ((frm_mainmenu)this.MdiParent).ActiveBLBF.Tran_mode_type = "approve_only";
// objBASEFILEDS.Tran_mode_type = "approve_only";
// objtransaction.Tran_mode = "view_mode";
// objtransaction.Name = objBASEFILEDS.Tran_nm;
// objtransaction.Text = objBASEFILEDS.Tran_nm;
// objtransaction.MdiParent = this.ParentForm;
// objtransaction.MinimizeBox = false;
// objtransaction.Show();
// objtransaction.Activate();
// }
// else
// {
// AutoClosingMessageBox.Show("Access Denied","Access Rights",3000);
// }
// }
// else
// {
// AutoClosingMessageBox.Show("Transaction is not exist","Transaction",3000);
// }
// }
//}
//catch (Exception ex)
//{
//}
//finally
//{
//}
#endregion
}
public DataSet GetMenuListParent(BL_BASEFIELD objBF, string Module_list)
{
return(objDLGeneral.GetMenuListParent(objBF, Module_list));
}
public DataSet GetMenuListChild(BL_BASEFIELD objBF, string parent_id, string Module_list)
{
return(objDLGeneral.GetMenuListChild(objBF, parent_id, Module_list));
}
public DataSet Get_Ref_Item_Grid(BL_BASEFIELD objBLFD, string refering_cd)
{
return(objDLPICKUP.Get_Ref_Item_Grid(objBLFD, refering_cd));
}
public DataSet Get_Ref_main_Details(BL_BASEFIELD objBLFD, string ac_nm, string _rule, string ref_type)
{
return(objDLPICKUP.Get_Ref_main_Details(objBLFD, ac_nm, _rule, ref_type));
}
public DataSet GetMenuListChild(BL_BASEFIELD objBF, string parent_id, string Module_list)
{
string sqlQuery = "select * FROM MENU_TBL where [level_id]!=0 and parent_id=" + parent_id + " and compid='" + objBF.ObjCompany.Compid.ToString() + "' order by order_no";
return(objdlAdapter.dsquery(sqlQuery));
}
public DataSet GetFile_List(BL_BASEFIELD objBF)
{
string sqlQuery = "SELECT * from FILE_MAST WHERE code='" + objBF.Code + "' and COMPID=" + objBF.ObjCompany.Compid.ToString() + "";
return(objdlAdapter.dsquery(sqlQuery));
}
public string Get_Company_Id(BL_BASEFIELD objBLFD)
{
return(objDL_Transaction.Get_Company_Id(objBLFD));
}
public bool AmendementDetails()
{
bool _flgContinue = false;
BL_BASEFIELD oldFileds = new BL_BASEFIELD();//(BL_BASEFIELD)ACTIVE_BL.Clone();
DataSet dsetview = objdblayer.dsquery("select top 1 * from " + ACTIVE_BL.Main_tbl_nm + " where tran_cd='" + ACTIVE_BL.Code + "' and " + ACTIVE_BL.Primary_id + "='" + ACTIVE_BL.HTMAIN[ACTIVE_BL.Primary_id].ToString() + "' and compid='" + ACTIVE_BL.ObjCompany.Compid.ToString() + "' order by " + ACTIVE_BL.Primary_id + " desc");
Hashtable HTITEMVal = ACTIVE_BL.HTMAIN;
foreach (DictionaryEntry entry in HTITEMVal)
{
oldFileds.HTMAIN[entry.Key] = entry.Value;
}
if (dsetview != null && dsetview.Tables.Count != 0 && dsetview.Tables[0].Rows.Count != 0)
{
if (objBLFD.HTMAIN["IM_AMDNO"] != null && objBLFD.HTMAIN["IM_AMDNO"].ToString() != "" && objBLFD.HTMAIN["IM_AMDNO"].ToString() != dsetview.Tables[0].Rows[0]["IM_AMDNO"].ToString())
{
_flgContinue = true;
foreach (DataRow row in dsetview.Tables[0].Rows)
{
foreach (DataColumn column in dsetview.Tables[0].Columns)
{
if (oldFileds.HTMAIN.ContainsKey(column.ColumnName.Trim().ToUpper()))
{
if (column.DataType.Name.ToString().ToLower() == "datetime")
{
if (row[column.ColumnName] != null && row[column.ColumnName].ToString() != "")
{
oldFileds.HTMAIN[column.ColumnName.Trim().ToUpper()] = DateTime.Parse(row[column.ColumnName].ToString()).ToString("yyyy/MM/dd");
}
else
{
oldFileds.HTMAIN[column.ColumnName.Trim().ToUpper()] = DateTime.Parse("01/01/1900");
}
}
else
{
oldFileds.HTMAIN[column.ColumnName.Trim().ToUpper()] = row[column.ColumnName].ToString().Trim();
}
}
}
}
}
}
if (_flgContinue && oldFileds.Item_tbl_nm != "")
{
dsetview.Clear();
dsetview = objdblayer.dsquery("select * from " + ACTIVE_BL.Item_tbl_nm + " where tran_cd='" + ACTIVE_BL.Code + "' and " + ACTIVE_BL.Primary_id + "='" + ACTIVE_BL.HTMAIN[ACTIVE_BL.Primary_id].ToString() + "' and compid='" + ACTIVE_BL.ObjCompany.Compid.ToString() + "' order by cast(ptserial as int)");
if (dsetview != null && dsetview.Tables.Count != 0 && dsetview.Tables[0].Rows.Count != 0)
{
foreach (DataRow row in dsetview.Tables[0].Rows)
{
oldFileds.HTITEM[row["PTSERIAL"].ToString().Trim()] = new Hashtable(StringComparer.InvariantCultureIgnoreCase);
foreach (DictionaryEntry entry in ACTIVE_BL.htitem_details)
{
((Hashtable)oldFileds.HTITEM[row["PTSERIAL"].ToString().Trim()])[entry.Key] = entry.Value.ToString().Trim();
}
foreach (DataColumn column in dsetview.Tables[0].Columns)
{
if (((Hashtable)oldFileds.HTITEM[row["PTSERIAL"].ToString().Trim()]).ContainsKey(column.ColumnName.Trim().ToUpper()))
{
if (column.DataType.Name.ToString().ToLower() == "datetime")
{
if (row[column.ColumnName] != null && row[column.ColumnName].ToString() != "")
{
((Hashtable)oldFileds.HTITEM[row["PTSERIAL"].ToString().Trim()])[column.ColumnName.Trim().ToUpper()] = DateTime.Parse(row[column.ColumnName].ToString()).ToString("yyyy/MM/dd");
}
else
{
((Hashtable)oldFileds.HTITEM[row["PTSERIAL"].ToString().Trim()])[column.ColumnName.Trim().ToUpper()] = DateTime.Parse("01/01/1900");
}
}
else
{
((Hashtable)oldFileds.HTITEM[row["PTSERIAL"].ToString().Trim()])[column.ColumnName.Trim().ToUpper()] = row[column.ColumnName].ToString().Trim();
}
}
}
}
}
}
if (_flgContinue && ACTIVE_BL != null && oldFileds != null)
{
try
{
if (objBLFD.HASHTABLES != null)
{
objhashtables = objBLFD.HASHTABLES;
}
else
{
objhashtables.HashGeneraltbl = new Hashtable(StringComparer.InvariantCultureIgnoreCase);
}
int k = 0;
foreach (DictionaryEntry entry in ACTIVE_BL.HTMAIN)
{
if (oldFileds.HTMAIN.Contains(entry.Key) && ACTIVE_BL.HTMAIN[entry.Key].ToString() != oldFileds.HTMAIN[entry.Key].ToString())
{
k++;
objhashtables.HashGeneraltbl[k] = new Hashtable(StringComparer.InvariantCultureIgnoreCase);
((Hashtable)objhashtables.HashGeneraltbl[k])["fld_nm"] = entry.Key;
((Hashtable)objhashtables.HashGeneraltbl[k])["old_value"] = oldFileds.HTMAIN[entry.Key].ToString();
((Hashtable)objhashtables.HashGeneraltbl[k])["new_value"] = entry.Value.ToString();
((Hashtable)objhashtables.HashGeneraltbl[k])["ptserial"] = "";
}
}
foreach (DictionaryEntry entry1 in ACTIVE_BL.HTITEM)
{
if (((Hashtable)ACTIVE_BL.HTITEM).Count != 0)
{
if (oldFileds.HTITEM.Contains(entry1.Key))
{
foreach (DictionaryEntry entry in ((Hashtable)entry1.Value))
{
if (((Hashtable)oldFileds.HTITEM[entry1.Key]).Contains(entry.Key.ToString()) && entry.Value.ToString() != ((Hashtable)oldFileds.HTITEM[entry1.Key])[entry.Key.ToString()].ToString())
{
k++;
objhashtables.HashGeneraltbl[k] = new Hashtable(StringComparer.InvariantCultureIgnoreCase);
((Hashtable)objhashtables.HashGeneraltbl[k])["fld_nm"] = entry.Key;
((Hashtable)objhashtables.HashGeneraltbl[k])["old_value"] = ((Hashtable)oldFileds.HTITEM[entry1.Key])[entry.Key].ToString();
((Hashtable)objhashtables.HashGeneraltbl[k])["new_value"] = entry.Value.ToString();
((Hashtable)objhashtables.HashGeneraltbl[k])["ptserial"] = entry1.Key;
}
}
}
else
{
k++;
objhashtables.HashGeneraltbl[k] = new Hashtable(StringComparer.InvariantCultureIgnoreCase);
((Hashtable)objhashtables.HashGeneraltbl[k])["fld_nm"] = "ptserial";
((Hashtable)objhashtables.HashGeneraltbl[k])["old_value"] = "";
((Hashtable)objhashtables.HashGeneraltbl[k])["new_value"] = "";
((Hashtable)objhashtables.HashGeneraltbl[k])["ptserial"] = entry1.Key;
}
}
}
objBLFD.HASHTABLES = objhashtables;
}
catch (Exception ex)
{
}
}
return(true);
}
public frmBakUp(BL_BASEFIELD objBL)
{
InitializeComponent(); this.Tran_cd = objBL.Code;
objBASEFILEDS.HTMAIN["TRAN_CD"] = this.tran_cd;
this.objBASEFILEDS = objBL;
}
//public DataSet Get_Ref_item_Details(string ref_tran_id, string ref_tran_cd, string tran_mode, string tran_id, string tran_cd,string beh_cd,string ref_beh_cd,string ac_nm)
//{objDLPICKUP.objCompany = objCompany;
// return objDLPICKUP.Get_Ref_item_Details(ref_tran_id, ref_tran_cd, tran_mode, tran_id, tran_cd,beh_cd,ref_beh_cd,ac_nm);
//}
public DataSet Get_Ref_item_Details(string ref_tran_id, string ref_tran_cd, string tran_mode, BL_BASEFIELD objBLFD, string ac_nm, string _rule)
{
return(objDLPICKUP.Get_Ref_item_Details(ref_tran_id, ref_tran_cd, tran_mode, objBLFD, ac_nm, _rule));
}
public DataSet Get_PickUpDetails(BL_BASEFIELD objBLFD, string refering_cd, string tran_cd)
{
return(objdlAdapter.dsquery("if exists(select * from ireference where tran_cd='" + tran_cd + "' and valid_mast='" + refering_cd + "' and compid='" + objBLFD.ObjCompany.Compid.ToString() + "') select ref_id,typewise,Tran_cd,beh_cd,ref_beh_cd,valid_mast,head_nm,order_no,col_order_no,fld_nm,data_ty,fld_wid,fld_desc,inter_val,tbl_nm,_copy,_read,compid from iREFERENCE where tran_cd='" + tran_cd + "' and valid_mast='" + refering_cd + "' and compid='" + objBLFD.ObjCompany.Compid.ToString() + "' order by typewise,order_no else select im_ref_id ref_id,typewise,Tran_cd,beh_cd,ref_beh_cd,valid_mast,head_nm,order_no,col_order_no,fld_nm,data_ty,fld_wid,fld_desc,inter_val,tbl_nm,_copy,_read,compid from IMPORT_iREFERENCE order by typewise,cast(order_no as int)"));
}
public DataSet Get_PickUpDetails(BL_BASEFIELD objBLFD, string refering_cd, string tran_cd)
{
return(objDLPICKUP.Get_PickUpDetails(objBLFD, refering_cd, tran_cd));
}
public DataSet Get_Ref_Item_Grid(BL_BASEFIELD objBLFD, string refering_cd)
{
return(objdlAdapter.dsquery("select * from ireference where valid_mast='" + refering_cd + "' and tran_cd='" + objBLFD.Code + "' and typewise=0 and compid='" + objBLFD.ObjCompany.Compid.ToString() + "' order by cast(order_no as int)"));
}
