下面这段是什么意思啊!
SqlParameter[] parameters = {
new SqlParameter("@_DanWeiBianHao",this.TextBoxaa.Text.ToString().Trim()),
new SqlParameter("@_StartTime",DateTime.Parse(DDLNianDu1.QsNianDu)),
new SqlParameter("@_EndTime",DateTime.Parse(DDLNianDu1.JzNianDu)),
new SqlParameter("@_condition",ViewState["TiaoJian"].ToString()),
new SqlParameter("@_kind","1"),
new SqlParameter("@MyNianDu",this.DDLNianDu1.MyNianDu)
};
SqlParameter[] parameters = {
new SqlParameter("@_DanWeiBianHao",this.TextBoxaa.Text.ToString().Trim()),
new SqlParameter("@_StartTime",DateTime.Parse(DDLNianDu1.QsNianDu)),
new SqlParameter("@_EndTime",DateTime.Parse(DDLNianDu1.JzNianDu)),
new SqlParameter("@_condition",ViewState["TiaoJian"].ToString()),
new SqlParameter("@_kind","1"),
new SqlParameter("@MyNianDu",this.DDLNianDu1.MyNianDu)
};
SqlParameter()方法的第一个参数是参数的名称,第二个是参数的值。
{
int insertID = 0;
string insertSql = "insert into CarConfiguration(Name,CollateStatus,CollateComment,AuditingStatus,AuditingComment,DFID,EngineModel,VehicelModel,Idle,KTKZMS,QDJKZMS,PQZDMK,DZYMTBCJ,XHGN,PTOGN,RYYSBJGN,BSXXH,HQSB,LTGG,CSXHHQFS,FDJZSSCFS,SWSCFS,JYYLSCFS,SFDCANZX,JQJRMK,CJQDTZGN,Comment) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
using (Gongfang.Data.OleSql oleSql = new OleSql(conn))
{
System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[27];
parameters[0] = new System.Data.OleDb.OleDbParameter("@1", carConfiguration.Name);
parameters[1] = new System.Data.OleDb.OleDbParameter("@2", carConfiguration.CollateStatus);
parameters[2] = new System.Data.OleDb.OleDbParameter("@3", carConfiguration.CollateComment);
parameters[3] = new System.Data.OleDb.OleDbParameter("@4", carConfiguration.AuditingStatus);
parameters[4] = new System.Data.OleDb.OleDbParameter("@5", carConfiguration.AuditingComment);
parameters[5] = new System.Data.OleDb.OleDbParameter("@6", carConfiguration.DFID);
parameters[6] = new System.Data.OleDb.OleDbParameter("@7", carConfiguration.EngineModel);
parameters[7] = new System.Data.OleDb.OleDbParameter("@8", carConfiguration.VehicelModel);
parameters[8] = new System.Data.OleDb.OleDbParameter("@9", carConfiguration.Idle);
parameters[9] = new System.Data.OleDb.OleDbParameter("@10", carConfiguration.KTKZMS);
parameters[10] = new System.Data.OleDb.OleDbParameter("@11", carConfiguration.QDJKZMS);
parameters[11] = new System.Data.OleDb.OleDbParameter("@12", carConfiguration.PQZDMK);
parameters[12] = new System.Data.OleDb.OleDbParameter("@13", carConfiguration.DZYMTBCJ);
parameters[13] = new System.Data.OleDb.OleDbParameter("@14", carConfiguration.XHGN);
parameters[14] = new System.Data.OleDb.OleDbParameter("@15", carConfiguration.PTOGN);
parameters[15] = new System.Data.OleDb.OleDbParameter("@16", carConfiguration.RYYSBJGN);
parameters[16] = new System.Data.OleDb.OleDbParameter("@17", carConfiguration.BSXXH);
parameters[17] = new System.Data.OleDb.OleDbParameter("@18", carConfiguration.HQSB);
parameters[18] = new System.Data.OleDb.OleDbParameter("@19", carConfiguration.LTGG);
parameters[19] = new System.Data.OleDb.OleDbParameter("@20", carConfiguration.CSXHHQFS);
parameters[20] = new System.Data.OleDb.OleDbParameter("@21", carConfiguration.FDJZSSCFS);
parameters[21] = new System.Data.OleDb.OleDbParameter("@22", carConfiguration.SWSCFS);
parameters[22] = new System.Data.OleDb.OleDbParameter("@23", carConfiguration.JYYLSCFS);
parameters[23] = new System.Data.OleDb.OleDbParameter("@24", carConfiguration.SFDCANZX);
parameters[24] = new System.Data.OleDb.OleDbParameter("@25", carConfiguration.JQJRMK);
parameters[25] = new System.Data.OleDb.OleDbParameter("@26", carConfiguration.CJQDTZGN);
parameters[26] = new System.Data.OleDb.OleDbParameter("@27", carConfiguration.Comment);
oleSql.Execute(insertSql, parameters); }
}