private void TableDeleteKor(string fileName, string isaColName, string foxproColName)
{
string tableName = "";
DataTable dt = Foxpro.ReadDeletedFile(_fileName);
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("psp_POS_DELETE_TABLE"));
foreach (DataRow dr in dt.Rows)
{
if (Tools.isNull(dr["Sumber"], "").ToString().Trim() == "NPJ")
{
tableName = "KoreksiPenjualan";
}
if (Tools.isNull(dr["Sumber"], "").ToString().Trim() == "NRJ")
{
tableName = "KoreksiReturPenjualan";
}
if (Tools.isNull(dr["Sumber"], "").ToString().Trim() == "NPB")
{
tableName = "KoreksiPembelian";
}
if (Tools.isNull(dr["Sumber"], "").ToString().Trim() == "NRB")
{
tableName = "KoreksiReturPembelian";
}
db.Commands[0].Parameters.Clear();
db.Commands[0].Parameters.Add(new Parameter("@tableName", SqlDbType.VarChar, tableName));
db.Commands[0].Parameters.Add(new Parameter("@columnKeyName", SqlDbType.VarChar, isaColName));
db.Commands[0].Parameters.Add(new Parameter("@columnKeyValue", SqlDbType.VarChar, Tools.isNull(dr[foxproColName], "").ToString().Trim()));
db.Commands[0].ExecuteNonQuery();
}
}
}
public void DownloadNotaPenjualanDetail()
{
string fileName = "CockpitTmp\\DtjTmp" + GlobalVar.CabangID + ".DBF";
fileName = GlobalVar.DbfDownload + "\\" + fileName;
label1.Text = "Nota Penjualan Detail";
DataTable result = ValidateFile(fileName, DtransjDt);
this.refreshForm();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("psp_UPLOAD_CONFIRMATION_NotaPenjualanDetail"));
foreach (DataRow dr in result.Rows)
{
db.Commands[0].Parameters.Clear();
db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, Tools.isNull(dr["idrec"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@Confirm", SqlDbType.Int, 0));
db.Commands[0].ExecuteNonQuery();
pbSyncDownload.Increment(1);
this.refreshForm();
}
}
DataTable dt = Foxpro.ReadDeletedFile(fileName);
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_DeletedHistory_UPDATE"));
foreach (DataRow dr in dt.Rows)
{
pbSyncDownload.Increment(1);
db.Commands[0].Parameters.Clear();
db.Commands[0].Parameters.Add(new Parameter("@tableName", SqlDbType.VarChar, "NotaPenjualanDetail"));
db.Commands[0].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, Tools.isNull(dr["idrec"], "").ToString().Trim()));
db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 0));
db.Commands[0].ExecuteNonQuery();
this.refreshForm();
}
}
}
