本文整理汇总了C#中System.Data.Common.DbTransaction类的典型用法代码示例。如果您正苦于以下问题:C# DbTransaction类的具体用法?C# DbTransaction怎么用?C# DbTransaction使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DbTransaction类属于System.Data.Common命名空间,在下文中一共展示了DbTransaction类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DeleteRoleRightsByRoleId
public bool DeleteRoleRightsByRoleId(Role roles, Database db, DbTransaction transaction)
{
DbCommand dbCommand = db.GetStoredProcCommand("usp_RoleRightDelete");
db.AddInParameter(dbCommand, "RoleId", DbType.Guid, roles.RoleId);
db.ExecuteNonQuery(dbCommand, transaction);
return true;
}
示例2: doCreate
/// <summary>
/// 新增基本檔資料(使用交易)
/// </summary>
/// <param name="htParams">放入輸入的參數</param>
/// <param name="DBT">交易變數</param>
/// <returns>回傳影響筆數</returns>
public void doCreate(Hashtable htParams,
DbTransaction DBT
)
{
try
{
DbCommand cmd = db.GetStoredProcCommand("PKG_VDS_ALO_PATTERNSPEC_DETL.ADD_PATTERNSPEC_DETL");
db.AddInParameter(cmd, "ID", DbType.VarNumeric, htParams["ID"]);
db.AddInParameter(cmd, "PID", DbType.VarNumeric, htParams["PID"]);
db.AddInParameter(cmd, "vCreateDate", DbType.Date, htParams["CREATEDATE"]);
db.AddInParameter(cmd, "vCreateUID", DbType.String, htParams["CREATEUID"]);
db.AddInParameter(cmd, "vUpdateDate", DbType.Date, htParams["UPDATEDATE"]);
db.AddInParameter(cmd, "vUpdateUID", DbType.String, htParams["UPDATEUID"]);
db.AddInParameter(cmd, "nSTART_RANKQTY", DbType.VarNumeric, htParams["START_RANKQTY"]);
db.AddInParameter(cmd, "nEND_RANKQTY", DbType.VarNumeric, htParams["END_RANKQTY"]);
db.AddInParameter(cmd, "nADJ_QTY", DbType.VarNumeric, htParams["ADJ_QTY"]);
int ProcessRecord = (DBT == null) ? db.ExecuteNonQuery(cmd) : db.ExecuteNonQuery(cmd, DBT);
if (ProcessRecord == 0)
{
throw new Exception("輸入資料失敗!");
}
}
catch (Exception ex)
{
throw new Exception("呼叫VDS_ALO_PATTERNSPEC_DETL_DBO.doCreate()發生錯誤,錯誤訊息:"
+ OracleExceptionProcess.OracleExceptionStringCut(ex.Message));
}
}
示例3: Insert
public bool Insert(Option Option, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_OptionInsert");
db.AddInParameter(command, "Name", DbType.String, Option.Name);
db.AddInParameter(command, "Description", DbType.String, Option.Description);
db.AddInParameter(command, "OptionCategoryId", DbType.Int16, Option.OptionCategoryId);
db.AddInParameter(command, "ParentOptionId", DbType.Int16, Option.ParentOptionId);
db.AddInParameter(command, "IsDeleted", DbType.Boolean, Option.IsDeleted);
db.AddInParameter(command, "IsMultiSelect", DbType.Boolean, Option.IsMultiSelect);
db.AddInParameter(command, "Points", DbType.Int16, Option.Points);
db.AddOutParameter(command, "OptionId", DbType.Int16, 3);
if (transaction == null)
{
db.ExecuteNonQuery(command);
}
else
{
db.ExecuteNonQuery(command, transaction);
}
Option.OptionId = Convert.ToInt16(db.GetParameterValue(command, "OptionId").ToString());
return true;
}
示例4: CategoryDelete
/// <summary>
/// ���� ɾ��
/// </summary>
/// <param name="id">Id ���</param>
/// <returns>ִ�н��</returns>
public int CategoryDelete(out string resultMsg, Int32 id, DbTransaction tran = null)
{
resultMsg = string.Empty;
int res = 0;
try
{
//�洢��������
string sql = "usp_category_delete_by_id";
//�������
IList<DBParameter> parm = new List<DBParameter>();
parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
//parm.Add(new DBParameter() { ParameterName = "resultMsg", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.String });
//����ִ��
res = DBHelper.ExecuteNonQuery(sql, true, parm, tran);
//foreach (var item in parm)
//{
// //��ȡ�������ֵ
// if (item.ParameterName == "resultMsg")
// {
// resultMsg = item.ParameterValue.ToString();
// break;
// }
//}
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return res;
}
示例5: DiscoverSpParameterSet
/// <summary>
/// Resolve at run time the appropriate set of DbParameters for a stored procedure
/// </summary>
/// <param name="transaction">A valid SqlTransaction object</param>
/// <param name="connection">A valid SqlConnection object</param>
/// <param name="storedProcedureName">The name of the stored procedure</param>
/// <param name="includeReturnValueParameter">Whether or not to include their return value parameter</param>
/// <returns>The parameter array discovered.</returns>
private static IList<SqlParameter> DiscoverSpParameterSet(DbTransaction transaction, DbConnection connection, string storedProcedureName, bool includeReturnValueParameter)
{
using (SqlCommand cmd = new SqlCommand(storedProcedureName, connection as SqlConnection))
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
cmd.CommandType = CommandType.StoredProcedure;
if (transaction != null)
{
cmd.Transaction = transaction as SqlTransaction;
}
SqlCommandBuilder.DeriveParameters(cmd);
if (!includeReturnValueParameter)
{
cmd.Parameters.RemoveAt(0);
}
SqlParameter[] discoveredParameters = new SqlParameter[cmd.Parameters.Count];
cmd.Parameters.CopyTo(discoveredParameters, 0);
return discoveredParameters;
}
}
示例6: AddReviewBillContent
/// <summary>
/// 添加审稿单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddReviewBillContent(ReviewBillContentEntity model, DbTransaction trans = null)
{
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @CID");
sqlCommandText.Append(", @JournalID");
sqlCommandText.Append(", @ItemID");
sqlCommandText.Append(", @ContentValue");
sqlCommandText.Append(", @IsChecked");
sqlCommandText.Append(", @AddUser");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.ReviewBillContent ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@ItemContentID", DbType.Int64, model.ItemContentID);
db.AddInParameter(cmd, "@CID", DbType.Int64, model.CID);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID);
db.AddInParameter(cmd, "@ItemID", DbType.AnsiString, model.ItemID);
db.AddInParameter(cmd, "@ContentValue", DbType.AnsiString, model.ContentValue);
db.AddInParameter(cmd, "@IsChecked", DbType.Boolean, model.IsChecked);
db.AddInParameter(cmd, "@AddUser", DbType.Int64, model.AddUser);
try
{
bool result = false;
if (trans == null)
result = db.ExecuteNonQuery(cmd) > 0;
else
result = db.ExecuteNonQuery(cmd, trans) > 0;
if (!result)
throw new Exception("新增审稿单失败!");
return result;
}
catch (Exception ex)
{
throw ex;
}
}
示例7: doCreate
/// <summary>
/// 新增基本檔資料(使用交易)
/// </summary>
/// <param name="ParameterList">放入輸入的參數</param>
/// <param name="DBT">交易變數</param>
/// <returns>回傳影響筆數</returns>
public int doCreate(Int32 PID, DbTransaction DBT, DataRow dRow, ArrayList ParameterList)
{
try
{
DbCommand cmd = db.GetStoredProcCommand("PKG_VDS_IFM_REQUEST_DETL.InsertOne");
db.AddInParameter(cmd, "vPID", DbType.VarNumeric, PID);
db.AddInParameter(cmd, "vCREATEDATE", DbType.Date, ParameterList[17]);
db.AddInParameter(cmd, "vCREATEUID", DbType.String, ParameterList[18]);
db.AddInParameter(cmd, "vUPDATEDATE", DbType.Date, ParameterList[19]);
db.AddInParameter(cmd, "vUPDATEUID", DbType.String, ParameterList[20]);
db.AddInParameter(cmd, "vREQ_NO", DbType.String, ParameterList[0]);
db.AddInParameter(cmd, "vPHASE_CODE", DbType.String, dRow["PHASE_CODE"]);
db.AddInParameter(cmd, "vSTART_DATE", DbType.Date, dRow["START_DATE"]);
db.AddInParameter(cmd, "vEND_DATE", DbType.Date, dRow["END_DATE"]);
db.AddInParameter(cmd, "vEMP_ID", DbType.String, dRow["EMP_ID"]);
db.AddInParameter(cmd, "vPHASE_HOUR", DbType.String, dRow["PHASE_HOUR"]);
int ProcessRecord = (DBT == null) ? db.ExecuteNonQuery(cmd) : db.ExecuteNonQuery(cmd, DBT);
if (ProcessRecord == 0)
{
throw new Exception("輸入資料失敗!");
}
return int.Parse((db.GetParameterValue(cmd, "vPID")).ToString());
}
catch (Exception ex)
{
throw new Exception("呼叫PKG_VDS_IFM_REQUEST_DETL.InsertOne發生錯誤,錯誤訊息:"
+ ex.Message);
}
}
示例8: PicturesInsertUpdate
/// <summary>
/// ���� ���/����
/// </summary>
/// <param name="pictures">ʵ��</param>
/// <returns>ִ�н��</returns>
public int PicturesInsertUpdate(out string resultMsg,ModelPictures pictures,DbTransaction tran =null)
{
resultMsg = string.Empty;
int res = 0;
try
{
//�洢��������
string sql = "USP_PICTURES_INSERT_UPDATE";
//�������
IList<DBParameter> parm = new List<DBParameter>();
parm.Add(new DBParameter() { ParameterName = "ID", ParameterValue = pictures.Id, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "NAME", ParameterValue = pictures.Name, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "CATEGORYID", ParameterValue = pictures.Categoryid, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "OWNER", ParameterValue = pictures.Owner, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
parm.Add(new DBParameter() { ParameterName = "PICURI", ParameterValue = pictures.Picuri, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "PICLINK", ParameterValue = pictures.Piclink, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String });
parm.Add(new DBParameter() { ParameterName = "STATUS", ParameterValue = pictures.Status, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32 });
//����/����ִ��
res = DBHelper.ExecuteNonQuery(sql, true, parm, tran);
}
catch (Exception ex)
{
if(tran != null)
tran.Rollback();
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return res;
}
示例9: doCreate
/// <summary>
/// �s�W���ɸ��(�ϥΥ��)
/// </summary>
/// <param name="ParameterList">��J��J���Ѽ�</param>
/// <param name="DBT">����ܼ�</param>
/// <returns>�^�Ǽv�T����</returns>
public int doCreate(ArrayList ParameterList,
DbTransaction DBT
)
{
try
{
DbCommand cmd = db.GetStoredProcCommand("PKG_VDS_OUT05.InsertOne");
for (int i = 0; i < ParameterList.Count; i++)
{
SQLHelper.ParameterItem pi = ((SQLHelper.ParameterItem)ParameterList[i]);
db.AddInParameter(cmd,
string.Format("{0}", pi.ParaName),
pi.FieldType,
pi.FieldValue);
}
db.AddOutParameter(cmd, "PID", DbType.VarNumeric, Int32.MaxValue);
int ProcessRecord = (DBT == null) ? db.ExecuteNonQuery(cmd) : db.ExecuteNonQuery(cmd, DBT);
if (ProcessRecord == 0)
{
throw new Exception("��J��ƥ���!");
}
return Convert.ToInt32(db.GetParameterValue(cmd, "PID"));
}
catch (Exception ex)
{
throw new Exception("�I�sPKG_VDS_OUT05.InsertOne�o�Ϳ��~,���~�T��:"
+ OracleExceptionProcess.OracleExceptionStringCut(ex.Message)
);
}
}
示例10: doCloseOrder
public void doCloseOrder(ArrayList ParameterList,
DbTransaction DBT)
{
try
{
DbCommand cmd = db.GetStoredProcCommand("PKG_VDS_OUT05.Update_Close_Order");
for (int i = 0; i < ParameterList.Count; i++)
{
string[] pl = (string[])ParameterList[i];
db.AddInParameter(cmd, "pid", DbType.VarNumeric, pl[0]); // ID
db.AddInParameter(cmd, "p_status_reason", DbType.String, pl[1]); // STATUS_REASON
db.AddInParameter(cmd, "p_updatedate", DbType.DateTime, System.DateTime.Now);
db.AddInParameter(cmd, "p_updateuid", DbType.String, pl[2]);
int ProcessRecord = (DBT == null) ? db.ExecuteNonQuery(cmd) : db.ExecuteNonQuery(cmd, DBT);
if (ProcessRecord == 0)
{
throw new Exception("��s��ƥ���!");
}
}
}
catch (Exception ex)
{
throw new Exception("�I�sPKG_VDS_OUT05.Update_Close_Order()�o�Ϳ��~,���~�T��:"
+ OracleExceptionProcess.OracleExceptionStringCut(ex.Message)
);
}
}
示例11: CGR04_SetReAcceptDate
public int CGR04_SetReAcceptDate(ArrayList ParameterList, DbTransaction DBT)
{
try
{
DbCommand cmd = db.GetStoredProcCommand("PKG_VDS_CGR04.CGR04_SetReAcceptDate");
db.AddInParameter(cmd, "V_BDATE", DbType.String, ParameterList[0]);
db.AddInParameter(cmd, "V_EDATE", DbType.String, ParameterList[1]);
db.AddInParameter(cmd, "V_ACCEPTDATE", DbType.String, ParameterList[2]);
db.AddOutParameter(cmd, "RES", DbType.Int16, 10);
if (DBT == null)
{
db.ExecuteNonQuery(cmd);
}
else
{
db.ExecuteNonQuery(cmd, DBT);
}
return int.Parse(cmd.Parameters["RES"].Value.ToString());
}
catch (Exception ex)
{
throw new Exception("呼叫PKG_VDS_CGR04.InsertRow()發生錯誤,錯誤訊息:" + OracleExceptionProcess.OracleExceptionStringCut(ex.Message));
}
}
示例12: AddProductTags
public bool AddProductTags(int productId, IList<int> tagIds, DbTransaction tran)
{
bool flag = false;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Hishop_ProductTag VALUES(@TagId,@ProductId)");
this.database.AddInParameter(sqlStringCommand, "TagId", DbType.Int32);
this.database.AddInParameter(sqlStringCommand, "ProductId", DbType.Int32);
foreach (int num in tagIds)
{
this.database.SetParameterValue(sqlStringCommand, "ProductId", productId);
this.database.SetParameterValue(sqlStringCommand, "TagId", num);
if (tran != null)
{
flag = this.database.ExecuteNonQuery(sqlStringCommand, tran) > 0;
}
else
{
flag = this.database.ExecuteNonQuery(sqlStringCommand) > 0;
}
if (!flag)
{
return flag;
}
}
return flag;
}
示例13: UpdateBoxDataMain
public int UpdateBoxDataMain(ArrayList ParameterList, DbTransaction DBT)
{
try
{
DbCommand cmd = db.GetStoredProcCommand("PKG_VDS_VGR06.UpdateBoxDataMain");
//0.V_BOX_NO
//1.V_RETURN_NO
//2.V_STATUS
//3.D_LAST_DATE
//4.V_LAST_ID
//5.D_OLD_LAST_DATE
//6.V_OLD_LAST_ID
db.AddInParameter(cmd, "V_BOX_NO", DbType.String, ParameterList[0]);
db.AddInParameter(cmd, "V_RETURN_NO", DbType.String, ParameterList[1]);
db.AddInParameter(cmd, "V_STATUS", DbType.String, ParameterList[2]);
db.AddInParameter(cmd, "D_LAST_DATE", DbType.Date, ParameterList[3]);
db.AddInParameter(cmd, "V_LAST_ID", DbType.String, ParameterList[4]);
db.AddInParameter(cmd, "D_OLD_LAST_DATE", DbType.Date, ParameterList[5]);
db.AddInParameter(cmd, "V_OLD_LAST_ID", DbType.String, ParameterList[6]);
int rtn = (DBT == null) ? db.ExecuteNonQuery(cmd) : db.ExecuteNonQuery(cmd, DBT);
return rtn;
}
catch (Exception ex)
{
throw new Exception("呼叫PKG_VDS_VGR06.UpdateBoxDataMain() 發生錯誤,錯誤訊息:" + ex.Message);
}
}
示例14: UpdateToVersion_1
// update to version 3
private static void UpdateToVersion_1(DbConnection conn, DbTransaction tran)
{
ExecuteNonQuery(conn, tran, "create table tmp_song_data (songid int, textdata text, dataid int);\ninsert into tmp_song_data (songid, textdata, dataid) select ID, songtext, 1 from song;\ninsert into tmp_song_data (songid, textdata, dataid) select ID, songtext, 3 from song where link_1 is not null;\ninsert into tmp_song_data (songid, textdata, dataid) select ID, songtext, 3 from song where link_2 is not null;\n");
ExecuteNonQuery(conn, tran, "ALTER TABLE \"song\" RENAME TO \"temp_table_7_129075918630300000\"");
ExecuteNonQuery(conn, tran, "CREATE TABLE \"song\" ( \n \"ID\" integer primary key NOT NULL, \n \"title\" text NULL, \n \"groupname\" text NULL, \n \"author\" text NULL, \n \"lang\" text NULL, \n \"server_id\" integer NULL, \n \"netID\" integer NULL, \n \"transp\" integer NULL, \n \"published\" datetime NULL, \n \"localmodified\" logical NULL, \n \"remark\" text NULL, \n CONSTRAINT \"FK_song_server_id\" FOREIGN KEY (\"server_id\") REFERENCES \"server\"(\"ID\")\n)");
ExecuteNonQuery(conn, tran, "CREATE INDEX \"IX_song_groupname_ID\" ON \"song\" (\"groupname\",\"ID\")");
ExecuteNonQuery(conn, tran, "INSERT INTO \"song\" (\"ID\", \"title\", \"groupname\", \"author\", \"lang\", \"server_id\", \"netID\", \"transp\", \"published\", \"localmodified\", \"remark\") select \"ID\" AS \"ID\", \"title\" AS \"title\", \"groupname\" AS \"groupname\", \"author\" AS \"author\", \"lang\" AS \"lang\", \"server_id\" AS \"server_id\", \"netID\" AS \"netID\", \"transp\" AS \"transp\", \"published\" AS \"published\", \"localmodified\" AS \"localmodified\", \"remark\" AS \"remark\" FROM \"temp_table_7_129075918630300000\"");
ExecuteNonQuery(conn, tran, "DROP TABLE \"temp_table_7_129075918630300000\"");
ExecuteNonQuery(conn, tran, "ALTER TABLE \"server\" RENAME TO \"temp_table_8_129075918630380000\"");
ExecuteNonQuery(conn, tran, "CREATE TABLE \"server\" ( \n \"ID\" integer primary key NOT NULL, \n \"url\" text NULL, \n \"servertype\" text NULL, \n \"config\" text NULL, \n \"isreadonly\" logical NULL\n)");
ExecuteNonQuery(conn, tran, "INSERT INTO \"server\" (\"ID\", \"url\", \"servertype\", \"config\", \"isreadonly\") select \"ID\" AS \"ID\", \"url\" AS \"url\", \"servertype\" AS \"servertype\", \"config\" AS \"config\", \"isreadonly\" AS \"isreadonly\" FROM \"temp_table_8_129075918630380000\"");
ExecuteNonQuery(conn, tran, "DROP TABLE \"temp_table_8_129075918630380000\"");
ExecuteNonQuery(conn, tran, "ALTER TABLE \"deletedsong\" RENAME TO \"temp_table_9_129075918630410000\"");
ExecuteNonQuery(conn, tran, "CREATE TABLE \"deletedsong\" ( \n \"ID\" integer primary key NOT NULL, \n \"song_netID\" integer NULL, \n \"server_id\" integer NULL, \n CONSTRAINT \"FK_deletedsong_server_id\" FOREIGN KEY (\"server_id\") REFERENCES \"server\"(\"ID\")\n)");
ExecuteNonQuery(conn, tran, "INSERT INTO \"deletedsong\" (\"ID\", \"song_netID\", \"server_id\") select \"ID\" AS \"ID\", \"song_netID\" AS \"song_netID\", \"server_id\" AS \"server_id\" FROM \"temp_table_9_129075918630410000\"");
ExecuteNonQuery(conn, tran, "DROP TABLE \"temp_table_9_129075918630410000\"");
ExecuteNonQuery(conn, tran, "UPDATE \"info\" SET \"value\"=\'3\' WHERE \"name\"=\'dbversion\'");
ExecuteNonQuery(conn, tran, "CREATE TABLE \"songdata\" ( \n \"ID\" integer primary key NOT NULL, \n \"song_id\" integer NOT NULL, \n \"datatype_id\" integer NOT NULL, \n \"label\" text NULL, \n \"textdata\" text NULL, \n CONSTRAINT \"FK_songdata_song_id\" FOREIGN KEY (\"song_id\") REFERENCES \"song\"(\"ID\"), \n CONSTRAINT \"FK_songdata_datatype_id\" FOREIGN KEY (\"datatype_id\") REFERENCES \"datatype_list\"(\"ID\")\n)");
ExecuteNonQuery(conn, tran, "CREATE INDEX \"IX_songdata_song_id\" ON \"songdata\" (\"song_id\")");
ExecuteNonQuery(conn, tran, "CREATE TABLE \"datatype_list\" ( \n \"ID\" integer NOT NULL, \n \"name\" text NOT NULL, \n CONSTRAINT \"PK_datatype_list\" PRIMARY KEY (\"ID\")\n)");
ExecuteNonQuery(conn, tran, "INSERT INTO \"datatype_list\" (\"ID\", \"name\") VALUES (\'3\', \'link\')");
ExecuteNonQuery(conn, tran, "INSERT INTO \"datatype_list\" (\"ID\", \"name\") VALUES (\'1\', \'songtext\')");
ExecuteNonQuery(conn, tran, "INSERT INTO \"datatype_list\" (\"ID\", \"name\") VALUES (\'2\', \'notation\')");
ExecuteNonQuery(conn, tran, "CREATE TABLE \"songlist\" ( \n \"ID\" integer primary key NOT NULL, \n \"name\" text NOT NULL, \n \"options\" text NULL\n)");
ExecuteNonQuery(conn, tran, "CREATE TABLE \"songlistitem\" ( \n \"ID\" integer primary key NOT NULL, \n \"song_id\" integer NOT NULL, \n \"songlist_id\" integer NOT NULL, \n \"transp\" integer NULL, \n \"position\" integer NULL, \n CONSTRAINT \"FK_songlistitem_song_id\" FOREIGN KEY (\"song_id\") REFERENCES \"song\"(\"ID\"), \n CONSTRAINT \"FK_songlistitem_songlist_id\" FOREIGN KEY (\"songlist_id\") REFERENCES \"songlist\"(\"ID\")\n)");
ExecuteNonQuery(conn, tran, "CREATE INDEX \"IX_songlistitem_song_id\" ON \"songlistitem\" (\"song_id\")");
ExecuteNonQuery(conn, tran, "CREATE INDEX \"IX_songlistitem_songlist_id\" ON \"songlistitem\" (\"songlist_id\")");
ExecuteNonQuery(conn, tran, "insert into songdata (song_id, textdata, datatype_id) \nselect songid, textdata, dataid from tmp_song_data;\ndrop table tmp_song_data;\n\n");
ExecuteNonQuery(conn, tran, "update info set value=\'3\' where name=\'dbversion\'");
}
示例15: doCreateMutiStoreData
/// <summary>
/// 執行轉門市唯一檔
/// </summary>
public int[] doCreateMutiStoreData(DbTransaction DBT)
{
try
{
int[] intCNT =new int[2];
DbCommand cmd = db.GetStoredProcCommand("PKG_VDS_STM03.InsertMuti");
db.AddOutParameter(cmd, "VCOUNT", DbType.VarNumeric, Int32.MaxValue);
db.AddOutParameter(cmd, "V_DIS_SW_COUNT", DbType.VarNumeric, Int32.MaxValue);
int ProcessRecord = (DBT == null) ? db.ExecuteNonQuery(cmd) : db.ExecuteNonQuery(cmd, DBT);
if (ProcessRecord == 0)
{
throw new Exception("輸入資料失敗!");
}
intCNT[0] = int.Parse((db.GetParameterValue(cmd, "VCOUNT")).ToString());
intCNT[1] = int.Parse((db.GetParameterValue(cmd, "V_DIS_SW_COUNT")).ToString());
return intCNT;
}
catch (Exception ex)
{
throw new Exception("呼叫STM_CreateStoreUniqueFileDBO.doCreateMutiStoreData()發生錯誤,錯誤訊息:"
+ OracleExceptionProcess.OracleExceptionStringCut(ex.Message)
);
}
}