public static bool Update(ConfigItem p_configItem, DataRow p_row)
{
try
{
object[] arrValue = new object[] {
p_row["Id"],
p_row["Name"],
p_row["Group_Pk"],
p_configItem.Login_UserName,
p_row["Remark"],
p_row["Unit_Pk"],
p_row["slton"]
};
string[] arrParaName = new string[] {
"@Id",
"@Name",
"@Group_Pk",
"@Mod_By",
"@Remark",
"@Unit_Pk",
"@number_in"
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
_sql.ExecuteNonQuery("USP_UPD_ITEM", arrNames: arrParaName, arrValues: arrValue);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
private bool Update(DataRow row)
{
try
{
string[] arrParaName = new string[] {
"@Id",
"@Name",
"@Crt_Dt",
"@Crt_By",
"@Remark"
};
object[] arrParaValue = new object[] {
row["Id"],
row["Name"],
DateTime.Now,
_ConfigItem.Login_UserName,
row["Remark"]
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(_ConfigItem);
_sql.ExecuteNonQuery("USP_UPD_UNIT", arrNames: arrParaName, arrValues: arrParaValue);
return(true);
}
catch (Exception ex)
{
AppDebug(ex);
return(false);
}
}
private bool InsertData(DataTable tbDetail, int _id_WareHouse, int _TotalAMT, int _iId_Supplier_Pk, DateTime _iTake_In_Date, int _User_Pk, string _BillNumber, string _Remark, DateTime _billdate)
{
System.Data.SqlClient.SqlConnection _sqlConnection = new System.Data.SqlClient.SqlConnection(_ConfigItem.StrConnection);
if (_sqlConnection.State != ConnectionState.Open)
{
_sqlConnection.Open();
}
System.Data.SqlClient.SqlTransaction _sqlTransaction = _sqlConnection.BeginTransaction();
try
{
int _iNumberItem = tbDetail.Rows.Count;
string[] arrName = new string[] { "@Supplier_Pk", "@Take_In_Date", "@Number_Item", "@TotalAMT", "@Crt_By", "@WareHouse_Pk", "@Remark", "@BillNumber", "@BillDate", "@User_Pk" };
object[] arrValue = new object[] { _iId_Supplier_Pk, _iTake_In_Date, _iNumberItem, _TotalAMT, _ConfigItem.Login_UserName, _id_WareHouse, _Remark, _BillNumber, _billdate, _User_Pk };
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL();
int _idMaster = _providerSQL.ExecuteInsert(_sqlConnection, _sqlTransaction, "USP_INS_TAKE_IN", arrName, arrValue);
for (int i = 0; i < _iNumberItem; i++)
{
arrName = new string[] {
"@Take_In_Pk",
"@Crt_By",
"@Remark",
"@Number_Bill",
"@Number_Real",
"@Price",
"@Vat",
"@Item_Pk",
"@UnitStyle_Pk"
};
arrValue = new object[] {
_idMaster,
_ConfigItem.Login_UserName,
string.Empty,
tbDetail.Rows[i]["Number_Bill"],
tbDetail.Rows[i]["Number_Real"],
tbDetail.Rows[i]["Price"],
tbDetail.Rows[i]["Vat"],
tbDetail.Rows[i]["Item_Pk"],
tbDetail.Rows[i]["UnitStyle_Pk"]
};
_providerSQL.ExecuteNonQuery(_sqlConnection, _sqlTransaction, "USP_INS_TAKE_IN_DETAIL", arrName, arrValue);
}
_sqlTransaction.Commit();
_providerSQL.Disconnect(_sqlConnection);
return(true);
}
catch (Exception ex)
{
_sqlTransaction.Rollback();
AppDebug(ex);
if (_providerSQL != null)
{
if (_sqlConnection != null)
{
_providerSQL.Disconnect(_sqlConnection);
}
}
return(false);
}
}
private bool DeleteItem(int[] p_selectRow, DataTable p_datasource)
{
System.Data.SqlClient.SqlConnection _sqlConnection = new System.Data.SqlClient.SqlConnection(_ConfigItem.StrConnection);;
if (_sqlConnection.State != ConnectionState.Open)
{
_sqlConnection.Open();
}
System.Data.SqlClient.SqlTransaction _sqlTransaction = _sqlConnection.BeginTransaction();
try
{
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL();
string[] arrName = new string[] { "@Id", "@Mod_By", "@Mod_Dt" };
for (int i = 0; i < p_selectRow.Length; i++)
{
object[] arrValue = new object[] { p_datasource.Rows[i]["Id"], _ConfigItem.Login_UserName, DateTime.Now };
_providerSQL.ExecuteNonQuery(_sqlConnection, _sqlTransaction, "USP_DEL_TAKE_IN_DETAIL", arrName, arrValue);
}
_sqlTransaction.Commit();
return(true);
}
catch (Exception ex)
{
_sqlTransaction.Rollback();
AppDebug(ex);
if (_sqlConnection.State != ConnectionState.Closed)
{
_sqlConnection.Close();
}
return(false);
}
}
public static int Insert(ConfigItem p_configItem, DataRow p_row)
{
int ma = 0;
try
{
object[] arrValue = new object[] {
p_row["Name"],
p_row["Group_Pk"],
p_configItem.Login_UserName,
p_row["Remark"],
p_row["Unit_Pk"],
p_row["slton"]
};
string[] arrParaName = new string[] {
"@Name",
"@Group_Pk",
"@Crt_By",
"@Remark",
"@Unit_Pk",
"@number_in"
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
ma = _sql.ExecuteInsert("USP_INS_ITEM", arrNames: arrParaName, arrValues: arrValue);
}
catch (Exception ex)
{
throw ex;
}
return(ma);
}
public static bool Update(ConfigItem p_ConfigItem, object[] parramValue)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Id",
"@Name",
"@Phone",
"@Address",
"@Fax",
"@Email",
"@Website",
"@Mod_By",
"@TaxCode",
"@Credit",
"@Debit"
};
_sql.Connect(p_ConfigItem);
_sql.ExecuteNonQuery("USP_UPD_SUPPLIER", arrNames: arrParaName, arrValues: parramValue);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static int Insert(ConfigItem p_ConfigItem, object[] parramValue)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Name",
"@Phone",
"@Address",
"@Fax",
"@Email",
"@Website",
"@Crt_By",
"@TaxCode",
"@Credit",
"@Debit"
};
_sql.Connect(p_ConfigItem);
return(_sql.ExecuteInsert("USP_INS_SUPPLIER", arrParaName, parramValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static bool Update(ConfigItem p_ConfigItem, object[] arrValue)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Id",
"@Name",
"@Crt_Dt",
"@Crt_By",
"@Remark"
};
_sql.Connect(p_ConfigItem);
_sql.ExecuteNonQuery("USP_UPD_UNIT", arrParaName, arrValue);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static int Insert(ConfigItem p_configItem, DataRow p_dtRow)
{
int ma = 0;
try
{
object[] arrValue = new object[] {
p_dtRow["Unit_In_Pk"],
p_dtRow["Unit_Out_Pk"],
p_dtRow["Remark"],
p_dtRow["Num"],
p_configItem.Login_UserName
};
string[] arrParaName = new string[] {
"@Unit_In_Pk",
"@Unit_Out_Pk",
"@Remark",
"@Num",
"@Crt_By"
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
ma = _sql.ExecuteInsert("USP_INS_UNIT_STYLE", arrParaName, arrValue);
}
catch (Exception ex)
{
throw ex;
}
return(ma);
}
public static bool Update(ConfigItem p_configItem, DataRow p_dtRow)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
object[] arrValue = new object[] {
p_dtRow["Id"],
p_dtRow["Unit_In_Pk"],
p_dtRow["Unit_Out_Pk"],
p_dtRow["Remark"],
p_dtRow["Num"]
};
string[] arrParaName = new string[] {
"@Id",
"@Unit_In_Pk",
"@Unit_Out_Pk",
"@Remark",
"@Num"
};
_sql.Connect(p_configItem);
_sql.ExecuteNonQuery("USP_UPD_UNIT_STYLE", arrParaName, arrValue);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static bool Update(ConfigItem p_ConfigItem, object[] arrValue)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Id",
"@Name_Dis",
"@Name",
"@Password",
"@Mod_By",
"@Remark",
"@Phone",
"@Address",
"@Department_Pk"
};
_sql.Connect(p_ConfigItem);
_sql.ExecuteNonQuery("USP_UPD_USER", arrNames: arrParaName, arrValues: arrValue);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static int Insert(ConfigItem p_ConfigItem, object[] arrValue)
{
int ma = 0;
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Name_Dis",
"@Name",
"@Password",
"@Crt_By",
"@Remark",
"@Phone",
"@Address",
"@Department_Pk"
};
_sql.Connect(p_ConfigItem);
ma = _sql.ExecuteInsert("USP_INS_USER", arrNames: arrParaName, arrValues: arrValue);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
return(ma);
}
private bool DeleteTakeIn(int p_IdTakeIn)
{
System.Data.SqlClient.SqlConnection _sqlConnection = new System.Data.SqlClient.SqlConnection(_ConfigItem.StrConnection);;
if (_sqlConnection.State != ConnectionState.Open)
{
_sqlConnection.Open();
}
System.Data.SqlClient.SqlTransaction _sqlTransaction = _sqlConnection.BeginTransaction();
try
{
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL();
string[] arrName = new string[] { "@Id", "@Mod_By" };
object[] arrValue = new object[] { p_IdTakeIn, _ConfigItem.Login_UserName };
_providerSQL.ExecuteNonQuery(_sqlConnection, _sqlTransaction, "USP_DEL_TAKE_IN", arrName, arrValue);
_sqlTransaction.Commit();
return(true);
}
catch (Exception ex)
{
_sqlTransaction.Rollback();
AppDebug(ex);
if (_sqlConnection.State != ConnectionState.Closed)
{
_sqlConnection.Close();
}
return(false);
}
}
private DataTable LoadData()
{
try
{
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL(_ConfigItem);
return(_providerSQL.GetDataByStoredProcedure("USP_SEL_UNIT"));
}
catch (Exception ex)
{
AppDebug(ex);
return(null);
}
}
public static bool Update(ConfigItem p_ConfigItem, Supplier p_Supplier)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] {
"@Id",
"@Name",
"@Phone",
"@Phone1",
"@Address",
"@Address1",
"@Fax",
"@Email",
"@Website",
"@Mod_By",
"@TaxCode",
"@Credit",
"@Debit"
};
object[] arrParaValue = new object[] {
p_Supplier.Id,
p_Supplier.Name,
p_Supplier.Phone,
p_Supplier.Phone1,
p_Supplier.Address,
p_Supplier.Address1,
p_Supplier.Fax,
p_Supplier.Email,
p_Supplier.Website,
p_ConfigItem.Login_UserName,
p_Supplier.TaxCode,
p_Supplier.Credit,
p_Supplier.Debit
};
_sql.Connect(p_ConfigItem);
_sql.ExecuteNonQuery("USP_UPD_SUPPLIER", arrNames: arrParaName, arrValues: arrParaValue);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public DataTable GetList()
{
DataTable dt = null;
try
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
dt = _sql.GetDataByStoredProcedure("USP_SEL_DEPARTMENT");
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static bool Delete(ConfigItem p_configItem, int p_idSuppiler)
{
try
{
string[] arrParaName = new string[] { "@Id" };
object[] arrParaValue = new object[] { p_idSuppiler };
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
_sql.ExecuteNonQuery("USP_DEL_ITEM", arrParaName, arrParaValue);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetList(ConfigItem p_configItem)
{
DataTable dt = null;
try
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
dt = _sql.GetDataByStoredProcedure("USP_SEL_ITEM_All");
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public bool Delete(int _idSuppiler)
{
try
{
string[] arrParaName = new string[] { "@Id" };
object[] arrParaValue = new object[] { _idSuppiler };
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
_sql.ExecuteNonQuery("usp_DeleteVPP_GROUP", arrParaName, arrParaValue);
return(true);
}
catch (Exception ex)
{
//TODO: Ghi log cho nay.
throw ex;
}
}
public DataTable GetnumChuyenTo(int idDepart, int idItem)
{
DataTable dt = null;
try
{
string sql = string.Format("select sum( Num) as Num from dbo.viNumDepartmentTo where Department_To_Pk={0} and Item_Pk={1}", idDepart, idItem);
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
dt = _sql.GetDataBySQL(sql);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
public static DataTable GetList(ConfigItem p_ConfigItem)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
_sql.Connect(p_ConfigItem);
return(_sql.GetDataByStoredProcedure("USP_SEL_GROUP_All"));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static DataTable GetList_1(ConfigItem p_configItem)
{
COREBASE.COMMAND.SQL.AccessSQL l_sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
l_sql.Connect();
return(l_sql.GetDataByStoredProcedure("USP_SEL_UNIT_STYLE_1"));
}
catch (Exception ex)
{
throw ex;
}
finally
{
l_sql.Disconnect();
}
}
private DataTable LoadData(string strParam, int idMaster)
{
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL(_ConfigItem);
switch (strParam)
{
case "MASTER":
return(_providerSQL.GetDataByStoredProcedure("USP_SEL_TAKE_IN"));
case "DETAIL":
string[] arrName = new string[] { "@Take_In_Pk" };
object[] arrValue = new object[] { idMaster };
return(_providerSQL.GetDataByStoredProcedure("USP_SEL_TAKE_IN_DETAIL", arrName, arrValue));
default:
return(null);
}
}
private void NhapKho_Load(object sender, EventArgs e)
{
DataTable tbTmp = LoadData("MASTER", -1);
lstTakeIn.DataSource = tbTmp;
lstTakeIn.DisplayMember = "Date_Take_In";
lstTakeIn.ValueMember = "Id";
AssignTagValueOnDXControl(this);
//LAY THONG TIN CHO CAC COMBOBOX
_providerSQL = new COREBASE.COMMAND.SQL.AccessSQL(_ConfigItem);
txtSuppierID.Properties.DataSource = _providerSQL.GetDataByStoredProcedure("USP_SEL_SUPPLIER");
cboWareHouse.Properties.DataSource = COREBASE.COMMAND.VPP_COMMAND.CWareHouse.ListWareHouse(_ConfigItem);
lkUser.Properties.DataSource = COREBASE.COMMAND.VPP_COMMAND.CUser.ListUser(_ConfigItem);
replkeditItem.DataSource = ItemDao.GetList(_ConfigItem);
replkeditstyle.DataSource = UnitStyleDao.GetList_1(_ConfigItem);
}
private void Delete(int _id)
{
try
{
string[] arrParaName = new string[] {
"@Id"
};
object[] arrParaValue = new object[] {
_id
};
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(_ConfigItem);
_sql.ExecuteNonQuery("USP_DEL_UNIT", arrNames: arrParaName, arrValues: arrParaValue);
}
catch (Exception ex)
{
AppDebug(ex);
}
}
public static DataTable GetList(ConfigItem p_configItem, int p_GroupID)
{
COREBASE.COMMAND.SQL.AccessSQL l_sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
l_sql.Connect();
string[] l_arrName = new string[] { "@Group_Pk" };
object[] l_arrValue = new object[] { p_GroupID };
return(l_sql.GetDataByStoredProcedure("USP_SEL_ITEM_BY_GROUP_ID", l_arrName, l_arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
l_sql.Disconnect();
}
}
public static int Delete(ConfigItem p_configItem, int p_Group_Pk)
{
COREBASE.COMMAND.SQL.AccessSQL l_sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
string[] l_arrName = new string[] { "@Id" };
object[] l_arrValue = new object[] { p_Group_Pk };
l_sql.Connect(p_configItem);
return(l_sql.ExecuteNonQuery("USP_DEL_GROUP", l_arrName, l_arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
l_sql.Disconnect();
}
}
public static DataTable GetList(ConfigItem p_ConfigItem, int p_Catalog_Pk)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
string[] arrParaName = new string[] { "@Id" };
object[] arrValue = new object[] { p_Catalog_Pk };
_sql.Connect(p_ConfigItem);
return(_sql.GetDataByStoredProcedure("USP_SEL_CATALOG_BY_ID", arrParaName, arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
public static int Update(ConfigItem p_configItem, DataRow p_drGroup)
{
COREBASE.COMMAND.SQL.AccessSQL l_sql = new COREBASE.COMMAND.SQL.AccessSQL(p_configItem);
try
{
string[] l_arrName = new string[] { "@Id", "@Name", "@Mod_By", "@Remark", "@ID_Cat" };
object[] l_arrValue = new object[] { p_drGroup["Id"], p_drGroup["Name"], p_configItem.Login_UserName, p_drGroup["Remark"], p_drGroup["Id_Cat"] };
l_sql.Connect(p_configItem);
return(l_sql.ExecuteNonQuery("USP_UPD_GROUP", l_arrName, l_arrValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
l_sql.Disconnect();
}
}
public static DataSet GetListTakeOut(int p_Take_Out_Pk, ConfigItem p_ConfigItem)
{
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(p_ConfigItem);
try
{
_sql.Connect(p_ConfigItem);
string[] arrParaName = new string[] { "@Take_Out_Pk" };
object[] arrParaValue = new object[] { p_Take_Out_Pk };
return(_sql.GetDataByStoredProcedure_DS("USP_RPT_TAKE_OUT", arrParaName, arrParaValue));
}
catch (Exception ex)
{
throw ex;
}
finally
{
_sql.Disconnect();
}
}
