public object Save(DataTable dtM, bool 타메뉴호출)
{
SpInfoCollection sic = new SpInfoCollection();
SpInfo si;
if (dtM != null)
{
si = new SpInfo();
/*
* if (!타메뉴호출)
* si.DataState = DataValueState.Added;
* else
* si.DataState = DataValueState.Modified;
*/
si.DataValue = dtM;
si.CompanyID = 회사코드;
si.UserID = 사용자ID;
si.SpNameInsert = "UP_CZ_ME_MAP_DEPT_IU";
si.SpNameUpdate = "UP_CZ_ME_MAP_DEPT_IU";
si.SpNameDelete = "UP_CZ_ME_MAP_DEPT_D";
si.SpParamsInsert = new string[] { "CD_COMPANY", "CD_DEPT_MTS", "NM_DEPT_MTS", "CD_DEPT", "NM_DEPT", "NO_APPLY", "CD_CC", "DT_START" };
si.SpParamsUpdate = new string[] { "CD_COMPANY", "CD_DEPT_MTS", "NM_DEPT_MTS", "CD_DEPT", "NM_DEPT", "NO_APPLY", "CD_CC", "DT_START" };
si.SpParamsDelete = new string[] { "CD_COMPANY", "CD_DEPT" };
sic.Add(si);
}
return(Global.MainFrame.Save(sic));
}
public object Save_t2(DataTable dtM, bool 타메뉴호출)
{
SpInfoCollection sic = new SpInfoCollection();
SpInfo si;
if (dtM != null)
{
si = new SpInfo();
/*
* if (!타메뉴호출)
* si.DataState = DataValueState.Added;
* else
* si.DataState = DataValueState.Modified;
*/
si.DataValue = dtM;
si.CompanyID = 회사코드;
si.UserID = 사용자ID;
si.SpNameInsert = "UP_CZ_ME_MAP_PARTNER_T2_IU";
si.SpNameUpdate = "UP_CZ_ME_MAP_PARTNER_T2_IU";
si.SpParamsInsert = new string[] { "CD_COMPANY", "me_type", "me_attr", "me_sumcode", "corpflag", "corpid", "ID_INSERT" };
si.SpParamsUpdate = new string[] { "CD_COMPANY", "me_type", "me_attr", "me_sumcode", "corpflag", "corpid", "ID_UPDATE" };
sic.Add(si);
}
return(Global.MainFrame.Save(sic));
}
public object Save(DataTable dtM, DataTable dtD, bool 타메뉴호출)
{
SpInfoCollection sic = new SpInfoCollection();
SpInfo si;
if (dtM != null)
{
si = new SpInfo();
if (!타메뉴호출)
{
si.DataState = DataValueState.Added;
}
else
{
si.DataState = DataValueState.Modified;
}
si.DataValue = dtM;
si.CompanyID = 회사코드;
si.UserID = 사용자ID;
si.SpNameInsert = "UP_CZ_MEZZO_SALESGR_H_I";
si.SpNameUpdate = "UP_CZ_MEZZO_SALESGR_H_U";
si.SpParamsInsert = new string[] { "NO_IV", "CD_COMPANY", "CD_BIZAREA", "NO_BIZAREA", "FG_TPPURCHASE", "CD_PARTNER", "FG_TRANS", "AM_K", "VAT_TAX", "RT_EXCH", "CD_EXCH", "AM_EX", "DT_PROCESS",
"FG_TAX", "CD_DEPT", "NO_EMP", "YN_PURSUB", "YN_EXPIV", "ID_INSERT", "DC_RMK", "FG_PAYBILL", "DT_PAY_PREARRANGED",
"CD_BIZAREA_TAX", "YN_JEONJA", "CD_PC_USER", "NO_DEPOSIT", "TXT_USERDEF1", "TP_SUMTAX", "TP_EVIDENCE" };
si.SpParamsUpdate = new string[] { "NO_IV", "CD_COMPANY", "CD_BIZAREA", "NO_BIZAREA", "FG_TPPURCHASE", "CD_PARTNER", "FG_TRANS", "AM_K", "VAT_TAX", "RT_EXCH", "CD_EXCH", "AM_EX", "DT_PROCESS",
"FG_TAX", "CD_DEPT", "NO_EMP", "YN_PURSUB", "YN_EXPIV", "ID_UPDATE", "DC_RMK", "FG_PAYBILL", "DT_PAY_PREARRANGED",
"CD_BIZAREA_TAX", "YN_JEONJA", "CD_PC_USER", "NO_DEPOSIT", "TXT_USERDEF1", "TP_SUMTAX", "TP_EVIDENCE" };
sic.Add(si);
}
if (dtD != null)
{
SpInfo si1 = new SpInfo();
si1 = new Duzon.Common.Util.SpInfo();
//if (!타메뉴호출)
// si1.DataState = DataValueState.Added;
si1.DataValue = dtD;
si1.CompanyID = 회사코드;
si1.UserID = 사용자ID;
si1.SpNameInsert = "UP_CZ_MEZZO_SALESGR_D_I";
si1.SpParamsInsert = new string[] { "NO_IV", "NO_IVLINE", "CD_COMPANY", "CD_PLANT", "NO_IO", "CD_ITEM",
"CD_PURGRP", "DT_TAX", "UM", "AM_IV", "VAT_IV", "NO_EMP", "CD_PJT",
"FG_TPPURCHASE", "NO_PO", "CD_EXCH", "RT_EXCH", "UM_EX", "AM_EX",
"QT_CLS", "NO_WBS", "NO_CBS", "TP_UM_TAX", "MEMO_CD", "CHECK_PEN", "REMARK",
"ACCT_NO", "BANK_CODE", "TRADE_DATE", "TRADE_TIME", "SEQ", "YN_CAL",
"CD_ITEM_PARENTS", "CD_BUDGET", "TP_CAL", "CD_NATION", "FG_TAX", "TRADE_PLACE", "ID_INSERT" };
sic.Add(si1);
}
return(Global.MainFrame.Save(sic));
}
public object Save(DataTable dtM, bool 타메뉴호출)
{
SpInfoCollection sic = new SpInfoCollection();
SpInfo si;
if (dtM != null)
{
si = new SpInfo();
/*
* if (!타메뉴호출)
* si.DataState = DataValueState.Added;
* else
* si.DataState = DataValueState.Modified;
*/
si.DataValue = dtM;
si.CompanyID = 회사코드;
si.UserID = 사용자ID;
si.SpNameInsert = "UP_CZ_ME_SALES_FOR_I";
si.SpNameUpdate = "UP_CZ_ME_SALES_FOR_U";
si.SpNameDelete = "UP_CZ_ME_SALES_FOR_D";
si.SpParamsInsert = new string[] {
"CD_COMPANY", "TP_SALES", "MER_REQ_NO", "ME_CPID", "NM_CPID", "ME_SEQ"
, "AY_AGENCYID", "AY_YEAR_MONTH", "AY_TRADE_TYPE", "ME_CORPID", "ME_YEAR_MONTH"
, "ME_TRADE_TYPE", "CD_SYSDEF", "CD_ACCT", "ME_TEAMID", "AM_BUDGET"
, "AM_INCOME", "AM_AGY_PRICE", "AM_MEDIA_PRICE", "ID_INSERT", "ID_UPDATE"
, "DT_YEAR"
};
si.SpParamsUpdate = new string[] {
"CD_COMPANY", "TP_SALES", "MER_REQ_NO", "ME_CPID", "NM_CPID", "ME_SEQ"
, "AY_AGENCYID", "AY_YEAR_MONTH", "AY_TRADE_TYPE", "ME_CORPID", "ME_YEAR_MONTH"
, "ME_TRADE_TYPE", "CD_SYSDEF", "CD_ACCT", "ME_TEAMID", "AM_BUDGET"
, "AM_INCOME", "AM_AGY_PRICE", "AM_MEDIA_PRICE", "ID_INSERT", "ID_UPDATE"
, "DT_YEAR"
};
si.SpParamsDelete = new string[] { "CD_COMPANY", "TP_SALES", "MER_REQ_NO", "ME_CPID", "ME_SEQ" };
sic.Add(si);
}
return(Global.MainFrame.Save(sic));
}
public object Save(DataTable dtM, bool 타메뉴호출)
{
SpInfoCollection sic = new SpInfoCollection();
SpInfo si;
string DEPT_CODE = Global.MainFrame.LoginInfo.DeptCode;
if (dtM != null)
{
si = new SpInfo();
/*
* if (!타메뉴호출)
* si.DataState = DataValueState.Added;
* else
* si.DataState = DataValueState.Modified;
*/
si.DataValue = dtM;
si.CompanyID = 회사코드;
si.UserID = 사용자ID;
si.SpNameInsert = "UP_CZ_ME_SALES_PUB_I";
si.SpNameUpdate = "UP_CZ_ME_SALES_PUB_I";
si.SpNameDelete = "UP_CZ_ME_SALES_PUB_D";
si.SpParamsInsert = new string[] {
"CD_COMPANY", "TP_SALES", "MER_REQ_NO", "ME_CPID", "ME_SEQ"
, "ME_CORPNO", "ME_YEAR_MONTH", "ME_TRADE_TYPE", "AM_BUDGET", "AM_AGY_PRICE"
, "AM_MEDIA_PRICE", "NO_DOCU_M", "NO_DOCU_C", "ID_INSERT", "ID_UPDATE"
};
si.SpParamsUpdate = new string[] {
"CD_COMPANY", "TP_SALES", "MER_REQ_NO", "ME_CPID", "ME_SEQ"
, "ME_CORPNO", "ME_YEAR_MONTH", "ME_TRADE_TYPE", "AM_BUDGET", "AM_AGY_PRICE"
, "AM_MEDIA_PRICE", "NO_DOCU_M", "NO_DOCU_C", "ID_INSERT", "ID_UPDATE"
};
si.SpParamsDelete = new string[] { "CD_COMPANY", "TP_SALES", "MER_REQ_NO", "ME_CPID", "ME_SEQ" };
sic.Add(si);
}
return(Global.MainFrame.Save(sic));
}
public object Save(DataTable dtM)
{
SpInfoCollection sic = new SpInfoCollection();
SpInfo si;
if (dtM != null)
{
si = new SpInfo();
si.DataValue = dtM;
si.CompanyID = 회사코드;
si.UserID = 사용자ID;
si.SpNameInsert = "UP_CZ_ME_SALES_I";
si.SpNameUpdate = "UP_CZ_ME_SALES_U";
si.SpParamsInsert = new string[] {
"CD_COMPANY", "actyear", "CD_ACCT", "cpid", "cpname", "yearmonth"
, "trade_type_d", "biz_no_d", "agencyid", "corpname_d", "yearmonth2"
, "trade_type_m", "biz_no_m", "corpid", "corpname_m", "NM_MEDIAGR"
, "teamid", "teamname", "budget", "agy_price", "income"
, "corp_amt", "agentid", "agentname", "closed", "status"
, "ID_INSERT", "ID_UPDATE"
};
si.SpParamsUpdate = new string[] {
"CD_COMPANY", "actyear", "CD_ACCT", "cpid", "cpname", "yearmonth"
, "trade_type_d", "biz_no_d", "agencyid", "corpname_d", "yearmonth2"
, "trade_type_m", "biz_no_m", "corpid", "corpname_m", "NM_MEDIAGR"
, "teamid", "teamname", "budget", "agy_price", "income"
, "corp_amt", "agentid", "agentname", "closed", "status"
, "ID_INSERT", "ID_UPDATE"
};
sic.Add(si);
}
return(Global.MainFrame.Save(sic));
}
internal bool Save2(DataTable dt)
{
SpInfoCollection sc = new SpInfoCollection();
SpInfo si = null;
if (dt != null && dt.Rows.Count != 0)
{
si = new SpInfo();
si.DataValue = dt;
si.CompanyID = Global.MainFrame.LoginInfo.CompanyCode;
si.UserID = Global.MainFrame.LoginInfo.EmployeeNo;
si.SpNameInsert = "UP_CZ_ME_CALENDAR_I";
si.SpNameUpdate = "UP_CZ_ME_CALENDAR_U";
si.SpNameDelete = "UP_CZ_ME_CALENDAR_D";
si.SpParamsInsert = new string[] { "CD_COMPANY", "DT_CALENDAR", "TP_CALENDAR", "DT_ROW", "NO_EMP", "NM_TITLE", "NM_NOTE", "DT_INSERT", "DT_UPDATE", "HOLIDAY", "TM_START" };
si.SpParamsUpdate = new string[] { "CD_COMPANY", "DT_CALENDAR", "TP_CALENDAR", "DT_ROW", "NO_EMP", "NM_TITLE", "NM_NOTE", "DT_INSERT", "DT_UPDATE", "TM_START" };
si.SpParamsDelete = new string[] { "CD_COMPANY", "DT_ROW" };
sc.Add(si);
}
return(DBHelper.Save(sc));
}
internal bool Save(DataTable dtInvoice, DataTable dtFreight, List <string> list)
{
SpInfoCollection sc = new SpInfoCollection();
if (dtInvoice != null)
{
SpInfo si = new SpInfo();
si.DataValue = dtInvoice;
si.FirmCode = Global.FirmCode;
si.UserID = Global.UserID;
si.SpNameInsert = "AP_INT_INVOICE_I";
si.SpNameUpdate = "AP_INT_INVOICE_I";
si.SpParamsInsert = new string[] { "CD_FIRM", "CD_BIZ", "NO_SLIP_INVOICE", "FG_INVOICE", "NO_INVOICE",
"NM_MENU", "FG_REG_TYPE", "NO_INVOICE_REL", "NO_SLIP_INVOICE_AP", "CD_INVOICE_STATUS",
"CD_PARTNER_BILL_TO", "NM_PARTNER_BILL_TO", "DC_PARTNER_BILL_TO_ADDR", "CD_PARTNER_SHIP_TO", "NM_PARTNER_SHIP_TO",
"DC_PARTNER_SHIP_TO_ADDR", "DC_RMK", "DC_ATTN_TO", "CD_CURRENCY", "TM_INVOICE",
"TM_INVOICE_DUE", "TM_INVOICE_POST", "TM_PAY_LAST", "TM_INVOICE_RECEIVED",
"CD_CURRENCY_STANDARD", "RT_XCRT_STANDARD", "AM_INVOICE_STANDARD", "YN_INVOICE_RECEIVED",
"CD_USER_REG" };
si.SpParamsUpdate = new string[] { "CD_FIRM", "CD_BIZ", "NO_SLIP_INVOICE", "FG_INVOICE", "NO_INVOICE",
"NM_MENU", "FG_REG_TYPE", "NO_INVOICE_REL", "NO_SLIP_INVOICE_AP", "CD_INVOICE_STATUS",
"CD_PARTNER_BILL_TO", "NM_PARTNER_BILL_TO", "DC_PARTNER_BILL_TO_ADDR", "CD_PARTNER_SHIP_TO", "NM_PARTNER_SHIP_TO",
"DC_PARTNER_SHIP_TO_ADDR", "DC_RMK", "DC_ATTN_TO", "CD_CURRENCY", "TM_INVOICE",
"TM_INVOICE_DUE", "TM_INVOICE_POST", "TM_PAY_LAST", "TM_INVOICE_RECEIVED",
"CD_CURRENCY_STANDARD", "RT_XCRT_STANDARD", "AM_INVOICE_STANDARD", "YN_INVOICE_RECEIVED",
"CD_USER_REG" };
sc.Add(si);
}
if (dtFreight != null)
{
SpInfo si = new SpInfo();
si.DataValue = dtFreight;
si.FirmCode = Global.FirmCode;
si.UserID = Global.UserID;
si.SpNameInsert = "AP_INT_FREIGHT_I";
si.SpNameUpdate = "AP_INT_FREIGHT_U";
si.SpNameDelete = "AP_INT_FREIGHT_D";
si.SpParamsInsert = new string[] { "CD_FIRM", "CD_BIZ1", "NO_SLIP_INVOICE1", "SEQ_FREIGHT", "CD_FREIGHT", "NM_FREIGHT", "FG_REV_COST", "FG_FREIGHT_TERM", "CD_CURRENCY_INVOICE1", "CD_CURRENCY",
"RT_XCRT", "FG_CALC", "QT_UNIT", "RT_UNIT", "RT_FREIGHT_VAT", "AM_FREIGHT", "AM_FREIGHT_VAT", "AM_FREIGHT_SUM", "AM_FREIGHT_COST", "AM_FREIGHT_VAT_COST",
"AM_FREIGHT_SUM_COST", "NO_SLIP_BL1", "TM_INVOICE_POST", "CD_USER_REG", "NO_SLIP_PROGRESS_REL", "FG_FREIGHT_REL", "SEQ_PROGRESS_ACCT_INFO_REL" };
si.SpParamsUpdate = new string[] { "CD_FIRM", "CD_BIZ1", "NO_SLIP_INVOICE1", "SEQ_FREIGHT", "CD_FREIGHT", "NM_FREIGHT", "FG_REV_COST", "FG_FREIGHT_TERM", "CD_CURRENCY_INVOICE1", "CD_CURRENCY",
"RT_XCRT", "FG_CALC", "QT_UNIT", "RT_UNIT", "RT_FREIGHT_VAT", "AM_FREIGHT", "AM_FREIGHT_VAT", "AM_FREIGHT_SUM", "AM_FREIGHT_COST", "AM_FREIGHT_VAT_COST",
"AM_FREIGHT_SUM_COST", "NO_SLIP_BL1", "TM_INVOICE_POST", "CD_USER_AMD", "NO_SLIP_PROGRESS_REL", "FG_FREIGHT_REL", "SEQ_PROGRESS_ACCT_INFO_REL" };
si.SpParamsDelete = new string[] { "CD_FIRM", "CD_BIZ1", "NO_SLIP_INVOICE1", "SEQ_FREIGHT", "CD_USER_AMD" };
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Insert, "CD_BIZ1", list[0]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Insert, "NO_SLIP_INVOICE1", list[1]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Insert, "NO_SLIP_BL1", list[2]);
//si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Insert, "TM_INVOICE_POST1", list[3]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Insert, "CD_CURRENCY_INVOICE1", list[3]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Update, "CD_BIZ1", list[0]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Update, "NO_SLIP_INVOICE1", list[1]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Update, "NO_SLIP_BL1", list[2]);
//si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Update, "TM_INVOICE_POST1", list[3]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Update, "CD_CURRENCY_INVOICE1", list[3]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Delete, "CD_BIZ1", list[0]);
si.SpParamsValues.Add(NF.A2P.CommonFunction.SpState.Delete, "NO_SLIP_INVOICE1", list[1]);
sc.Add(si);
}
return(DBHelper.Save(sc));
}
