void GetFromDataRow(DataRow dr) { try { _rowID = dr.Field <Guid>("RowID"); _noBukti = dr.Field <string>("NoBukti"); _tanggal = dr.Field <DateTime?>("Tanggal"); _perusahaanDariRowID = dr.Field <Guid>("PerusahaanDariRowID"); _perusahaanKeRowID = dr.Field <Guid>("PerusahaanKeRowID"); _cabangDariID = dr.Field <string>("CabangDariID"); _cabangKeID = dr.Field <string>("CabangKeID"); _tipeDKN = (Enums.enumTipeDKN) int.Parse(dr["TipeNota"].ToString()); _tipeHI = (Enums.enumTipeHI) int.Parse(dr["TipeHI"].ToString()); } catch (Exception ex) { string s = ex.Message; } }
public static string DKN00To11_new(DataTable tblHeader, UserObject userObject, bool gg) { int counter = 0; DataTable dtResult = new DataTable(); DataTable dtSdhDownload = tblHeader.Clone(); DataTable dt = new DataTable(); // int result = 0; string _dk = ""; object rslt = null; using (Database db = new Database()) { List <Parameter> prm = new List <Parameter>(); string _src, _cabId; int _tipeHI; db.BeginTransaction(); // HEADERS db.Commands.Add(db.CreateCommand("usp_HI00_Download")); db.Commands.Add(db.CreateCommand("[usp_DKN_Download_newDKN]")); bool _cabRowID = tblHeader.Columns.Contains("HRowID"); foreach (DataRow dr in tblHeader.Rows) { try { _src = Tools.isNull(dr["src"], "").ToString(); _tipeHI = (_src == "STR") ? 0 : 1; _cabId = Tools.isNull(dr["dari"], "").ToString().Trim(); if ((_cabId.Substring(0, 2) != userObject.CabangID) && (userObject.CabangID != "11")) { rslt = "Bukan HI Cabang anda."; } else { //add parameters _dk = (Tools.isNull(dr["dk"], "").ToString() == "D") ? "K" : "D"; prm.Clear(); prm.Add(new Parameter("@PerusahaanRowID", SqlDbType.UniqueIdentifier, userObject.SelectedPerusahaanRowID)); if (_cabRowID == true) { prm.Add(new Parameter("@HRowID", SqlDbType.UniqueIdentifier, new Guid(Tools.isNull(dr["HRowID"], Guid.Empty).ToString()))); } if (_cabRowID == true) { prm.Add(new Parameter("@DRowID", SqlDbType.UniqueIdentifier, new Guid(Tools.isNull(dr["DtRowID"], Guid.Empty).ToString()))); } prm.Add(new Parameter("@HRecordID", SqlDbType.VarChar, Tools.isNull(dr["idhead"], "").ToString())); prm.Add(new Parameter("@RecordID", SqlDbType.VarChar, Tools.isNull(dr["iddetail"], "").ToString())); prm.Add(new Parameter("@Tanggal", SqlDbType.DateTime, dr["tanggal"])); prm.Add(new Parameter("@NoDKN", SqlDbType.VarChar, Tools.isNull(dr["no_dkn"], "").ToString())); prm.Add(new Parameter("@TipeHI", SqlDbType.TinyInt, _tipeHI)); prm.Add(new Parameter("@DK", SqlDbType.VarChar, _dk)); prm.Add(new Parameter("@Cabang", SqlDbType.VarChar, Tools.isNull(dr["cabang"], "").ToString())); prm.Add(new Parameter("@CD", SqlDbType.VarChar, Tools.isNull(dr["cd"], "").ToString())); prm.Add(new Parameter("@Src", SqlDbType.VarChar, Tools.isNull(dr["src"], "").ToString())); prm.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, Tools.isNull(dr["no_perk"], "").ToString())); prm.Add(new Parameter("@Uraian", SqlDbType.VarChar, Tools.isNull(dr["uraian"], "").ToString())); prm.Add(new Parameter("@Jumlah", SqlDbType.Money, (dr["jumlah"]))); prm.Add(new Parameter("@Dari", SqlDbType.VarChar, _cabId)); prm.Add(new Parameter("@Tolak", SqlDbType.Bit, (dr["ltolak"]))); prm.Add(new Parameter("@Alasan", SqlDbType.VarChar, Tools.isNull(dr["alasan"], "").ToString())); prm.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, userObject.UserID)); db.Commands[0].Parameters = prm; rslt = db.Commands[0].ExecuteScalar(); if ((Tools.isNull(rslt, "").ToString() == "Ok") && (_tipeHI == 1)) { db.Commands[1].Parameters = prm; rslt = db.Commands[1].ExecuteScalar(); } if (Tools.isNull(rslt, "").ToString() == "Ok") { counter++; } else { rslt = rslt + "; NoDKN : " + Tools.isNull(dr["no_dkn"], "").ToString() + "; iddetail : " + Tools.isNull(dr["iddetail"], "").ToString(); break; } } } catch (Exception ex) { rslt = "Catch error : " + ex.Message + "; No.DKN : " + Tools.isNull(dr["no_dkn"], "").ToString() + "; iddetail : " + Tools.isNull(dr["iddetail"], "").ToString(); break; } } if (Tools.isNull(rslt, "").ToString() == "Ok") { db.CommitTransaction(); } else { db.RollbackTransaction(); } } return(Tools.isNull(rslt, "").ToString()); }