public void Insert2(Dictionary <string, object> dicList, string html, int menuID, string imgUri, string filename, string filePath)
{
if (NeedInsertDB)
{
string sql1 = string.Format("select * from dbo.SchoolStyle where dbo.SchoolStyle.Description ='{0}'", dicList["Title"]);
string error1 = "";
List <cm> cmList = DBManage.ExcuteEntity <cm>(sql1, System.Data.CommandType.Text, out error1);
if (cmList.Count < 1)
{
int modeType = 0;
if (dicList.ContainsKey("_x6a21__x7248_"))
{
if (dicList["_x6a21__x7248_"] != null)
{
modeType = 1;
}
}
Microsoft.SharePoint.Client.FieldUserValue vvv = dicList["Author"] as Microsoft.SharePoint.Client.FieldUserValue;
string creator = vvv.LookupValue;
html = html.Replace("'", "''");
string sql = string.Format("insert into SchoolStyle(MenuId,Title,[Description],CreateTime,ImageUrl,ClickNum,ModelType,IsDelete,Creator,FileName,FilePath) values({0},'{1}','{2}','{3}','{4}',{5},{6},{7},'{8}','{9}','{10}')",
menuID, dicList["Title"], html, dicList["Created"], imgUri, dicList["Count"], modeType, 0, creator, filename, filePath);
string error = "";
DBManage.Transaction(sql, out error);
}
}
}
public void InsertCmb(string _displayName)
{
string sql = string.Format("insert into [dbo].[PortalTreeData](Name,Display,IsDelete,CreateTime,Creator,PId,BeforeUrl,BeforeAfter,AfterUrl,SortId,EnName,DisplayCount,DisplayType ) values('{0}',0,0,getDate(),'',0,'/YQZJ/SitePages/BeforeItemList.aspx?',2,'/admin/AfterList.aspx?id=',0,'',8,'时间')", _displayName);
string error = "";
DBManage.Transaction(sql, out error);
}
public startForm(string locLoggedUser, string locLoggedRole)
{
InitializeComponent();
db = new HospitalContext();
dbm = new DBManage(db);
loggerUser = locLoggedUser;
loggerRole = locLoggedRole;
this.Text = "View DataBase --- " + loggerUser + " --- " + loggerRole;
if (loggerRole != "Admin")
{
patientAddBtn.Visible = false;
doctorAddBtn.Visible = false;
resultAddBtn.Visible = false;
EditPatient.Visible = false;
DeletePatient.Visible = false;
EditDoctor.Visible = false;
DeleteDoctor.Visible = false;
resultEdit.Visible = false;
resultDelete.Visible = false;
}
if (loggerRole == "Doctor")
{
resultAddBtn.Visible = true;
}
if (loggerRole == "Patient")
{
patientShowBtn.Visible = false;
//patiencesDataGridView.DataSource = null;
resultShowBtn.Visible = false;
//resultDataGridView.DataSource = null;
}
}
public SSLTracer(string StorePath)
{
StoragePath = FileStoragePath.GetPath_SSL();
SSLAnalyze = new SSLAnalyzer();
_CertificateManage = new CertificateManage();
SSLInformationList = new List <SSLInformation>();
DBManage.GetDBHandler(DBDataType.SSL, out DB_connection, out DB_cmd);
}
public startForm()
{
InitializeComponent();
db = new HospitalContext();
dbm = new DBManage(db);
loggerUser = "******";
loggerRole = "Patient";
}
//登录
private void btnLogin_Click(object sender, EventArgs e)
{
//【1】数据验证
if (this.txtLoginId.Text.Trim().Length == 0)
{
MessageBox.Show("请输入登录账号！", "登录提示");
this.txtLoginId.Focus();
return;
}
if (this.txtLoginPwd.Text.Trim().Length == 0)
{
MessageBox.Show("请输入登录密码！", "登录提示");
this.txtLoginPwd.Focus();
return;
}
//Messenger.Default.Send<User>(this.user, "LogSuccess"); //注意：token参数一致
try
{
string jsonText = File.ReadAllText("server.json");
JObject jo = (JObject)JsonConvert.DeserializeObject(jsonText);
#region 初始化服务器连接
DBManage.connectToServer(jo["DataBaseIP"].ToString(), "LabTest", jo["User"].ToString(), jo["Pwd"].ToString());
DBManage.connectToServerM(jo["DataBaseIP"].ToString(), "LabTest", jo["User"].ToString(), jo["Pwd"].ToString());
DBManage.GetProQueue();
bool k = DBManage.GetConnState();
#endregion
//Tuple<int, string> result = DBManage.LoginMethod(txtLoginId.Text.Trim(), txtLoginPwd.Text.Trim());
//string message = "";
//switch (result.Item1)
//{
// case 0: message = "登录成功!"; break;
// case 1: message = "账号不存在!"; break;
// case 2: message = "密码不正确!"; break;
// case 3: message = "用户已经离职或者已经到使用期限"; break;
// default:
// break;
//}
//MessageBox.Show(message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//if (result.Item1 == 0 || jo["Debug"].ToString() == "true")
//{
// this.DialogResult = DialogResult.OK;
// Program.objCurrentAdmin = JsonConvert.DeserializeObject<User>(result.Item2);
//}
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show("登录出错:" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public cm GetCm(string title)
{
cm cm = null;
string sql = string.Format("select * from PortalTreeData where PortalTreeData.Name ='{0}'", title);
string error = "";
List <cm> cmList = DBManage.ExcuteEntity <cm>(sql, System.Data.CommandType.Text, out error);
if (cmList.Count > 0)
{
cm = cmList[0];
}
return(cm);
}
//// POST: api/Users
//public void Post([FromBody]string value)
//{
//}
//// PUT: api/Users/5
//public void Put(int id, [FromBody]string value)
//{
//}
//// DELETE: api/Users/5
//public void Delete(int id)
//{
//}
private int Write2LogFile(DBManage MyDBManager, string Log_Text, int Log_Type)
{
SqlCommand Command = new SqlCommand();
Command.CommandText = "i_tefteri_sp_Log_File";
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Add("@What2Do", SqlDbType.VarChar, 20);
Command.Parameters.Add("@Log_File_Type", SqlDbType.TinyInt);
Command.Parameters.Add("@Log_File_Text", SqlDbType.NVarChar);
Command.Parameters["@What2Do"].Value = "Insert Into Log";
Command.Parameters["@Log_File_Type"].Value = Log_Type;
Command.Parameters["@Log_File_Text"].Value = Log_Text;
return(MyDBManager.ExecuteCommand(Command));
}
private DBManage db;// = new DBManage();
public Team2018Controller(Team2018Context context, IConfiguration configuration)
{
db = new DBManage(configuration);
_context = context;
if (_context.Teams.Count() == 0)
{
// Create a new TodoItem if collection is empty,
// which means you can't delete all TodoItems.
_context.Teams.Add(new Team2018 {
TeamId = 1847, Scale = true, Switch = true, Exchange = true, Comments = ""
});
_context.SaveChanges();
}
}
//// GET: api/Collection
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
// GET: api/Collection/5
public List <Collection> Get(int id)
{
DBManage MyDBManager = new DBManage();
SqlCommand Command = null;
SqlDataReader Reader = null;
List <Collection> User_Collection = new List <Collection>();
string SqlString = string.Empty;
int RecsAff = 0;
SqlString = "i_tefteri_sp_Get_Collection";
MyDBManager.CommandTimeOut = 30;
MyDBManager.ConStr = Constr();
try
{
MyDBManager.ConOpen();
Command = new SqlCommand();
Command.CommandText = SqlString;
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Add("@UserID", SqlDbType.Int);
Command.Parameters["@UserID"].Value = id;
Reader = MyDBManager.ExecuteReader(Command);
while (Reader.Read())
{
Collection MyCollection = new Collection();
MyCollection.PersonID = Reader["UserID"].ToString();
MyCollection.PersonName = Reader["iBankuserID"].ToString();
MyCollection.TransDate = Reader["HMEROMHNIA"].ToString();
MyCollection.ActualDate = Reader["HMEROMHNIA_EKT"].ToString();
String.Format(MyCollection.TransAmount = Reader["POSO"].ToString(), "#,##0.00");
MyCollection.DOSEIS = Reader["DOSEIS"].ToString();
MyCollection.TransactionID = Reader["TransactionID"].ToString();
User_Collection.Add(MyCollection);
MyCollection = null;
}
Reader.Close();
Reader = null;
Command = null;
Write2LogFile(MyDBManager, "Controller=Collection, " + "Get Users Collection", 1);
MyDBManager.ConClose();
MyDBManager = null;
return(User_Collection);
}
catch
{
return(User_Collection);
}
}
public int ProcessArchive()
{
countError = 0;
DBManage dbManage = new DBManage();
SqlConnection connection = dbManage.GetConnection();
try
{
//handle event sql info message
connection.InfoMessage += new SqlInfoMessageEventHandler(connection_InfoMessage);
SqlCommand command = connection.CreateCommand();
//get configuration number of day for move document , get value from DbParameter
command.CommandText = "SELECT ParameterValue FROM DBParameter WHERE ConfigurationName='NumberOfMonthForArchive'";
object numberOfMonth = command.ExecuteScalar();
if (numberOfMonth != null && !string.IsNullOrEmpty(numberOfMonth.ToString()) && int.Parse(numberOfMonth.ToString()) < 0)
{
// execute store procedure for move document
command.CommandType = System.Data.CommandType.StoredProcedure;
if (!string.IsNullOrEmpty(dbManage.ExecuteTimeout))
{
command.CommandTimeout = int.Parse(dbManage.ExecuteTimeout);
}
command.CommandText = "dbo.ArchiveDocumentTransaction";
command.Parameters.Add(new SqlParameter("expenseArchiveDBName", dbManage.ArchiveDatabaseName));
command.Parameters.Add(new SqlParameter("numOfMonth", numberOfMonth.ToString()));
command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Logger.Write(ex.Message);
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(countError);
}
private void btnForbidden_Click(object sender, EventArgs e)
{
int result = DBManage.StopProdNum(0, MainFrm.equipmentName, MainFrm.ProductType);
if (result == 0)
{
MessageBox.Show("禁用成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == 1)
{
MessageBox.Show("服务器禁用成功,本地禁用失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == 2)
{
MessageBox.Show("禁用失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnLoadDownParam_Click(object sender, EventArgs e)
{
Tuple <int, string> tup = DBManage.ALLParaDownJson(0, MainFrm.ProductType, MainFrm.equipmentName);
if (tup.Item1 == 0)
{
DealWithParam(tup.Item2);
MessageBox.Show("下载成功,从服务器下载", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (tup.Item1 == 1)
{
DealWithParam(tup.Item2);
MessageBox.Show("下载成功,从本地下载", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("下载失败!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataBaseForm(String usr)
{
InitializeComponent();
context = new F1GrandPrixContext();
dbm = new DBManage(context);
loggedUser = usr;
loggedUsernameLbl.Text = usr;
List <int> seasons = new List <int>();
foreach (var item in context.tournaments)
{
if (!seasons.Contains(item.season))
{
seasons.Add(item.season);
}
}
seasonComboBox.DataSource = seasons;
seasonYear = Convert.ToInt32(seasonComboBox.SelectedItem);
}
public void Insert(Dictionary <string, object> dicList, string html, int menuID, string imgUri, string filename, string filePath)
{
if (NeedInsertDB)
{
int modeType = 0;
if (dicList.ContainsKey("_x6a21__x7248_"))
{
if (dicList["_x6a21__x7248_"] != null)
{
modeType = 1;
}
}
Microsoft.SharePoint.Client.FieldUserValue vvv = dicList["Author"] as Microsoft.SharePoint.Client.FieldUserValue;
string creator = vvv.LookupValue;
html = html.Replace("'", "''");
string sql = string.Format("insert into Advertising(MenuId,[Description], CreativeHTML,CreateTime,ImageUrl,ClickNum,ModelType,IsDelete,Creator,FileName,FilePath,isPush) values({0},'{1}','{2}','{3}','{4}',{5},{6},{7},'{8}','{9}','{10}',{11})",
menuID, dicList["Title"], html, dicList["Created"], imgUri, dicList["Count"], modeType, 0, creator, filename, filePath, 1);
string error = "";
DBManage.Transaction(sql, out error);
}
}
//// GET: api/Users
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
// GET: api/Users/5
public List <Person> Get(int id)
{
System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers;
DBManage MyDBManager = new DBManage();
SqlCommand Command = null;
SqlDataReader Reader = null;
List <Person> Person = new List <Person>();
string SqlString = string.Empty;
int RecsAff = 0;
SqlString = "i_tefteri_sp_Get_Active_Users";
MyDBManager.CommandTimeOut = 30;
MyDBManager.ConStr = Constr();
if (id == -1)
{
try
{
if (headers.Contains("Currentuser"))
{
string user = headers.GetValues("Currentuser").First();
}
MyDBManager.ConOpen();
Command = new SqlCommand();
Command.CommandText = SqlString;
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Add("@What2Do", SqlDbType.VarChar, 50);
//Command.Parameters.Add("@Mobile_Num", SqlDbType.VarChar, 12);
Command.Parameters["@What2Do"].Value = "All Person";
//Command.Parameters["@Mobile_Num"].Value = id;
Reader = MyDBManager.ExecuteReader(Command);
while (Reader.Read())
{
Person MyPerson = new Person();
MyPerson.UserID = Convert.ToInt32(Reader["UserID"]);
MyPerson.iBankuserID = Reader["iBankuserID"].ToString();
MyPerson.BASIKOS_LOGAR = Reader["BASIKOS_LOGAR"].ToString();
Person.Add(MyPerson);
MyPerson = null;
}
Reader.Close();
Reader = null;
Command = null;
Write2LogFile(MyDBManager, "Controller=Users, " + "Get ALL Active Users", 1);
MyDBManager.ConClose();
MyDBManager = null;
//var jsonSerialiser = new JavaScriptSerializer();
//var json = jsonSerialiser.Serialize(Person);
return(Person);//JsonConvert.SerializeObject(Person);
}
catch (Exception ex)
{
Person MyPerson = new Person();
RecsAff = Write2LogFile(MyDBManager, "Controller=Users, " + "Error: " + ex.Message, 1);
MyDBManager.ConClose();
MyDBManager = null;
MyPerson.iBankuserID = "Error";
Person.Add(MyPerson);
return(Person);
}
}
else
{
try
{
string Currentuser = string.Empty;
if (headers.Contains("Currentuser"))
{
Currentuser = headers.GetValues("Currentuser").First();
}
MyDBManager.ConOpen();
Command = new SqlCommand();
Command.CommandText = SqlString;
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Add("@What2Do", SqlDbType.VarChar, 50);
//Command.Parameters.Add("@Mobile_Num", SqlDbType.VarChar, 12);
Command.Parameters["@What2Do"].Value = Currentuser;
//Command.Parameters["@Mobile_Num"].Value = id;
Reader = MyDBManager.ExecuteReader(Command);
while (Reader.Read())
{
Person MyPerson = new Person();
MyPerson.UserID = Convert.ToInt32(Reader["UserID"]);
MyPerson.iBankuserID = Reader["iBankuserID"].ToString();
MyPerson.BASIKOS_LOGAR = Reader["BASIKOS_LOGAR"].ToString();
Person.Add(MyPerson);
MyPerson = null;
}
Reader.Close();
Reader = null;
Command = null;
Write2LogFile(MyDBManager, "Controller=Users, " + "Get 1 Active Users", 1);
MyDBManager.ConClose();
MyDBManager = null;
//var jsonSerialiser = new JavaScriptSerializer();
//var json = jsonSerialiser.Serialize(Person);
return(Person);//JsonConvert.SerializeObject(Person);
}
catch (Exception ex)
{
Person MyPerson = new Person();
RecsAff = Write2LogFile(MyDBManager, "Controller=Users, " + "Error: " + ex.Message, 1);
MyDBManager.ConClose();
MyDBManager = null;
MyPerson.iBankuserID = "Error";
Person.Add(MyPerson);
return(Person);
}
}
}
public override void CreatePostData(long DocID, string DocKind)
{
Hashtable paramete = new Hashtable();
paramete.Add("@DOCUMENT_ID", DocID.ToString());
DataSet dstPosting = new DBManage().ExecuteQuery("ADVANCE_POSTING", paramete);
if (dstPosting.Tables[0].Rows.Count > 0)
{
if (dstPosting.Tables[0].Rows[0]["AdvanceType"].ToString() == ZoneTypeConst.Domestic)
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
che09.DocType = DocTypeConst.KR;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
if (dstPosting.Tables[0].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
che09.DocAppFlag = "A";
}
else
{
che09.DocAppFlag = "V";
}
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "AdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
#region Domestic
Bapiacap09 capItem1 = new Bapiacap09();
Bapiacap09 capItem2 = new Bapiacap09();
Bapiaccr09 accrItem1 = new Bapiaccr09();
Bapiaccr09 accrItem2 = new Bapiaccr09();
if (dstPosting.Tables[0].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
#region Cash
#region Credit
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = dstPosting.Tables[0].Rows[0]["PBCode"].ToString();
capItem1.PmntBlock = PostingConst.PmntBlock;
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString())).EmployeeName;
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "AdvancePosting";
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "AdvancePosting";
#endregion Credit
#region Debit
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).EmployeeID;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = PostingConst.PmntBlock;
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.E;
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "AdvancePosting";
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "AdvancePosting";
#endregion Debit
#endregion Cash
}
else
{
#region Transfer หรือ Cheque
#region Credit
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString())).EmployeeID;
capItem1.PmntBlock = "";
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "AdvancePosting";
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "AdvancePosting";
#endregion Credit
#region Debit
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).EmployeeID;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = "";
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.E;
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "AdvancePosting";
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "AdvancePosting";
#endregion Debit
#endregion Transfer หรือ Cheque
}
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Domestic
}
else if (dstPosting.Tables[0].Rows[0]["AdvanceType"].ToString() == ZoneTypeConst.Foreign)
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
che09.DocType = DocTypeConst.KZ;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
che09.DocAppFlag = "A";
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "AdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
#region Foreign
Bapiacgl09 capItem1 = new Bapiacgl09();
Bapiacap09 capItem2 = new Bapiacap09();
Bapiaccr09 accrItem1 = new Bapiaccr09();
Bapiaccr09 accrItem2 = new Bapiaccr09();
#region Credit
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.GlAccount = dstPosting.Tables[0].Rows[0]["BankAccount"].ToString();
capItem1.ValueDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
//capItem1.BusArea = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "AdvancePosting";
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "AdvancePosting";
#endregion Credit
#region Debit
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).EmployeeID;
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.E;
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "AdvancePosting";
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "AdvancePosting";
#endregion Debit
BapiServiceProvider.Bapiacgl09Service.Save(capItem1);
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Foreign
}
}
}
public override void CreatePostData(long DocID, string DocKind)
{
Hashtable paramete = new Hashtable();
paramete.Add("@DOCUMENT_ID", DocID.ToString());
DataSet dstPosting = new DBManage().ExecuteQuery("FIXEDADVANCE_POSTING", paramete);
SCGDocument doc = SCG.eAccounting.Query.ScgeAccountingQueryProvider.SCGDocumentQuery.FindProxyByIdentity(DocID);
DbSapInstance sap = SCG.DB.Query.ScgDbQueryProvider.DbCompanyQuery.GetSAPDocTypeForPosting(doc.CompanyID.CompanyCode);
if (dstPosting.Tables[0].Rows.Count > 0)
{
#region Domestic
if (dstPosting.Tables[0].Rows[0]["FixedAdvanceType"].ToString() == "1")
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = sap.UserCPIC; //PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
/*N-edit*/
//che09.DocType = sap.DocTypeAdvancePostingDM;//DocTypeConst.KR;
che09.DocType = sap.DocTypeFixedAdvancePosting;//DocTypeConst.KR;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
if (dstPosting.Tables[0].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
che09.DocAppFlag = "A";
}
else
{
che09.DocAppFlag = "V";
}
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
#region Transfer หรือ Cheque
#region Credit
Bapiacap09 capItem1 = new Bapiacap09();
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem1.PmntBlock = PostingConst.PmntBlock;
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
//capItem1.AllocNmbr = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString())).EmployeeName;
//capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "FixedAdvancePosting";
capItem1.Pmtmthsupl = doc.Supplementary; //dstPosting.Tables[0].Rows[0]["Supplementary"].ToString();
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
Bapiaccr09 accrItem1 = new Bapiaccr09();
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
#endregion Credit
#region Debit
Bapiacap09 capItem2 = new Bapiacap09();
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
//capItem2.GlAccount = SAPUIHelper.GetFixedPostingAccountDr(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString()));
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = "";
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.H;
capItem2.Pmtmthsupl = doc.Supplementary; //dstPosting.Tables[0].Rows[0]["Supplementary"].ToString();
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
Bapiaccr09 accrItem2 = new Bapiaccr09();
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Debit
#endregion Transfer หรือ Cheque
}
else
{
if (decimal.Parse(dstPosting.Tables[0].Rows[0]["NetAmount"].ToString()) > 0)
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = sap.UserCPIC; //PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
/*N-edit*/
//che09.DocType = sap.DocTypeAdvancePostingDM;//DocTypeConst.KR;
che09.DocType = sap.DocTypeFixedAdvancePosting;//DocTypeConst.KR;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
if (dstPosting.Tables[0].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
che09.DocAppFlag = "A";
}
else
{
che09.DocAppFlag = "V";
}
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
if (dstPosting.Tables[0].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
#region Cash
#region Credit
Bapiacap09 capItem1 = new Bapiacap09();
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = dstPosting.Tables[0].Rows[0]["PBCode"].ToString();
capItem1.PmntBlock = PostingConst.PmntBlock;
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = SAPUIHelper.GetFixedPostingAccountAdjustCr(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString()));
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.Pmtmthsupl = doc.Supplementary; //dstPosting.Tables[0].Rows[0]["Supplementary"].ToString();
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
Bapiaccr09 accrItem1 = new Bapiaccr09();
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - (decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString()) - decimal.Parse(dstPosting.Tables[0].Rows[0]["NetAmount"].ToString()));
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
#endregion Credit
#region Debit
Bapiacap09 capItem2 = new Bapiacap09();
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
//capItem2.GlAccount = SAPUIHelper.GetFixedPostingAccountAdjustDr(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString()));
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = PostingConst.PmntBlock;
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.H;
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "FixedAdvancePosting";
capItem2.Pmtmthsupl = doc.Supplementary; //dstPosting.Tables[0].Rows[0]["Supplementary"].ToString();
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
Bapiaccr09 accrItem2 = new Bapiaccr09();
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Debit
#region CreditDifferentAmount
Bapiacap09 capItem3 = new Bapiacap09();
capItem3.DocId = DocID;
capItem3.DocSeq = "M";
capItem3.DocKind = DocKind;
capItem3.ItemnoAcc = "3";
capItem3.VendorNo = dstPosting.Tables[0].Rows[0]["PBCode"].ToString();
capItem3.PmntBlock = PostingConst.PmntBlock;
capItem3.Pmnttrms = PostingConst.Pmnttrms;
capItem3.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem3.AllocNmbr = SAPUIHelper.GetFixedPostingAccountCr(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString()));
capItem3.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem3.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem3.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem3.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem3.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem3.TaxCode = TaxCodeConst.NV;
capItem3.Active = true;
capItem3.CreBy = 1;
capItem3.CreDate = DateTime.Now;
capItem3.UpdBy = 1;
capItem3.UpdDate = DateTime.Now;
capItem3.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem3);
Bapiaccr09 accrItem3 = new Bapiaccr09();
accrItem3.DocId = DocID;
accrItem3.DocSeq = "M";
accrItem3.DocKind = DocKind;
accrItem3.ItemnoAcc = "3";
accrItem3.Currency = PostingConst.Currency;
accrItem3.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["NetAmount"].ToString());
accrItem3.Active = true;
accrItem3.CreBy = 1;
accrItem3.CreDate = DateTime.Now;
accrItem3.UpdBy = 1;
accrItem3.UpdDate = DateTime.Now;
accrItem3.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem3);
#endregion CreditDifferrent
#endregion Cash
}
else
{
#region Transfer หรือ Cheque
#region Credit
Bapiacap09 capItem1 = new Bapiacap09();
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem1.PmntBlock = "";
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
//FixedAdvanceDocument favDb = ScgeAccountingQueryProvider.FixedAdvanceDocumentQuery.GetFixedAdvanceByDocumentID(DocID);
//FixedAdvanceDocument fixAd = ScgeAccountingQueryProvider.FixedAdvanceDocumentQuery.GetFixedAdvanceByFixedAdvanceID((long)favDb.RefFixedAdvanceID);
//SCGDocument scgDoc = ScgeAccountingQueryProvider.SCGDocumentQuery.GetSCGDocumentByDocumentID(fixAd.DocumentID.DocumentID);
//capItem1.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
//capItem1.AllocNmbr = scgDoc.DocumentNo;
//capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[0]["RefFixedAdvanceID"].ToString();
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.SpGlInd = SpGlIndConst.H;
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
Bapiaccr09 accrItem1 = new Bapiaccr09();
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - (decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString()) - decimal.Parse(dstPosting.Tables[0].Rows[0]["NetAmount"].ToString()));
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
#endregion Credit
#region Debit
Bapiacap09 capItem2 = new Bapiacap09();
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = "";
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
//capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.H;
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
Bapiaccr09 accrItem2 = new Bapiaccr09();
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Debit
#region CreditDifferrent
Bapiacap09 capItem3 = new Bapiacap09();
capItem3.DocId = DocID;
capItem3.DocSeq = "M";
capItem3.DocKind = DocKind;
capItem3.ItemnoAcc = "3";
capItem3.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem3.PmntBlock = "";
capItem3.Pmnttrms = PostingConst.Pmnttrms;
capItem3.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem3.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem3.AllocNmbr = SAPUIHelper.SubString18(capItem3.AllocNmbr);
capItem3.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem3.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem3.ItemText = SAPUIHelper.SubString50(capItem3.ItemText);
capItem3.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem3.TaxCode = TaxCodeConst.NV;
//capItem3.SpGlInd = SpGlIndConst.H;
capItem3.Active = true;
capItem3.CreBy = 1;
capItem3.CreDate = DateTime.Now;
capItem3.UpdBy = 1;
capItem3.UpdDate = DateTime.Now;
capItem3.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem3);
Bapiaccr09 accrItem3 = new Bapiaccr09();
accrItem3.DocId = DocID;
accrItem3.DocSeq = "M";
accrItem3.DocKind = DocKind;
accrItem3.ItemnoAcc = "3";
accrItem3.Currency = PostingConst.Currency;
accrItem3.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["NetAmount"].ToString());
accrItem3.Active = true;
accrItem3.CreBy = 1;
accrItem3.CreDate = DateTime.Now;
accrItem3.UpdBy = 1;
accrItem3.UpdDate = DateTime.Now;
accrItem3.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem3);
#endregion CreditDifferrent
#endregion Transfer หรือ Cheque
}
}
else
{
/*PayBack Company*/
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = sap.UserCPIC; //PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
/*N-edit*/
//che09.DocType = sap.DocTypeAdvancePostingDM;//DocTypeConst.KR;
che09.DocType = sap.DocTypeFixedAdvanceReturnPosting;//DocTypeConst.KR;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
if (dstPosting.Tables[0].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
che09.DocAppFlag = "A";
}
else
{
che09.DocAppFlag = "V";
}
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
#region Cash Or Tranfer
#region Credit
Bapiacap09 capItem1 = new Bapiacap09();
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem1.PmntBlock = PostingConst.PmntBlock;
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
//capItem1.AllocNmbr = SAPUIHelper.GetFixedPostingAccountAdjustCr(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString()));
//capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
/*N-Edited Ref FixedAdvanceID*/
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[0]["RefFixedAdvanceID"].ToString();
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.SpGlInd = SpGlIndConst.H;
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
Bapiaccr09 accrItem1 = new Bapiaccr09();
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - (decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString()) + (-1 * decimal.Parse(dstPosting.Tables[0].Rows[0]["NetAmount"].ToString())));
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
#endregion Credit
#region Debit
Bapiacap09 capItem2 = new Bapiacap09();
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
//capItem2.GlAccount = SAPUIHelper.GetFixedPostingAccountAdjustDr(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString()));
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = PostingConst.PmntBlock;
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.H;
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
Bapiaccr09 accrItem2 = new Bapiaccr09();
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Debit
#region DebitDifferentAmount
Bapiacgl09 cglItem2 = new Bapiacgl09();
cglItem2.DocId = DocID;
cglItem2.DocSeq = "M";
cglItem2.DocKind = DocKind;
cglItem2.ItemnoAcc = "3";
cglItem2.GlAccount = dstPosting.Tables[0].Rows[0]["BankAccount"].ToString();
cglItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
cglItem2.AllocNmbr = SAPUIHelper.SubString18(cglItem2.AllocNmbr);
cglItem2.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
cglItem2.ItemText = SAPUIHelper.SubString50(cglItem2.ItemText);
cglItem2.Active = true;
cglItem2.CreBy = 1;
cglItem2.CreDate = DateTime.Now;
cglItem2.UpdBy = 1;
cglItem2.UpdDate = DateTime.Now;
cglItem2.UpdPgm = "FixedAdvancePosting";
/*N-edited valuedate = requestdate*/
cglItem2.ValueDate = dstPosting.Tables[0].Rows[0]["RequestDate"].ToString(); /*DateFormat = YYYYMMDD*/
BapiServiceProvider.Bapiacgl09Service.Save(cglItem2);
Bapiaccr09 accrItem3 = new Bapiaccr09();
accrItem3.DocId = DocID;
accrItem3.DocSeq = "M";
accrItem3.DocKind = DocKind;
accrItem3.ItemnoAcc = "3";
accrItem3.Currency = PostingConst.Currency;
accrItem3.AmtDoccur = (-1 * decimal.Parse(dstPosting.Tables[0].Rows[0]["NetAmount"].ToString()));
accrItem3.Active = true;
accrItem3.CreBy = 1;
accrItem3.CreDate = DateTime.Now;
accrItem3.UpdBy = 1;
accrItem3.UpdDate = DateTime.Now;
accrItem3.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem3);
#endregion DebitDifferentAmount
#endregion Cash Or Tranfer
}
}
#endregion Domestic
}
}
private void reloadData()
{
db = new HospitalContext();
dbm = new DBManage(db);
}
public override void CreatePostData(long DocID, string DocKind)
{
Hashtable paramete = new Hashtable();
paramete.Add("@DOCUMENT_ID", DocID.ToString());
DataSet dstPosting = new DBManage().ExecuteQuery("REMITANCE_POSTING", paramete);
if (dstPosting.Tables[0].Rows.Count >= 1)
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.DocStatus = "N";
che09.BusAct = PostingConst.BusAct;
che09.Username = PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["CompanyCode"].ToString();
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocType = DocTypeConst.SV;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "RemetancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "RemetancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
#region คู่บัญชี
int intSeq = 0;
for (int i = 0; i < dstPosting.Tables[0].Rows.Count; i++)
{
#region Credit
intSeq++;
Bapiacap09 capItem1 = new Bapiacap09();
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = intSeq.ToString();
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[i]["RequesterID"].ToString())).EmployeeID;
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[i]["AdvanceNo"].ToString();
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.ItemText = dstPosting.Tables[0].Rows[i]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[i]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.SpGlInd = SpGlIndConst.E;
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
Bapiaccr09 accrItem1 = new Bapiaccr09();
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = intSeq.ToString();
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[i]["RemittanceAmount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
#endregion Credit
#region Debit
intSeq++;
Bapiacgl09 cglItem2 = new Bapiacgl09();
cglItem2.DocId = DocID;
cglItem2.DocSeq = "M";
cglItem2.DocKind = DocKind;
cglItem2.ItemnoAcc = intSeq.ToString();
cglItem2.GlAccount = PostingConst.GLAccount;
cglItem2.AllocNmbr = dstPosting.Tables[0].Rows[i]["AdvanceNo"].ToString();
cglItem2.AllocNmbr = SAPUIHelper.SubString18(cglItem2.AllocNmbr);
cglItem2.ItemText = dstPosting.Tables[0].Rows[i]["Description"].ToString();
cglItem2.ItemText = SAPUIHelper.SubString50(cglItem2.ItemText);
//cglItem2.BusArea = dstPosting.Tables[0].Rows[i]["BranchCode"].ToString();
cglItem2.Active = true;
cglItem2.CreBy = 1;
cglItem2.CreDate = DateTime.Now;
cglItem2.UpdBy = 1;
cglItem2.UpdDate = DateTime.Now;
cglItem2.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiacgl09Service.Save(cglItem2);
Bapiaccr09 accrItem2 = new Bapiaccr09();
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = intSeq.ToString();
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[i]["RemittanceAmount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Debit
}
#endregion คู่บัญชี
}
}
public override void CreatePostData(long DocID, string DocKind)
{
Hashtable paramete = new Hashtable();
paramete.Add("@DOCUMENT_ID", DocID.ToString());
DataSet dstPosting = new DBManage().ExecuteQuery("ADVANCE_POSTING", paramete);
bool repOffice = false;
string mainCurrencySymbol = string.Empty;
SCGDocument doc = SCG.eAccounting.Query.ScgeAccountingQueryProvider.SCGDocumentQuery.FindProxyByIdentity(DocID);
DbSapInstance sap = SCG.DB.Query.ScgDbQueryProvider.DbCompanyQuery.GetSAPDocTypeForPosting(doc.CompanyID.CompanyCode);
if (dstPosting.Tables[0].Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dstPosting.Tables[0].Rows[0]["IsRepOffice"].ToString()))
{
repOffice = bool.Parse(dstPosting.Tables[0].Rows[0]["IsRepOffice"].ToString());
}
// get main currency symbol
if (repOffice)
{
DbCurrency mainCurrency = SS.DB.Query.SsDbQueryProvider.DbCurrencyQuery.FindByIdentity(short.Parse(dstPosting.Tables[0].Rows[0]["MainCurrencyID"].ToString()));
if (mainCurrency != null)
{
mainCurrencySymbol = mainCurrency.Symbol;
}
}
if (dstPosting.Tables[0].Rows[0]["AdvanceType"].ToString() == ZoneTypeConst.Domestic)
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = sap.UserCPIC; //PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
che09.DocType = sap.DocTypeAdvancePostingDM;//DocTypeConst.KR;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
if (dstPosting.Tables[0].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
che09.DocAppFlag = "A";
}
else
{
che09.DocAppFlag = "V";
}
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "AdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
#region Domestic
Bapiacap09 capItem1 = new Bapiacap09();
Bapiacap09 capItem2 = new Bapiacap09();
Bapiaccr09 accrItem1 = new Bapiaccr09();
Bapiaccr09 accrItem2 = new Bapiaccr09();
if (!repOffice)
{
if (dstPosting.Tables[0].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
#region Cash
#region Credit
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = dstPosting.Tables[0].Rows[0]["PBCode"].ToString();
capItem1.PmntBlock = PostingConst.PmntBlock;
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString())).EmployeeName;
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem1.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "AdvancePosting";
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "AdvancePosting";
#endregion Credit
#region Debit
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = PostingConst.PmntBlock;
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.D;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem2.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "AdvancePosting";
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "AdvancePosting";
#endregion Debit
#endregion Cash
}
else
{
#region Transfer หรือ Cheque
#region Credit
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString())).VendorCode;
capItem1.PmntBlock = "";
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem1.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem1.Pmtmthsupl = dstPosting.Tables[0].Rows[0]["Supplementary"].ToString();
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "AdvancePosting";
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "AdvancePosting";
#endregion Credit
#region Debit
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = "";
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.D;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem2.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem2.Pmtmthsupl = dstPosting.Tables[0].Rows[0]["Supplementary"].ToString();
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "AdvancePosting";
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "AdvancePosting";
#endregion Debit
#endregion Transfer หรือ Cheque
}
}
else //for rep office
{
#region Credit
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = dstPosting.Tables[0].Rows[0]["PBCode"].ToString();
capItem1.PmntBlock = PostingConst.PmntBlock;
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString())).EmployeeName;
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem1.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "AdvancePosting";
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = mainCurrencySymbol;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["MainCurrencyAmount"].ToString());
accrItem1.ExchRate = decimal.Parse(dstPosting.Tables[0].Rows[0]["ExchangeRateMainToTHB"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "AdvancePosting";
#endregion Credit
#region Debit
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.PymtMeth = dstPosting.Tables[0].Rows[0]["PaymentMethod"].ToString();
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = PostingConst.PmntBlock;
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.D;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem2.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "AdvancePosting";
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = mainCurrencySymbol;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["MainCurrencyAmount"].ToString());
accrItem2.ExchRate = decimal.Parse(dstPosting.Tables[0].Rows[0]["ExchangeRateMainToTHB"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "AdvancePosting";
#endregion Debit
}
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Domestic
}
else if (dstPosting.Tables[0].Rows[0]["AdvanceType"].ToString() == ZoneTypeConst.Foreign)
{
#region Foreign
if (!repOffice)
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = sap.UserCPIC;//PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
che09.DocType = sap.DocTypeAdvancePostingFR;//DocTypeConst.KZ;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
che09.DocAppFlag = "A";
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "AdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
Bapiacgl09 capItem1 = new Bapiacgl09();
Bapiacap09 capItem2 = new Bapiacap09();
Bapiaccr09 accrItem1 = new Bapiaccr09();
Bapiaccr09 accrItem2 = new Bapiaccr09();
#region Credit
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.GlAccount = dstPosting.Tables[0].Rows[0]["BankAccount"].ToString();
capItem1.ValueDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
//capItem1.BusArea = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem1.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "AdvancePosting";
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "AdvancePosting";
#endregion Credit
#region Debit
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.D;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem2.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "AdvancePosting";
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["Amount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "AdvancePosting";
#endregion Debit
BapiServiceProvider.Bapiacgl09Service.Save(capItem1);
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
}
else // post ADF for rep office
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = sap.UserCPIC;//PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
che09.DocType = sap.DocTypeAdvancePostingFR;//DocTypeConst.KR;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
che09.DocAppFlag = "A";
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "AdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "AdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
Bapiacap09 capItem1 = new Bapiacap09();
Bapiacap09 capItem2 = new Bapiacap09();
Bapiaccr09 accrItem1 = new Bapiaccr09();
Bapiaccr09 accrItem2 = new Bapiaccr09();
#region Credit
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
capItem1.VendorNo = dstPosting.Tables[0].Rows[0]["PBCode"].ToString();
capItem1.PmntBlock = PostingConst.PmntBlock;
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem1.AllocNmbr = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["ReceiverID"].ToString())).EmployeeName;
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.ItemText = dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem1.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "AdvancePosting";
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = mainCurrencySymbol;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[0]["MainCurrencyAmount"].ToString());
accrItem1.ExchRate = decimal.Parse(dstPosting.Tables[0].Rows[0]["ExchangeRateMainToTHB"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "AdvancePosting";
#endregion Credit
#region Debit
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = "2";
capItem2.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.BlineDate = dstPosting.Tables[0].Rows[0]["BaseLineDate"].ToString();
capItem2.PmntBlock = PostingConst.PmntBlock;
capItem2.AllocNmbr = dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString();
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem2.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[0]["DueDate"].ToString() + "/" + dstPosting.Tables[0].Rows[0]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem2.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
capItem2.SpGlInd = SpGlIndConst.D;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem2.BusArea = dstPosting.Tables[0].Rows[0]["BusinessArea"].ToString();
}
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "AdvancePosting";
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = mainCurrencySymbol;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[0]["MainCurrencyAmount"].ToString());
accrItem2.ExchRate = decimal.Parse(dstPosting.Tables[0].Rows[0]["ExchangeRateMainToTHB"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "AdvancePosting";
#endregion Debit
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
}
#endregion Foreign
}
}
}
private void timer1_Tick(object sender, EventArgs e)
{
try
{
for (int i = 0; i < ManulDataBtnFeedBack.Count; i++)
{
userButtons[i].OriginalColor = ManulDataBtnFeedBack[i] ? Color.LawnGreen : Color.FromArgb(89, 169, 254);
}
for (int i = 0; i < uCValves.Count; i++)
{
uCValves[i].SwitchColor = ManulDataBtnFeedBack[i] ? Color.LawnGreen : Color.FromArgb(232, 30, 99);
uCValves[i].LiquidDirection = ManulDataBtnFeedBack[i] ? LiquidDirection.Forward : LiquidDirection.None;
}
btnChangeMode.UIText = homeData.Mode ? "自动模式" : "手动模式";
userButton18.UIText = homeData.Mode ? "自动模式" : "手动模式";
btnChangeMode.EnableColor = homeData.Mode ? Color.GreenYellow : Color.Gray;
lbIsReady.Text = homeData.IsReady ? "准备就绪":"未准备好";
ucBlower1.BlowerColor = homeData.IsPumpRun ? Color.LimeGreen : Color.FromArgb(255, 77, 59);
if (homeData.EStop)
{
if (DateTime.Now.Second % 3 == 0)
{
btnEstop.OriginalColor = Color.Yellow;
}
else
{
btnEstop.OriginalColor = Color.Red;
}
}
string conn = IsConnected ? "成功" : "失败";
toolPLCConnect.Text = $"PLC连接状态: {conn}";
//判断服务器连接信息
if (DateTime.Now.Second % 2 == 0)
{
try
{
Task.Run(() => IsNetConnected = DBManage.GetConnState());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
toolServiceStatus.Text = IsNetConnected ? "服务器连接状态: 成功" : "服务器连接状态: 失败";
#region 位置、压力
txtPosition1.Text = (homeData.CurrentPos1 / 100.0f).ToString();
txtPosition2.Text = (homeData.CurrentPos2 / 100.0f).ToString();
txtWashPress.Text = homeData.WashPress.ToString();
txtHomePos1.Text = (homeData.CurrentPos1 / 100.0f).ToString();
txtHomePos2.Text = (homeData.CurrentPos2 / 100.0f).ToString();
txtHomeWashPress.Text = homeData.WashPress.ToString();
#endregion
#region 序号 时间
txtWashSetTime.Text = txtSetTime.Text = homeData.WashSetTime.ToString();
txtAlreadyTime.Text = homeData.alreadyTime.ToString();
txtWashNum.Text = homeData.WashStep.ToString();
#endregion
lbEquipmentStatus.Text = homeData.EquipState;
ucAlarmLamp1.LampColor[0] = equipMentState[homeData.EquipState];
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
DataTable dt = DBManage.QueryProdNum(0, MainFrm.equipmentName, this.txtProductName.Text.Trim());
this.listBox1.DataSource = dt.AsEnumerable().Select(x => x.Field <string>("ProductType")).ToList();
}
public override void CreatePostData(long DocID, string DocKind)
{
Hashtable paramete = new Hashtable();
paramete.Add("@DOCUMENT_ID", DocID.ToString());
DataSet dstPosting = new DBManage().ExecuteQuery("REMITANCE_POSTING", paramete);
bool repOffice = false;
string mainCurrencySymbol = string.Empty;
SCGDocument doc = SCG.eAccounting.Query.ScgeAccountingQueryProvider.SCGDocumentQuery.FindProxyByIdentity(DocID);
DbSapInstance sap = SCG.DB.Query.ScgDbQueryProvider.DbCompanyQuery.GetSAPDocTypeForPosting(doc.CompanyID.CompanyCode);
if (dstPosting.Tables[0].Rows.Count >= 1)
{
if (!string.IsNullOrEmpty(dstPosting.Tables[0].Rows[0]["IsRepOffice"].ToString()))
{
repOffice = bool.Parse(dstPosting.Tables[0].Rows[0]["IsRepOffice"].ToString());
}
// get main currency symbol
if (repOffice)
{
DbCurrency mainCurrency = SS.DB.Query.SsDbQueryProvider.DbCurrencyQuery.FindByIdentity(short.Parse(dstPosting.Tables[0].Rows[0]["MainCurrencyID"].ToString()));
if (mainCurrency != null)
{
mainCurrencySymbol = mainCurrency.Symbol;
}
}
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.DocStatus = "N";
che09.BusAct = PostingConst.BusAct;
che09.Username = sap.UserCPIC;//PostingConst.UserCPIC;
che09.CompCode = dstPosting.Tables[0].Rows[0]["CompanyCode"].ToString();
che09.DocDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.DocType = sap.DocTypeRmtPosting;//DocTypeConst.SV;
che09.PstngDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[0].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[0].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "RemetancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "RemetancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
#region คู่บัญชี
int intSeq = 0;
for (int i = 0; i < dstPosting.Tables[0].Rows.Count; i++)
{
if (!repOffice)
{
#region Credit
intSeq++;
Bapiacap09 capItem1 = new Bapiacap09();
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = intSeq.ToString();
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[i]["RequesterID"].ToString())).VendorCode;
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[i]["AdvanceNo"].ToString();
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.ItemText = dstPosting.Tables[0].Rows[i]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[i]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.SpGlInd = SpGlIndConst.D;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem1.BusArea = dstPosting.Tables[0].Rows[i]["BusinessArea"].ToString();
}
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
Bapiaccr09 accrItem1 = new Bapiaccr09();
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = intSeq.ToString();
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[i]["RemittanceAmount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
#endregion Credit
#region Debit
intSeq++;
Bapiacgl09 cglItem2 = new Bapiacgl09();
cglItem2.DocId = DocID;
cglItem2.DocSeq = "M";
cglItem2.DocKind = DocKind;
cglItem2.ItemnoAcc = intSeq.ToString();
cglItem2.GlAccount = PostingConst.GLAccount;
cglItem2.AllocNmbr = dstPosting.Tables[0].Rows[i]["AdvanceNo"].ToString();
cglItem2.AllocNmbr = SAPUIHelper.SubString18(cglItem2.AllocNmbr);
cglItem2.ItemText = dstPosting.Tables[0].Rows[i]["Description"].ToString();
cglItem2.ItemText = SAPUIHelper.SubString50(cglItem2.ItemText);
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
cglItem2.BusArea = dstPosting.Tables[0].Rows[i]["BusinessArea"].ToString();
}
cglItem2.Active = true;
cglItem2.CreBy = 1;
cglItem2.CreDate = DateTime.Now;
cglItem2.UpdBy = 1;
cglItem2.UpdDate = DateTime.Now;
cglItem2.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiacgl09Service.Save(cglItem2);
Bapiaccr09 accrItem2 = new Bapiaccr09();
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = intSeq.ToString();
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[i]["RemittanceAmount"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "RemetancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Debit
}
else //post RMT for rep office
{
#region Credit
intSeq++;
Bapiacap09 capItem1 = new Bapiacap09();
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = intSeq.ToString();
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[i]["RequesterID"].ToString())).VendorCode;
capItem1.Pmnttrms = PostingConst.Pmnttrms;
capItem1.BlineDate = dstPosting.Tables[0].Rows[i]["BaseLineDate"].ToString();
capItem1.PmntBlock = PostingConst.PmntBlock;
capItem1.AllocNmbr = dstPosting.Tables[0].Rows[i]["AdvanceNo"].ToString();
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.ItemText = dstPosting.Tables[0].Rows[i]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[0].Rows[i]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.SpGlInd = SpGlIndConst.D;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem1.BusArea = dstPosting.Tables[0].Rows[i]["BusinessArea"].ToString();
}
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "RemittancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
Bapiaccr09 accrItem1 = new Bapiaccr09();
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = intSeq.ToString();
accrItem1.Currency = mainCurrencySymbol;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[0].Rows[i]["RemittanceAmountMainCurrency"].ToString());
accrItem1.ExchRate = decimal.Parse(dstPosting.Tables[0].Rows[i]["ExchangeRateMainToTHB"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "RemittancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
#endregion Credit
#region Debit
intSeq++;
Bapiacap09 capItem2 = new Bapiacap09();
capItem2.DocId = DocID;
capItem2.DocSeq = "M";
capItem2.DocKind = DocKind;
capItem2.ItemnoAcc = intSeq.ToString();
capItem2.VendorNo = dstPosting.Tables[0].Rows[i]["PBCode"].ToString();
capItem2.PmntBlock = PostingConst.PmntBlock;
capItem2.Pmnttrms = PostingConst.Pmnttrms;
capItem2.BlineDate = dstPosting.Tables[0].Rows[i]["BaseLineDate"].ToString();
capItem2.AllocNmbr = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[i]["RequesterID"].ToString())).EmployeeName;
capItem2.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem2.ItemText = dstPosting.Tables[0].Rows[i]["Description"].ToString();
capItem2.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem2.Businessplace = dstPosting.Tables[0].Rows[i]["BranchCode"].ToString();
capItem2.TaxCode = TaxCodeConst.NV;
if (bool.Parse(dstPosting.Tables[0].Rows[0]["RequireBusinessArea"].ToString()))
{
capItem2.BusArea = dstPosting.Tables[0].Rows[i]["BusinessArea"].ToString();
}
capItem2.Active = true;
capItem2.CreBy = 1;
capItem2.CreDate = DateTime.Now;
capItem2.UpdBy = 1;
capItem2.UpdDate = DateTime.Now;
capItem2.UpdPgm = "RemittancePosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem2);
Bapiaccr09 accrItem2 = new Bapiaccr09();
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = intSeq.ToString();
accrItem2.Currency = mainCurrencySymbol;
accrItem2.AmtDoccur = decimal.Parse(dstPosting.Tables[0].Rows[i]["RemittanceAmountMainCurrency"].ToString());
accrItem2.ExchRate = decimal.Parse(dstPosting.Tables[0].Rows[i]["ExchangeRateMainToTHB"].ToString());
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "RemittancePosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Debit
}
}
#endregion คู่บัญชี
}
}
//// POST: api/Collection
//public void Post([FromBody]string value)
//{
//}
// PUT: api/Collection/5
public void Put(int id)
{
if (id == 1)
{
//New Collection
DBManage MyDBManager = new DBManage();
SqlCommand Command = null;
System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers;
string userID_AGORASTH = string.Empty;
string userID_PWLHTH = string.Empty;
string SXOLIO_PWLHTH = string.Empty;
string HMEROMHNIA_EKT = string.Empty;
string Peridikotita = string.Empty;
string POSO = string.Empty;
string DOSEIS = string.Empty;
int Transaction_ID = 0;
int STATUS = 1; //ΕΚΚΡΕΜΕΙ
int Days = 0;
DateTime CalcDate;
if (headers.Contains("userID_AGORASTH"))
{
userID_AGORASTH = headers.GetValues("userID_AGORASTH").First();
}
if (headers.Contains("userID_PWLHTH"))
{
userID_PWLHTH = headers.GetValues("userID_PWLHTH").First();
}
if (headers.Contains("SXOLIO_PWLHTH"))
{
SXOLIO_PWLHTH = headers.GetValues("SXOLIO_PWLHTH").First();
}
if (headers.Contains("POSO"))
{
POSO = headers.GetValues("POSO").First();
}
if (headers.Contains("DOSEIS"))
{
DOSEIS = headers.GetValues("DOSEIS").First();
}
if (headers.Contains("HMEROMHNIA_EKT"))
{
HMEROMHNIA_EKT = headers.GetValues("HMEROMHNIA_EKT").First();
}
if (headers.Contains("Peridikotita"))
{
Peridikotita = headers.GetValues("Peridikotita").First();
}
string SqlString = string.Empty;
int RecsAff = 0;
SqlString = "i_tefteri_sp_New_Collection";
MyDBManager.CommandTimeOut = 30;
MyDBManager.ConStr = Constr();
try
{
switch (Peridikotita)
{
case "κάθε μήνα":
Days = 30;
break;
case "κάθε δυο μήνες":
Days = 60;
break;
case "κάθε τρεις μήνες":
Days = 90;
break;
case "κάθε τέσσερις μήνες":
Days = 120;
break;
case "κάθε εξάμηνο":
Days = 180;
break;
case "κάθε έτος":
Days = 365;
break;
}
MyDBManager.ConOpen();
Command = new SqlCommand();
Command.CommandText = SqlString;
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Add("@userID_AGORASTH", SqlDbType.Int);
Command.Parameters.Add("@userID_PWLHTH", SqlDbType.Int);
Command.Parameters.Add("@SXOLIO_PWLHTH", SqlDbType.NVarChar);
Command.Parameters.Add("@POSO", SqlDbType.Money);
Command.Parameters.Add("@DOSEIS", SqlDbType.Int);
Command.Parameters.Add("@STATUS", SqlDbType.Int);
Command.Parameters.Add("@Transaction_id", SqlDbType.BigInt);
Command.Parameters["@Transaction_id"].Direction = ParameterDirection.Output;
Command.Parameters["@userID_AGORASTH"].Value = userID_AGORASTH;
Command.Parameters["@userID_PWLHTH"].Value = userID_PWLHTH;
Command.Parameters["@SXOLIO_PWLHTH"].Value = SXOLIO_PWLHTH;
Command.Parameters["@POSO"].Value = Convert.ToDouble(POSO);
Command.Parameters["@DOSEIS"].Value = DOSEIS;
Command.Parameters["@STATUS"].Value = STATUS;
RecsAff = MyDBManager.ExecuteCommand(Command);
Transaction_ID = Convert.ToInt32(Command.Parameters["@Transaction_id"].Value.ToString());
SqlString = "i_tefteri_sp_New_Collection_DOSH";
CalcDate = DateTime.Parse(HMEROMHNIA_EKT);
System.TimeSpan duration = new System.TimeSpan(Days, 0, 0, 0);
for (int i = 1; i <= Convert.ToInt32(DOSEIS); i++)
{
Command = null;
Command = new SqlCommand();
Command.CommandText = SqlString;
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Add("@TransactionID", SqlDbType.BigInt);
Command.Parameters.Add("@HMEROMHNIA_EKT", SqlDbType.Date);
Command.Parameters.Add("@POSO", SqlDbType.Money);
Command.Parameters["@TransactionID"].Value = Transaction_ID;
Command.Parameters["@HMEROMHNIA_EKT"].Value = CalcDate;
Command.Parameters["@POSO"].Value = Math.Round(Convert.ToDouble(POSO) / Convert.ToInt32(DOSEIS), 2);
RecsAff = MyDBManager.ExecuteCommand(Command);
CalcDate = CalcDate.Add(duration);
}
Write2LogFile(MyDBManager, "Controller=Collection, " + "New_Collection", 2);
}
catch (Exception ex)
{
RecsAff = Write2LogFile(MyDBManager, "Controller=Collection, " + "Error: " + ex.Message, 2);
MyDBManager.ConClose();
MyDBManager = null;
}
}
else if (id == 2) //Update Collection
{
DBManage MyDBManager = new DBManage();
SqlCommand Command = null;
System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers;
string Transaction_id = String.Empty;
string SXOLIO_AGORASTH = string.Empty;
int STATUS = 2; //ΕΓΚΡΙΘΗΚΕ ΑΠΟ ΑΓΟΡΑΣΤΗ
int Days = 0;
DateTime CalcDate;
if (headers.Contains("Transaction_id"))
{
Transaction_id = headers.GetValues("Transaction_id").First();
}
if (headers.Contains("SXOLIO_AGORASTH"))
{
SXOLIO_AGORASTH = headers.GetValues("SXOLIO_AGORASTH").First();
}
string SqlString = string.Empty;
int RecsAff = 0;
SqlString = "i_tefteri_sp_Update_Collection";
MyDBManager.CommandTimeOut = 30;
MyDBManager.ConStr = Constr();
try
{
MyDBManager.ConOpen();
Command = new SqlCommand();
Command.CommandText = SqlString;
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Add("@Transaction_id", SqlDbType.BigInt);
Command.Parameters.Add("@SXOLIO_AGORASTH", SqlDbType.NVarChar);
Command.Parameters["@Transaction_id"].Value = Transaction_id;
Command.Parameters["@SXOLIO_AGORASTH"].Value = SXOLIO_AGORASTH;
RecsAff = MyDBManager.ExecuteCommand(Command);
Write2LogFile(MyDBManager, "Controller=Collection, " + "Update_Collection", 2);
}
catch (Exception ex)
{
RecsAff = Write2LogFile(MyDBManager, "Controller=Collection, " + "Error: " + ex.Message, 2);
MyDBManager.ConClose();
MyDBManager = null;
}
}
}
public override void CreatePostData(long DocID, string DocKind)
{
Hashtable paramete = new Hashtable();
paramete.Add("@DOCUMENT_ID", DocID.ToString());
DataSet dstPosting = new DBManage().ExecuteQuery("FIXEDADVANCE_POSTING", paramete);
SCGDocument doc = SCG.eAccounting.Query.ScgeAccountingQueryProvider.SCGDocumentQuery.FindProxyByIdentity(DocID);
DbSapInstance sap = SCG.DB.Query.ScgDbQueryProvider.DbCompanyQuery.GetSAPDocTypeForPosting(doc.CompanyID.CompanyCode);
if (dstPosting.Tables[1].Rows.Count > 0)
{
#region HEAD
Bapiache09 che09 = new Bapiache09();
che09.DocId = DocID;
che09.DocSeq = "M";
che09.DocKind = DocKind;
che09.BusAct = PostingConst.BusAct;
che09.Username = sap.UserCPIC;
che09.CompCode = dstPosting.Tables[1].Rows[0]["COMP_CODE"].ToString().Substring(0, 4);
che09.DocDate = dstPosting.Tables[1].Rows[0]["PostingDate"].ToString();
che09.DocKind = DocKind;
/*N-edited */
//che09.DocType = sap.DocTypeFixedAdvancePosting;
che09.DocType = sap.DocTypeFixedAdvanceReturnPosting;
che09.PstngDate = dstPosting.Tables[1].Rows[0]["PostingDate"].ToString();
che09.ReverseDate = dstPosting.Tables[1].Rows[0]["PostingDate"].ToString();
che09.RefDocNo = SAPUIHelper.SubString(16, dstPosting.Tables[0].Rows[0]["DocumentNo"].ToString());
che09.DocStatus = "N";
if (dstPosting.Tables[1].Rows[0]["PaymentType"].ToString() == PaymentTypeConst.DomesticCash)
{
che09.DocAppFlag = "A";
}
else
{
che09.DocAppFlag = "V";
}
che09.Active = true;
che09.CreBy = 1;
che09.CreDate = DateTime.Now;
che09.UpdBy = 1;
che09.UpdDate = DateTime.Now;
che09.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.Bapiache09Service.Save(che09);
#endregion HEAD
#region Foolter
Bapiacextc cextc = new Bapiacextc();
cextc.DocId = DocID;
cextc.DocSeq = "M";
cextc.DocKind = DocKind;
cextc.Field1 = PostingConst.BRNCH;
cextc.Field2 = dstPosting.Tables[1].Rows[0]["BranchCode"].ToString();
cextc.Active = true;
cextc.CreBy = 1;
cextc.CreDate = DateTime.Now;
cextc.UpdBy = 1;
cextc.UpdDate = DateTime.Now;
cextc.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc);
Bapiacextc cextc1 = new Bapiacextc();
cextc1.DocId = DocID;
cextc1.DocSeq = "M";
cextc1.DocKind = DocKind;
cextc1.Field1 = PostingConst.VAT;
cextc1.Field2 = TaxCodeConst.NV;
cextc1.Active = true;
cextc1.CreBy = 1;
cextc1.CreDate = DateTime.Now;
cextc1.UpdBy = 1;
cextc1.UpdDate = DateTime.Now;
cextc1.UpdPgm = "FixedAdvancePosting";
BapiServiceProvider.BapiacextcService.Save(cextc1);
#endregion Foolter
#region Domestic
#region Credit
Bapiacap09 capItem1 = new Bapiacap09();
capItem1.DocId = DocID;
capItem1.DocSeq = "M";
capItem1.DocKind = DocKind;
capItem1.ItemnoAcc = "1";
//capItem1.GlAccount = SAPUIHelper.GetFixedPostingAccountReturnCr(long.Parse(dstPosting.Tables[1].Rows[0]["RequesterID"].ToString()));
capItem1.VendorNo = SAPUIHelper.GetEmployee(long.Parse(dstPosting.Tables[0].Rows[0]["RequesterID"].ToString())).VendorCode;
capItem1.AllocNmbr = dstPosting.Tables[1].Rows[0]["FixedAdvanceNo"].ToString();
capItem1.AllocNmbr = SAPUIHelper.SubString18(capItem1.AllocNmbr);
capItem1.ItemText = dstPosting.Tables[1].Rows[0]["Description"].ToString();
capItem1.ItemText = SAPUIHelper.SubString50(capItem1.ItemText);
capItem1.Businessplace = dstPosting.Tables[1].Rows[0]["BranchCode"].ToString();
capItem1.TaxCode = TaxCodeConst.NV;
capItem1.SpGlInd = SpGlIndConst.H;
capItem1.Active = true;
capItem1.CreBy = 1;
capItem1.CreDate = DateTime.Now;
capItem1.UpdBy = 1;
capItem1.UpdDate = DateTime.Now;
capItem1.UpdPgm = "FixedAdvanceReturnPosting";
BapiServiceProvider.Bapiacap09Service.Save(capItem1);
Bapiaccr09 accrItem1 = new Bapiaccr09();
accrItem1.DocId = DocID;
accrItem1.DocSeq = "M";
accrItem1.DocKind = DocKind;
accrItem1.ItemnoAcc = "1";
accrItem1.Currency = PostingConst.Currency;
accrItem1.AmtDoccur = 0 - decimal.Parse(dstPosting.Tables[1].Rows[0]["Amount"].ToString());
accrItem1.Active = true;
accrItem1.CreBy = 1;
accrItem1.CreDate = DateTime.Now;
accrItem1.UpdBy = 1;
accrItem1.UpdDate = DateTime.Now;
accrItem1.UpdPgm = "FixedAdvanceReturnPosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem1);
#endregion Credit
#region Debit
Bapiacgl09 cglItem2 = new Bapiacgl09();
cglItem2.DocId = DocID;
cglItem2.DocSeq = "M";
cglItem2.DocKind = DocKind;
cglItem2.ItemnoAcc = "2";
cglItem2.GlAccount = dstPosting.Tables[1].Rows[0]["BankAccount"].ToString();
cglItem2.AllocNmbr = dstPosting.Tables[1].Rows[0]["FixedAdvanceNo"].ToString();
cglItem2.AllocNmbr = SAPUIHelper.SubString18(cglItem2.AllocNmbr);
cglItem2.ItemText = dstPosting.Tables[1].Rows[0]["Description"].ToString();
cglItem2.ItemText = SAPUIHelper.SubString50(cglItem2.ItemText);
cglItem2.Active = true;
cglItem2.CreBy = 1;
cglItem2.CreDate = DateTime.Now;
cglItem2.UpdBy = 1;
cglItem2.UpdDate = DateTime.Now;
cglItem2.UpdPgm = "FixedAdvanceReturnPosting";
/*N-edited valuedate = requestdate*/
cglItem2.ValueDate = dstPosting.Tables[1].Rows[0]["ReturnRequestDate"].ToString(); /*DateFormat = YYYYMMDD*/
BapiServiceProvider.Bapiacgl09Service.Save(cglItem2);
Bapiaccr09 accrItem2 = new Bapiaccr09();
accrItem2.DocId = DocID;
accrItem2.DocSeq = "M";
accrItem2.DocKind = DocKind;
accrItem2.ItemnoAcc = "2";
accrItem2.Currency = PostingConst.Currency;
accrItem2.AmtDoccur = (decimal.Parse(dstPosting.Tables[1].Rows[0]["Amount"].ToString()));
accrItem2.Active = true;
accrItem2.CreBy = 1;
accrItem2.CreDate = DateTime.Now;
accrItem2.UpdBy = 1;
accrItem2.UpdDate = DateTime.Now;
accrItem2.UpdPgm = "FixedAdvanceReturnPosting";
BapiServiceProvider.Bapiaccr09Service.Save(accrItem2);
#endregion Debit
#endregion Domestic
}
}
