62,244
社区成员




StringBuilder sbSql = new StringBuilder();
sbSql.Append(@"insert into vw_member_info_web
(
MEM_NAME,
PASSWORD,
SEX,
MOBILE,
LIC_TYPE_ID,
LIC_NO,HOME_PHONE,
MAIL,
ZIP,
DETAIL_ADDR,
DVR_LIC_NO,
REG_MODE,
RECOMMEND_NAME,
KNOW_MODE_DESC,
CRE_USER,
CRE_USER_ID");
if (!string.IsNullOrEmpty(getDrivLiceDay))
{
sbSql.Append(",DVR_LIC_BGN_DATE");
}
if (!string.IsNullOrEmpty(birthday))
{
sbSql.Append(",BIRTHDAY");
}
sbSql.Append(@")
values
(
:userName,
:pwd,
:sex,
:mobile,
:cretType,
:cretNo,:fixedPhone,
:mail,
:postCode,
:address,
:dvrLicNo,
:reg_mode,
:recomName,
:knowDesc,
:cre_user,
:cre_user_id");
if (!string.IsNullOrEmpty(getDrivLiceDay))
{
sbSql.Append(",:dvrLicDate");
}
if (!string.IsNullOrEmpty(birthday))
{
sbSql.Append(",:birthday");
}
sbSql.Append(")");
OracleParameter[] prams = {
new OracleParameter(":userName", userName),
new OracleParameter(":pwd", pwd),
new OracleParameter(":sex", sex),
new OracleParameter(":mobile", mobileNo),
new OracleParameter(":cretType", GetLicType(cretType)),
new OracleParameter(":cretNo", cretNo),
new OracleParameter(":fixedPhone", fixedPhone),
new OracleParameter(":mail", email),
new OracleParameter(":postCode", postCode),
new OracleParameter(":address", contactAdd),
new OracleParameter(":dvrLicNo", drivLicense),
new OracleParameter(":recomName", referee),
new OracleParameter(":knowDesc", couponCode),
new OracleParameter(":reg_mode", "网站注册"),
new OracleParameter(":cre_user","网站"),
new OracleParameter(":cre_user_id","134")
};
OracleParameter[] prams = listPrams.ToArray();//关键是我忘记了List的ToArray()方法