17,078
社区成员
发帖
与我相关
我的任务
分享
insertSql = "insert into DemarcateFile(ID,Name,DFValue,ImportTime) values(fordemarcatefile.nextval,'"+demarcateFile.Name+"',"+demarcateFile.DFValue+","+"to_date('"+demarcateFile.ImportTime.ToString()+ "','yyyy-mm-dd hh24:mi:ss')"+")";
string insertSql =
"insert into DemarcateFile(ID,Name,CPID,Edition,EditionComment,IsActive,DFVaue,Operator,ImportTime,\"comment\") values(@0,@1,@2,@3,@4,@5,@6,@7,@8,@9)";
using (OleSql oleSql = new OleSql(conn))
{
OleDbParameter[] parameters = new OleDbParameter[10];
parameters[0] = new OleDbParameter("@0", "fordemarcatefile.nextval");
parameters[1] = new OleDbParameter("@1", demarcateFile.Name);
parameters[2] = new OleDbParameter("@2", demarcateFile.CPID);
parameters[3] = new OleDbParameter("@3", demarcateFile.Edtion);
parameters[4] = new OleDbParameter("@4", demarcateFile.EditonComment);
parameters[5] = new OleDbParameter("@5", demarcateFile.IsActive);
parameters[6] = new OleDbParameter("@6", (byte[])demarcateFile.DFValue);
parameters[7] = new OleDbParameter("@7", demarcateFile.Operator);
parameters[8] = new OleDbParameter("@8", demarcateFile.ImportTime);
parameters[9] = new OleDbParameter("@9", demarcateFile.Comment);
oleSql.Execute(insertSql, parameters);
insertID = demarcateFile.ID;
}
string insertSql =
"insert into DemarcateFile(ID,Name,CPID,Edition,EditionComment,IsActive,DFVaue,Operator,ImportTime,\"comment\") values(@0,@1,@2,@3,@4,@5,@6,@7,@8,@9)";
//string insertSql = "insert into DemarcateFile(ID,Name,CPID,Edition,EditionComment,IsActive,DFValue,Operator,ImportTime,\"comment\") values(fordemarcatefile.nextval,'"+demarcateFile.Name+"',"+demarcateFile.CPID+",'"+demarcateFile.Edtion+"','"+demarcateFile.EditonComment+"','"+demarcateFile.IsActive.ToString()+"',"+demarcateFile.DFValue+",'"+demarcateFile.Operator+"',"+"to_date('"+demarcateFile.ImportTime.ToString()+ "','yyyy-mm-dd hh24:mi:ss')"+",'"+demarcateFile.Comment+"')";
using (OleSql oleSql = new OleSql(conn))
{
OleDbParameter[] parameters = new OleDbParameter[10];
parameters[0] = new OleDbParameter("@0", "fordemarcatefile.nextval");
parameters[1] = new OleDbParameter("@1", demarcateFile.Name);
parameters[2] = new OleDbParameter("@2", demarcateFile.CPID);
parameters[3] = new OleDbParameter("@3", demarcateFile.Edtion);
parameters[4] = new OleDbParameter("@4", demarcateFile.EditonComment);
parameters[5] = new OleDbParameter("@5", demarcateFile.IsActive);
parameters[6] = new OleDbParameter("@6", (byte[])demarcateFile.DFValue);
parameters[7] = new OleDbParameter("@7", demarcateFile.Operator);
parameters[8] = new OleDbParameter("@8", demarcateFile.ImportTime);
parameters[9] = new OleDbParameter("@9", demarcateFile.Comment);
oleSql.Execute(insertSql, parameters);
//oleSql.Execute(insertSql);
insertID = demarcateFile.ID;
}
string insertSql =
"insert into DemarcateFile(ID,Name,CPID,Edition,EditionComment,IsActive,DFVaue,Operator,ImportTime,\"comment\") values(fordemarcatefile.nextval,@1,@2,@3,@4,@5,@6,@7,@8,@9)";
//string insertSql = "insert into DemarcateFile(ID,Name,CPID,Edition,EditionComment,IsActive,DFValue,Operator,ImportTime,\"comment\") values(fordemarcatefile.nextval,'"+demarcateFile.Name+"',"+demarcateFile.CPID+",'"+demarcateFile.Edtion+"','"+demarcateFile.EditonComment+"','"+demarcateFile.IsActive.ToString()+"',"+demarcateFile.DFValue+",'"+demarcateFile.Operator+"',"+"to_date('"+demarcateFile.ImportTime.ToString()+ "','yyyy-mm-dd hh24:mi:ss')"+",'"+demarcateFile.Comment+"')";
using (OleSql oleSql = new OleSql(conn))
{
OleDbParameter[] parameters = new OleDbParameter[9];
parameters[0] = new OleDbParameter("@1", demarcateFile.Name);
parameters[1] = new OleDbParameter("@2", demarcateFile.CPID);
parameters[2] = new OleDbParameter("@3", demarcateFile.Edtion);
parameters[3] = new OleDbParameter("@4", demarcateFile.EditonComment);
parameters[4] = new OleDbParameter("@5", demarcateFile.IsActive);
parameters[5] = new OleDbParameter("@6", demarcateFile.DFValue);
parameters[6] = new OleDbParameter("@7", demarcateFile.Operator);
parameters[7] = new OleDbParameter("@8", demarcateFile.ImportTime);
parameters[8] = new OleDbParameter("@9", demarcateFile.Comment);
oleSql.Execute(insertSql, parameters);
//oleSql.Execute(insertSql);
insertID = demarcateFile.ID;
}
insert into DemarcateFile(ID,Name,CPID,Edition,EditionComment,IsActive,DFVaue,Op
erator,ImportTime,"comment") values(fordemarcatefile.nextval,'107 394 01 11.HEX'
,1,'2','','True',System.Byte[],'Administrator',to_date('2008-8-25 11:05:10','yyy
y-mm-dd hh24:mi:ss'),'无')
insert into DemarcateFile(ID,Name,CPID,Edition,EditionComment,IsActive,Oper
ator,ImportTime,"comment") values(fordemarcatefile.nextval,'107 394 01 11.HEX',1
,'2','','True','Administrator',to_date('2008-8-25 11:05:10','yyyy-mm-dd hh24:mi:
ss'),'无');