public void ADDTBDEVMEMO(string ID, string SERNO, string STATUS, string KIND, string CLIENT, string PROD, string SPEC, string PLACES, string ONSALES, string OWNER, string MEMO, string FEASIBILITY, string SAMPLETRIAL, string COSTTRIAL, string SENDINSPECTION, string PROOFREADING, string PRODUCTION)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" INSERT INTO [TKRESEARCH].[dbo].[TBDEVMEMO]
([STATUS],[KIND],[CLIENT],[PROD],[SPEC],[PLACES],[ONSALES],[OWNER],[MEMO],[FEASIBILITY],[SAMPLETRIAL],[COSTTRIAL],[SENDINSPECTION],[PROOFREADING],[PRODUCTION])
VALUES
(@STATUS,@KIND,@CLIENT,@PROD,@SPEC,@PLACES,@ONSALES,@OWNER,@MEMO,@FEASIBILITY,@SAMPLETRIAL,@COSTTRIAL,@SENDINSPECTION,@PROOFREADING,@PRODUCTION)
";
m_db.AddParameter("@STATUS", STATUS);
m_db.AddParameter("@KIND", KIND);
m_db.AddParameter("@CLIENT", CLIENT);
m_db.AddParameter("@PROD", PROD);
m_db.AddParameter("@SPEC", SPEC);
m_db.AddParameter("@PLACES", PLACES);
m_db.AddParameter("@ONSALES", ONSALES);
m_db.AddParameter("@OWNER", OWNER);
m_db.AddParameter("@MEMO", MEMO);
m_db.AddParameter("@FEASIBILITY", FEASIBILITY);
m_db.AddParameter("@SAMPLETRIAL", SAMPLETRIAL);
m_db.AddParameter("@COSTTRIAL", COSTTRIAL);
m_db.AddParameter("@SENDINSPECTION", SENDINSPECTION);
m_db.AddParameter("@PROOFREADING", PROOFREADING);
m_db.AddParameter("@PRODUCTION", PRODUCTION);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATEPRODUCTS(string ID, string PRODUCTSFEATURES, string SALESFOCUS, string COPYWRITINGS, string PRICES1, string PRICES2, string PRICES3, string MOQS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKBUSINESS].[dbo].[PRODUCTS]
SET
[PRODUCTSFEATURES]=@PRODUCTSFEATURES
,[SALESFOCUS]=@SALESFOCUS
,[COPYWRITINGS]=@COPYWRITINGS
,[PRICES1]=@PRICES1
,[PRICES2]=@PRICES2
,[PRICES3]=@PRICES3
,[MOQS]=@MOQS
WHERE [MB001]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@PRODUCTSFEATURES", PRODUCTSFEATURES);
m_db.AddParameter("@SALESFOCUS", SALESFOCUS);
m_db.AddParameter("@COPYWRITINGS", COPYWRITINGS);
m_db.AddParameter("@PRICES1", PRICES1);
m_db.AddParameter("@PRICES2", PRICES2);
m_db.AddParameter("@PRICES3", PRICES3);
m_db.AddParameter("@MOQS", MOQS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDTBSALESDEVMEMO(Guid ID, string PROJECTNO, string PROJECTNAME, string ONLINEFINISH, string PAPERFINISH, string MEMO, string PROJECTSTATUS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
INSERT INTO [TKRESEARCH].dbo.[TBPROJECT]
([ID],[PROJECTNO],[PROJECTNAME],[ONLINEFINISH],[PAPERFINISH],[MEMO],[PROJECTSTATUS])
VALUES
(@ID,@PROJECTNO,@PROJECTNAME,@ONLINEFINISH,@PAPERFINISH,@MEMO,@PROJECTSTATUS)
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@PROJECTNO", PROJECTNO);
m_db.AddParameter("@PROJECTNAME", PROJECTNAME);
m_db.AddParameter("@ONLINEFINISH", ONLINEFINISH);
m_db.AddParameter("@PAPERFINISH", PAPERFINISH);
m_db.AddParameter("@MEMO", MEMO);
m_db.AddParameter("@PROJECTSTATUS", PROJECTSTATUS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDCOPCOPMACLIENT(string ID, string MA001, string MA002, string CLIENTS, string OPERATIONS, string COMMENTS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
INSERT INTO [TKBUSINESS].[dbo].[COPCOPMACLIENT]
([ID],[MA001],[MA002],[CLIENTS],[OPERATIONS],[COMMENTS])
VALUES
(@ID,@MA001,@MA002,@CLIENTS,@OPERATIONS,@COMMENTS)
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@MA001", MA001);
m_db.AddParameter("@MA002", MA002);
m_db.AddParameter("@CLIENTS", CLIENTS);
m_db.AddParameter("@OPERATIONS", OPERATIONS);
m_db.AddParameter("@COMMENTS", COMMENTS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDTBPROMOTIONNFEEPRODUCTS(string MID, string MB001, string MB002, string MB003, string MB004, string PRICES, string SPRICES, string COSTS, string NUMS, string MONEYS, string FEES, string EARNS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
INSERT INTO [TKBUSINESS].[dbo].[TBPROMOTIONNFEEPRODUCTS]
([MID],[MB001],[MB002],[MB003],[MB004],[PRICES],[SPRICES],[COSTS],[NUMS],[MONEYS],[FEES],[EARNS])
VALUES
(@MID,@MB001,@MB002,@MB003,@MB004,@PRICES,@SPRICES,@COSTS,@NUMS,@MONEYS,@FEES,@EARNS)
";
m_db.AddParameter("@MID", MID);
m_db.AddParameter("@MB001", MB001);
m_db.AddParameter("@MB002", MB002);
m_db.AddParameter("@MB003", MB003);
m_db.AddParameter("@MB004", MB004);
m_db.AddParameter("@PRICES", PRICES);
m_db.AddParameter("@SPRICES", SPRICES);
m_db.AddParameter("@COSTS", COSTS);
m_db.AddParameter("@NUMS", NUMS);
m_db.AddParameter("@MONEYS", MONEYS);
m_db.AddParameter("@FEES", FEES);
m_db.AddParameter("@EARNS", EARNS);
m_db.ExecuteNonQuery(cmdTxt);
int i = 0;
}
public void UPDATECOPCOPMACLIENT(string ID, string MA001, string MA002, string CLIENTS, string OPERATIONS, string COMMENTS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKBUSINESS].[dbo].[COPCOPMACLIENT]
SET
[MA001]=@MA001
,[MA002]=@MA002
,[CLIENTS]=@CLIENTS
,[OPERATIONS]=@OPERATIONS
,[COMMENTS]=@COMMENTS
WHERE [ID]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@MA001", MA001);
m_db.AddParameter("@MA002", MA002);
m_db.AddParameter("@CLIENTS", CLIENTS);
m_db.AddParameter("@OPERATIONS", OPERATIONS);
m_db.AddParameter("@COMMENTS", COMMENTS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBPROJECTS(string ID, string YEARS, string WEEKS, string STORES, string NAMES, string ITEMS, string CONTENTS, string DAYS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKBUSINESS].[dbo].[TBPROJECTS]
SET
[YEARS]=@YEARS
,[WEEKS]=@WEEKS
,[STORES]=@STORES
,[NAMES]=@NAMES
,[ITEMS]=@ITEMS
,[CONTENTS]=@CONTENTS
,[DAYS]=@DAYS
WHERE [ID]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@YEARS", YEARS);
m_db.AddParameter("@WEEKS", WEEKS);
m_db.AddParameter("@STORES", STORES);
m_db.AddParameter("@NAMES", NAMES);
m_db.AddParameter("@ITEMS", ITEMS);
m_db.AddParameter("@CONTENTS", CONTENTS);
m_db.AddParameter("@DAYS", DAYS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDTBPROJECTS(Guid ID, string NO, string SUBJECT, string CREATE_NEME, string CREATE_DEP, string CREATE_TIME, string STATUS, string CONTENTS, string PUCLOSE_TIME, string HADNUMS, string HADCONTENTS, string NOWNUMS, string TOTALNUMS, string CLOSE_CONTENTS, string CLOSE_TIME)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
INSERT INTO [TKQC].[dbo].[TBPROJECTS]
([ID],[NO],[SUBJECT],[CREATE_NEME],[CREATE_DEP],[CREATE_TIME],[STATUS],[CONTENTS],[PUCLOSE_TIME],[HADNUMS],[HADCONTENTS],[NOWNUMS],[TOTALNUMS],[CLOSE_CONTENTS],[CLOSE_TIME])
VALUES
(@ID,@NO,@SUBJECT,@CREATE_NEME,@CREATE_DEP,@CREATE_TIME,@STATUS,@CONTENTS,@PUCLOSE_TIME,@HADNUMS,@HADCONTENTS,@NOWNUMS,@TOTALNUMS,@CLOSE_CONTENTS,@CLOSE_TIME)
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@NO", NO);
m_db.AddParameter("@SUBJECT", SUBJECT);
m_db.AddParameter("@CREATE_NEME", CREATE_NEME);
m_db.AddParameter("@CREATE_DEP", CREATE_DEP);
m_db.AddParameter("@CREATE_TIME", CREATE_TIME);
m_db.AddParameter("@STATUS", STATUS);
m_db.AddParameter("@CONTENTS", CONTENTS);
m_db.AddParameter("@PUCLOSE_TIME", PUCLOSE_TIME);
m_db.AddParameter("@HADNUMS", HADNUMS);
m_db.AddParameter("@HADCONTENTS", HADCONTENTS);
m_db.AddParameter("@NOWNUMS", NOWNUMS);
m_db.AddParameter("@TOTALNUMS", TOTALNUMS);
m_db.AddParameter("@CLOSE_CONTENTS", CLOSE_CONTENTS);
m_db.AddParameter("@CLOSE_TIME", CLOSE_TIME);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBDEVMEMO(string ID, string STATUS, string KIND, string CLIENT, string PROD, string SPEC, string PLACES, string ONSALES, string OWNER, string MEMO, string FEASIBILITY, string SAMPLETRIAL, string COSTTRIAL, string SENDINSPECTION, string PROOFREADING, string PRODUCTION)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" UPDATE [TKRESEARCH].[dbo].[TBDEVMEMO] SET STATUS=@STATUS,KIND=@KIND,CLIENT=@CLIENT,PROD=@PROD,SPEC=@SPEC,PLACES=@PLACES,ONSALES=@ONSALES,OWNER=@OWNER,MEMO=@MEMO,FEASIBILITY=@FEASIBILITY,SAMPLETRIAL=@SAMPLETRIAL,COSTTRIAL=@COSTTRIAL,SENDINSPECTION=@SENDINSPECTION,PROOFREADING=@PROOFREADING,PRODUCTION=@PRODUCTION WHERE[ID]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@STATUS", STATUS);
m_db.AddParameter("@KIND", KIND);
m_db.AddParameter("@CLIENT", CLIENT);
m_db.AddParameter("@PROD", PROD);
m_db.AddParameter("@SPEC", SPEC);
m_db.AddParameter("@PLACES", PLACES);
m_db.AddParameter("@ONSALES", ONSALES);
m_db.AddParameter("@OWNER", OWNER);
m_db.AddParameter("@MEMO", MEMO);
m_db.AddParameter("@FEASIBILITY", FEASIBILITY);
m_db.AddParameter("@SAMPLETRIAL", SAMPLETRIAL);
m_db.AddParameter("@COSTTRIAL", COSTTRIAL);
m_db.AddParameter("@SENDINSPECTION", SENDINSPECTION);
m_db.AddParameter("@PROOFREADING", PROOFREADING);
m_db.AddParameter("@PRODUCTION", PRODUCTION);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBPURMOQ(string ID, string KINDS, string NAMES, string MOQS, string INDAYS, string COMMENTS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKBUSINESS].[dbo].[TBPURMOQ]
SET
[KINDS]=@KINDS
,[NAMES]=@NAMES
,[MOQS]=@MOQS
,[INDAYS]=@INDAYS
,[COMMENTS]=@COMMENTS
WHERE [ID]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@KINDS", KINDS);
m_db.AddParameter("@NAMES", NAMES);
m_db.AddParameter("@MOQS", MOQS);
m_db.AddParameter("@INDAYS", INDAYS);
m_db.AddParameter("@COMMENTS", COMMENTS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBPROMOTIONNFEE(string ID, string YEARS, string SALES, string NAMES, string KINDS, string PROMOTIONS, string PROMOTIONSSETS, string SDATES, string CLIENTS, string STORES, string SALESNUMS, string SALESMONEYS, string COSTMONEYS, string FEEMONEYS, string PROFITS, string COMMENTS, string DEPNAME, string TITLES, string ACTSALESMONEYS, string ACTCOSTMONEYS, string ACTFEEMONEYS, string ACTPROFITS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKBUSINESS].[dbo].[TBPROMOTIONNFEE]
SET
[YEARS]=@YEARS
,[DEPNAME]=@DEPNAME
,[TITLES]=@TITLES
,[SALES]=@SALES
,[NAMES]=@NAMES
,[KINDS]=@KINDS
,[PROMOTIONS]=@PROMOTIONS
,[PROMOTIONSSETS]=@PROMOTIONSSETS
,[SDATES]=@SDATES
,[CLIENTS]=@CLIENTS
,[STORES]=@STORES
,[SALESNUMS]=@SALESNUMS
,[SALESMONEYS]=@SALESMONEYS
,[PROFITS]=@PROFITS
,[COMMENTS]=@COMMENTS
,[COSTMONEYS]=@COSTMONEYS
,[FEEMONEYS]=@FEEMONEYS
,[ACTSALESMONEYS]=@ACTSALESMONEYS
,[ACTCOSTMONEYS]=@ACTCOSTMONEYS
,[ACTFEEMONEYS]=@ACTFEEMONEYS
,[ACTPROFITS]=@ACTPROFITS
WHERE [ID]= @ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@YEARS", YEARS);
m_db.AddParameter("@DEPNAME", DEPNAME);
m_db.AddParameter("@TITLES", TITLES);
m_db.AddParameter("@SALES", SALES);
m_db.AddParameter("@NAMES", NAMES);
m_db.AddParameter("@KINDS", KINDS);
m_db.AddParameter("@PROMOTIONS", PROMOTIONS);
m_db.AddParameter("@PROMOTIONSSETS", PROMOTIONSSETS);
m_db.AddParameter("@SDATES", SDATES);
m_db.AddParameter("@CLIENTS", CLIENTS);
m_db.AddParameter("@STORES", STORES);
m_db.AddParameter("@SALESNUMS", SALESNUMS);
m_db.AddParameter("@SALESMONEYS", SALESMONEYS);
m_db.AddParameter("@PROFITS", PROFITS);
m_db.AddParameter("@COMMENTS", COMMENTS);
m_db.AddParameter("@COSTMONEYS", COSTMONEYS);
m_db.AddParameter("@FEEMONEYS", FEEMONEYS);
m_db.AddParameter("@ACTSALESMONEYS", ACTSALESMONEYS);
m_db.AddParameter("@ACTCOSTMONEYS", ACTCOSTMONEYS);
m_db.AddParameter("@ACTFEEMONEYS", ACTFEEMONEYS);
m_db.AddParameter("@ACTPROFITS", ACTPROFITS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBSALESSCHEDULES(string ID, string DEALER, string OWNERS, string EVENTS, string MONTHS1, string MONTHS2, string MONTHS3, string MONTHS4, string MONTHS5, string MONTHS6, string MONTHS7, string MONTHS8, string MONTHS9, string MONTHS10, string MONTHS11, string MONTHS12)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKBUSINESS].[dbo].[TBSALESSCHEDULES]
SET [DEALER]=@DEALER,[OWNERS]=@OWNERS,[EVENTS]=@EVENTS,[MONTHS1]=@MONTHS1,[MONTHS2]=@MONTHS2,[MONTHS3]=@MONTHS3,[MONTHS4]=@MONTHS4,[MONTHS5]=@MONTHS5,[MONTHS6]=@MONTHS6,[MONTHS7]=@MONTHS7,[MONTHS8]=@MONTHS8,[MONTHS9]=@MONTHS9,[MONTHS10]=@MONTHS10,[MONTHS11]=@MONTHS11,[MONTHS12]=@MONTHS12
WHERE [ID]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@DEALER", DEALER);
m_db.AddParameter("@OWNERS", OWNERS);
m_db.AddParameter("@EVENTS", EVENTS);
m_db.AddParameter("@MONTHS1", MONTHS1);
m_db.AddParameter("@MONTHS2", MONTHS2);
m_db.AddParameter("@MONTHS3", MONTHS3);
m_db.AddParameter("@MONTHS4", MONTHS4);
m_db.AddParameter("@MONTHS5", MONTHS5);
m_db.AddParameter("@MONTHS6", MONTHS6);
m_db.AddParameter("@MONTHS7", MONTHS7);
m_db.AddParameter("@MONTHS8", MONTHS8);
m_db.AddParameter("@MONTHS9", MONTHS9);
m_db.AddParameter("@MONTHS10", MONTHS10);
m_db.AddParameter("@MONTHS11", MONTHS11);
m_db.AddParameter("@MONTHS12", MONTHS12);
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDTBSALESDEVMEMO(string ID, string SERNO, string STATUS, string CLIENT, string PROD, string PRICES, string PROMOTIONS, string SPEC, string VALID, string PLACES, string ONSALES, string ONSALESDATES, string PRODESGIN, string ASSESSMENTDATES, string COSTSDATES, string SALESPRICES, string TEST, string TESTDATES, string OWNER, string MEMO, string DEVMEMO, string SALESCHECKOK)
{
if (string.IsNullOrEmpty(ASSESSMENTDATES))
{
ASSESSMENTDATES = "1911/1/1";
}
if (string.IsNullOrEmpty(COSTSDATES))
{
COSTSDATES = "1911/1/1";
}
if (string.IsNullOrEmpty(TESTDATES))
{
TESTDATES = "1911/1/1";
}
if (string.IsNullOrEmpty(ONSALESDATES))
{
ONSALESDATES = "1911/1/1";
}
if (string.IsNullOrEmpty(SALESCHECKOK))
{
SALESCHECKOK = "1911/1/1";
}
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" INSERT INTO [TKRESEARCH].[dbo].[TBSALESDEVMEMO]
([STATUS],[CLIENT],[PROD],[PRICES],[PROMOTIONS],[SPEC],[VALID],[PLACES],[ONSALES],[ONSALESDATES],[PRODESGIN],[ASSESSMENTDATES],[COSTSDATES],[SALESPRICES],[TEST],[TESTDATES],[OWNER],[MEMO],[DEVMEMO],[SALESCHECKOK])
VALUES
(@STATUS,@CLIENT,@PROD,@PRICES,@PROMOTIONS,@SPEC,@VALID,@PLACES,@ONSALES,@ONSALESDATES,@PRODESGIN,@ASSESSMENTDATES,@COSTSDATES,@SALESPRICES,@TEST,@TESTDATES,@OWNER,@MEMO,@DEVMEMO,@SALESCHECKOK)
";
m_db.AddParameter("@STATUS", STATUS);
m_db.AddParameter("@CLIENT", CLIENT);
m_db.AddParameter("@PROD", PROD);
m_db.AddParameter("@PRICES", PRICES);
m_db.AddParameter("@PROMOTIONS", PROMOTIONS);
m_db.AddParameter("@SPEC", SPEC);
m_db.AddParameter("@VALID", VALID);
m_db.AddParameter("@PLACES", PLACES);
m_db.AddParameter("@ONSALES", ONSALES);
m_db.AddParameter("@ONSALESDATES", Convert.ToDateTime(ONSALESDATES));
m_db.AddParameter("@PRODESGIN", PRODESGIN);
m_db.AddParameter("@ASSESSMENTDATES", Convert.ToDateTime(ASSESSMENTDATES));
m_db.AddParameter("@COSTSDATES", Convert.ToDateTime(COSTSDATES));
m_db.AddParameter("@SALESPRICES", SALESPRICES);
m_db.AddParameter("@TEST", TEST);
m_db.AddParameter("@TESTDATES", Convert.ToDateTime(TESTDATES));
m_db.AddParameter("@OWNER", OWNER);
m_db.AddParameter("@MEMO", MEMO);
m_db.AddParameter("@DEVMEMO", DEVMEMO);
m_db.AddParameter("@SALESCHECKOK", SALESCHECKOK);
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDTBPROMOTIONNFEE(string YEARS, string SALES, string NAMES, string KINDS, string PROMOTIONS, string PROMOTIONSSETS, string SDATES, string CLIENTS, string STORES, string SALESNUMS, string SALESMONEYS, string COSTMONEYS, string FEEMONEYS, string PROFITS, string COMMENTS, string DEPNAME, string TITLES)
{
Label8.Text = "";
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
try
{
string cmdTxt = @"
INSERT INTO [TKBUSINESS].[dbo].[TBPROMOTIONNFEE]
([YEARS],[DEPNAME],[TITLES],[SALES],[NAMES],[KINDS],[PROMOTIONS],[PROMOTIONSSETS],[SDATES],[CLIENTS],[STORES],[SALESNUMS],[SALESMONEYS], [COSTMONEYS], [FEEMONEYS],[PROFITS],[COMMENTS])
VALUES
(@YEARS,@DEPNAME,@TITLES, @SALES, @NAMES, @KINDS, @PROMOTIONS, @PROMOTIONSSETS, @SDATES, @CLIENTS, @STORES, @SALESNUMS, @SALESMONEYS,@COSTMONEYS,@FEEMONEYS, @PROFITS, @COMMENTS)
";
m_db.AddParameter("@YEARS", YEARS);
m_db.AddParameter("@DEPNAME", DEPNAME);
m_db.AddParameter("@TITLES", TITLES);
m_db.AddParameter("@SALES", SALES);
m_db.AddParameter("@NAMES", NAMES);
m_db.AddParameter("@KINDS", KINDS);
m_db.AddParameter("@PROMOTIONS", PROMOTIONS);
m_db.AddParameter("@PROMOTIONSSETS", PROMOTIONSSETS);
m_db.AddParameter("@SDATES", SDATES);
m_db.AddParameter("@CLIENTS", CLIENTS);
m_db.AddParameter("@STORES", STORES);
m_db.AddParameter("@SALESNUMS", SALESNUMS);
m_db.AddParameter("@SALESMONEYS", SALESMONEYS);
m_db.AddParameter("@COSTMONEYS", COSTMONEYS);
m_db.AddParameter("@FEEMONEYS", FEEMONEYS);
m_db.AddParameter("@PROFITS", PROFITS);
m_db.AddParameter("@COMMENTS", COMMENTS);
m_db.ExecuteNonQuery(cmdTxt);
Label8.Text = "成功";
}
catch
{
Label8.Text = "新增失敗";
}
finally
{
}
}
public void UPDATETBSALESDEV(string SERNO, string STATUS, string CLIENT, string SALES, string PROD, string SPEC, string VALID, string PRICES, string PROMOTIONS, string PLACES, string ONSALES, string ONSALESDATES, string DESIGNS, string SALESHISTORYS, string DEVHISTORYS)
{
if (string.IsNullOrEmpty(ONSALESDATES))
{
ONSALESDATES = "1911/1/1";
}
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKRESEARCH].[dbo].[TBSALESDEV]
SET [STATUS]=@STATUS
,[CLIENT]=@CLIENT
,[SALES]=@SALES
,[PROD]=@PROD
,[SPEC]=@SPEC
,[VALID]=@VALID
,[PRICES]=@PRICES
,[PROMOTIONS]=@PROMOTIONS
,[PLACES]=@PLACES
,[ONSALES]=@ONSALES
,[ONSALESDATES]=@ONSALESDATES
,[DESIGNS]=@DESIGNS
,[SALESHISTORYS]=@SALESHISTORYS
,[DEVHISTORYS]=@DEVHISTORYS
WHERE[SERNO]=@SERNO
";
m_db.AddParameter("@SERNO", SERNO);
m_db.AddParameter("@STATUS", STATUS);
m_db.AddParameter("@CLIENT", CLIENT);
m_db.AddParameter("@SALES", SALES);
m_db.AddParameter("@PROD", PROD);
m_db.AddParameter("@SPEC", SPEC);
m_db.AddParameter("@VALID", VALID);
m_db.AddParameter("@PRICES", PRICES);
m_db.AddParameter("@PROMOTIONS", PROMOTIONS);
m_db.AddParameter("@PLACES", PLACES);
m_db.AddParameter("@ONSALES", ONSALES);
m_db.AddParameter("@ONSALESDATES", Convert.ToDateTime(ONSALESDATES));
m_db.AddParameter("@DESIGNS", DESIGNS);
m_db.AddParameter("@SALESHISTORYS", SALESHISTORYS);
m_db.AddParameter("@DEVHISTORYS", DEVHISTORYS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDTBSALESEVENTS(string SALES, string KINDS, string PROJECTS, string EVENTS, string CLIENTS, string SDAYS, string EDAYS, string COMMENTS, string ISCLOSE, string FILENAME)
{
Label8.Text = "";
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
try
{
string cmdTxt = @"
INSERT INTO [TKBUSINESS].[dbo].[TBSALESEVENTS]
([SALES],[KINDS],[CLIENTS],[PROJECTS],[EVENTS],[SDAYS],[EDAYS],[COMMENTS],[ISCLOSE],[FILENAME],[ADDDATES],[UPDATEDATES] )
VALUES
(@SALES,@KINDS,@CLIENTS,@PROJECTS,@EVENTS,@SDAYS,@EDAYS,@COMMENTS,@ISCLOSE,@FILENAME,@ADDDATES,@UPDATEDATES)
";
m_db.AddParameter("@SALES", SALES);
m_db.AddParameter("@KINDS", KINDS);
m_db.AddParameter("@CLIENTS", CLIENTS);
m_db.AddParameter("@PROJECTS", PROJECTS);
m_db.AddParameter("@EVENTS", EVENTS);
m_db.AddParameter("@SDAYS", SDAYS);
m_db.AddParameter("@EDAYS", EDAYS);
m_db.AddParameter("@COMMENTS", COMMENTS);
m_db.AddParameter("@ISCLOSE", ISCLOSE);
m_db.AddParameter("@FILENAME", FILENAME);
m_db.AddParameter("@ADDDATES", Convert.ToDateTime(DateTime.Now));
m_db.AddParameter("@UPDATEDATES", Convert.ToDateTime(DateTime.Now));
m_db.ExecuteNonQuery(cmdTxt);
Label8.Text = "成功";
TBSALESEVENTSMAXID = SEARCHTBSALESEVENTSID(SALES + CLIENTS + PROJECTS + EVENTS + COMMENTS);
}
catch
{
Label8.Text = "新增失敗";
}
finally
{
}
}
public void UPDATETBDEVMEMO(string PID, string MEMO)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" UPDATE [TKRESEARCH].[dbo].[TBDEVMEMO]
SET [MEMO]=@MEMO
WHERE [ID]=@ID
";
m_db.AddParameter("@ID", PID);
m_db.AddParameter("@MEMO", MEMO);
m_db.ExecuteNonQuery(cmdTxt);
}
public void DELETETBPROMOTIONNFEEPRODUCTS(string MID, string ID)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
DELETE [TKBUSINESS].[dbo].[TBPROMOTIONNFEEPRODUCTS]
WHERE MID=@MID AND ID=@ID
";
m_db.AddParameter("@MID", MID);
m_db.AddParameter("@ID", ID);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBSALESDEVMEMO(string PID, string DEVMEMO)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" UPDATE [TKRESEARCH].[dbo].[TBSALESDEVMEMO]
SET [DEVMEMO]=@DEVMEMO,[DEVMEMODATES]=@DEVMEMODATES
WHERE [ID]=@ID
";
m_db.AddParameter("@ID", PID);
m_db.AddParameter("@DEVMEMO", DEVMEMO);
m_db.AddParameter("@DEVMEMODATES", Convert.ToDateTime(DateTime.Now));
m_db.ExecuteNonQuery(cmdTxt);
}
public void DELTBSALESDEVMEMO(string SERNO)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" DELETE [TKRESEARCH].[dbo].[TBPROJECT] WHERE[SERNO]=@SERNO
";
m_db.AddParameter("@SERNO", SERNO);
m_db.ExecuteNonQuery(cmdTxt);
Dialog.SetReturnValue2("NeedPostBack");
Dialog.Close(this);
}
public void UPDATETBSALESDEV(string SERNO, string DEVHISTORYS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" UPDATE [TKRESEARCH].[dbo].[TBSALESDEV]
SET [DEVHISTORYS]=@DEVHISTORYS
WHERE [SERNO]=@SERNO
";
m_db.AddParameter("@SERNO", SERNO);
m_db.AddParameter("@DEVHISTORYS", DEVHISTORYS);
m_db.ExecuteNonQuery(cmdTxt);
}
public void DELTBSALESEVENTS(string ID)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" DELETE [TKBUSINESS].[dbo].[TBSALESEVENTS] WHERE [ID]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.ExecuteNonQuery(cmdTxt);
Dialog.SetReturnValue2("NeedPostBack");
Dialog.Close(this);
}
public void UPDATETBDEVNEW(string SERNO, string TESTMEMO)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" UPDATE [TKRESEARCH].[dbo].[TBDEVNEW]
SET [TESTMEMO]=@TESTMEMO,[TESTDATES]=@TESTDATES
WHERE [SERNO]=@SERNO
";
m_db.AddParameter("@SERNO", SERNO);
m_db.AddParameter("@TESTMEMO", TESTMEMO);
m_db.AddParameter("@TESTDATES", Convert.ToDateTime(DateTime.Now));
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBPROJECTS(string ID, string NO, string SUBJECT, string CREATE_NEME, string CREATE_DEP, string CREATE_TIME, string STATUS, string CONTENTS, string PUCLOSE_TIME, string HADNUMS, string HADCONTENTS, string NOWNUMS, string TOTALNUMS, string CLOSE_CONTENTS, string CLOSE_TIME)
{
if (string.IsNullOrEmpty(CREATE_TIME))
{
CREATE_TIME = "1911/1/1";
}
if (string.IsNullOrEmpty(PUCLOSE_TIME))
{
PUCLOSE_TIME = "1911/1/1";
}
if (string.IsNullOrEmpty(CLOSE_TIME))
{
CLOSE_TIME = "1911/1/1";
}
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKQC].[dbo].[TBPROJECTS]
SET [SUBJECT]=@SUBJECT,[CREATE_NEME]=@CREATE_NEME,[CREATE_DEP]=@CREATE_DEP,[CREATE_TIME]=@CREATE_TIME,[STATUS]=@STATUS,[CONTENTS]=@CONTENTS,[PUCLOSE_TIME]=@PUCLOSE_TIME,[HADNUMS]=@HADNUMS,[HADCONTENTS]=@HADCONTENTS,[NOWNUMS]=@NOWNUMS,[TOTALNUMS]=@TOTALNUMS,[CLOSE_CONTENTS]=@CLOSE_CONTENTS,[CLOSE_TIME]=@CLOSE_TIME
WHERE [NO]=@NO
";
m_db.AddParameter("@NO", NO);
m_db.AddParameter("@SUBJECT", SUBJECT);
m_db.AddParameter("@CREATE_NEME", CREATE_NEME);
m_db.AddParameter("@CREATE_DEP", CREATE_DEP);
m_db.AddParameter("@CREATE_TIME", CREATE_TIME);
m_db.AddParameter("@STATUS", STATUS);
m_db.AddParameter("@CONTENTS", CONTENTS);
m_db.AddParameter("@PUCLOSE_TIME", PUCLOSE_TIME);
m_db.AddParameter("@HADNUMS", HADNUMS);
m_db.AddParameter("@HADCONTENTS", HADCONTENTS);
m_db.AddParameter("@NOWNUMS", NOWNUMS);
m_db.AddParameter("@TOTALNUMS", TOTALNUMS);
m_db.AddParameter("@CLOSE_CONTENTS", CLOSE_CONTENTS);
m_db.AddParameter("@CLOSE_TIME", CLOSE_TIME);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBCOPCONDTIONS(string ID, string MA001, string MA002, string CONTACTPERSON, string TEL1, string EMAILS, string ISPURATTCH, string ISCOPATTCH, string ISSHOWMONEYS, string ISINVOICES, string ISSHIPMARK, string LIMITDAYS, string PAYMENT, string SENDADDRESS, string COMMENT)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKBUSINESS].[dbo].[COPCONDTIONS]
SET MA001=@MA001
,MA002=@MA002
,CONTACTPERSON=@CONTACTPERSON
,TEL1=@TEL1
,EMAILS=@EMAILS
,ISPURATTCH=@ISPURATTCH
,ISCOPATTCH=@ISCOPATTCH
,ISSHOWMONEYS=@ISSHOWMONEYS
,ISINVOICES=@ISINVOICES
,ISSHIPMARK=@ISSHIPMARK
,LIMITDAYS=@LIMITDAYS
,PAYMENT=@PAYMENT
,SENDADDRESS=@SENDADDRESS
,COMMENT=@COMMENT
WHERE [ID]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@MA001", MA001);
m_db.AddParameter("@MA002", MA002);
m_db.AddParameter("@CONTACTPERSON", CONTACTPERSON);
m_db.AddParameter("@TEL1", TEL1);
m_db.AddParameter("@EMAILS", EMAILS);
m_db.AddParameter("@ISPURATTCH", ISPURATTCH);
m_db.AddParameter("@ISCOPATTCH", ISCOPATTCH);
m_db.AddParameter("@ISSHOWMONEYS", ISSHOWMONEYS);
m_db.AddParameter("@ISINVOICES", ISINVOICES);
m_db.AddParameter("@ISSHIPMARK", ISSHIPMARK);
m_db.AddParameter("@LIMITDAYS", LIMITDAYS);
m_db.AddParameter("@PAYMENT", PAYMENT);
m_db.AddParameter("@SENDADDRESS", SENDADDRESS);
m_db.AddParameter("@COMMENT", COMMENT);
m_db.ExecuteNonQuery(cmdTxt);
}
public void UPDATETBSAMPLE(string ID, string COMMENTS, DateTime UPDATEDATES)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
UPDATE [TKRESEARCH].[dbo].[TBSAMPLE]
SET [COMMENTS]=@COMMENTS,[UPDATEDATES]=@UPDATEDATES
WHERE [ID]=@ID
";
m_db.AddParameter("@ID", ID);
m_db.AddParameter("@COMMENTS", COMMENTS);
m_db.AddParameter("@UPDATEDATES", Convert.ToDateTime(DateTime.Now));
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDPRODUCTS(string MB001, string PRODUCTSFEATURES, string SALESFOCUS, string COPYWRITINGS, string PRICES1, string PRICES2, string PRICES3, string MOQS)
{
Label8.Text = "";
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
try
{
string cmdTxt = @"
INSERT INTO [TKBUSINESS].[dbo].[PRODUCTS]
([MB001],[PRODUCTSFEATURES],[SALESFOCUS],[COPYWRITINGS],[PRICES1],[PRICES2],[PRICES3],[MOQS])
VALUES
(@MB001,@PRODUCTSFEATURES,@SALESFOCUS,@COPYWRITINGS,@PRICES1,@PRICES2,@PRICES3,@MOQS)
";
m_db.AddParameter("@MB001", MB001);
m_db.AddParameter("@PRODUCTSFEATURES", PRODUCTSFEATURES);
m_db.AddParameter("@SALESFOCUS", SALESFOCUS);
m_db.AddParameter("@COPYWRITINGS", COPYWRITINGS);
m_db.AddParameter("@PRICES1", PRICES1);
m_db.AddParameter("@PRICES2", PRICES2);
m_db.AddParameter("@PRICES3", PRICES3);
m_db.AddParameter("@MOQS", MOQS);
m_db.ExecuteNonQuery(cmdTxt);
Label8.Text = "成功";
}
catch
{
Label8.Text = "新增失敗";
}
finally
{
}
}
public void ADDTBDEVMEMOHISTORY(string PID, string PROD, string MEMO)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" INSERT INTO [TKRESEARCH].[dbo].[TBDEVMEMOHISTORY]
([ID],[PID],[MEMODATES],[PROD],[MEMO])
VALUES (@ID,@PID,@MEMODATES,@PROD,@MEMO)
";
m_db.AddParameter("@ID", Guid.NewGuid());
m_db.AddParameter("@PID", PID);
m_db.AddParameter("@MEMODATES", Convert.ToDateTime(DateTime.Now));
m_db.AddParameter("@PROD", PROD);
m_db.AddParameter("@MEMO", MEMO);
m_db.ExecuteNonQuery(cmdTxt);
}
public void ADDTBPROJECTSSALES(string YEARS, string WEEKS, string STORES, string NAMES, string DAYS, string TARGETS, string FEES, string ITEMS)
{
Label8.Text = "";
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
try
{
string cmdTxt = @"
INSERT INTO [TKBUSINESS].[dbo].[TBPROJECTSSALES]
([YEARS],[WEEKS],[DAYS],[STORES],[NAMES],[TARGETS],[FEES],[ITEMS])
VALUES
(@YEARS,@WEEKS,@DAYS,@STORES,@NAMES,@TARGETS,@FEES,@ITEMS)
";
m_db.AddParameter("@YEARS", YEARS);
m_db.AddParameter("@WEEKS", WEEKS);
m_db.AddParameter("@STORES", STORES);
m_db.AddParameter("@NAMES", NAMES);
m_db.AddParameter("@DAYS", DAYS);
m_db.AddParameter("@TARGETS", TARGETS);
m_db.AddParameter("@FEES", FEES);
m_db.AddParameter("@ITEMS", ITEMS);
m_db.ExecuteNonQuery(cmdTxt);
Label8.Text = "成功";
}
catch
{
Label8.Text = "新增失敗";
}
finally
{
}
}
public void ADDTBPROJECTSMEMO(string SNO, string SUBJECT, string MEMOS)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" INSERT INTO [TKQC].[dbo].[TBPROJECTSMEMO]
([ID],[SNO],[SUBJECT],[CREATEDATES],[MEMOS])
VALUES (@ID,@SNO,@SUBJECT,@CREATEDATES,@MEMOS)
";
m_db.AddParameter("@ID", Guid.NewGuid());
m_db.AddParameter("@SNO", SNO);
m_db.AddParameter("@SUBJECT", SUBJECT);
m_db.AddParameter("@CREATEDATES", Convert.ToDateTime(DateTime.Now));
m_db.AddParameter("@MEMOS", MEMOS);
m_db.ExecuteNonQuery(cmdTxt);
}
