- 博客(0)
- 资源 (1)
空空如也
C#隐藏任务栏目
C#隐藏任务栏 经过测试肯定可用string sql = "INSERT INTO T6_ALIPAY_FOCUS (SERVICEWINDOWID,APPID,OPENID,CREATE_UID,CREATE_DT,MODIFY_UID,MODIFY_DT) VALUES ((SELECT DECODE(MAX(SERVICEWINDOWID), null, 1, MAX(SERVICEWINDOWID) + 1) FROM T6_ALIPAY_FOCUS),:APPID,:OPENID,:CREATE_UID,:CREATE_DT,:MODIFY_UID,:MODIFY_DT)";
OracleParameter[] param = {
new OracleParameter(":APPID",OracleType.VarChar),
new OracleParameter(":OPENID",OracleType.VarChar),
new OracleParameter(":CREATE_UID",OracleType.Number),
new OracleParameter(":CREATE_DT",OracleType.DateTime),
new OracleParameter(":MODIFY_UID",OracleType.Number),
new OracleParameter(":MODIFY_DT",OracleType.DateTime)
};
param[0].Value = model.APPID;
param[1].Value = model.OPENID;
param[2].Value = model.CREATE_UID;
param[3].Value = model.CREATE_DT;
param[4].Value = model.MODIFY_UID;
param[5].Value = model.MODIFY_DT;
try
{
if (trans == null)
return dbProvider.ExecuteNonQuery(sql, param);
else
return dbProvider.ExecuteNonQuery((OracleTransaction)trans, CommandType.Text, sql, param);
}
catch (Exception ex)
{
throw ex;
}
2016-01-11
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人