private void myBottun1_Click(object sender, EventArgs e)
{
ConnectionToDB cnn = new ConnectionToDB();
if (txtItemSwid.Text == "")
{
if (txtItemNo.Text == "")
{
glb_function.MsgBox("الرجاء ادخال رقم القطعة");
return;
}
DataTable dt = cnn.GetDataTable("select swid from items where item_no='" + txtItemNo.Text + "'");
if (dt == null || dt.Rows.Count <= 0)
{
glb_function.MsgBox("No data");
return;
}
else if (dt.Rows.Count > 1)
{
glb_function.MsgBox("more than One Item");
txtItemSwid.Text = dt.Rows[0][0].ToString();
// return;
}
else
{
return;
}
}
int icheck = cnn.TranDataToDB("delete from ITEM_UNITS where item_id=" + txtItemSwid.Text);
if (icheck < 0)
{
glb_function.MsgBox("Error in item units");
return;
}
// icheck = cnn.TranDataToDB("delete from PROPERTY_ITEM where item_id=" + txtItemSwid.Text);
//if (icheck < 0)
//{
// glb_function.MsgBox("Error in item PROPERTY");
// cnn.glb_RollbackTransaction();
// return;
//}
icheck = cnn.TranDataToDB("delete from PROPERTY_ITEM where item_id=" + txtItemSwid.Text);
if (icheck < 0)
{
glb_function.MsgBox("Error in item PROPERTY");
cnn.glb_RollbackTransaction();
return;
}
icheck = cnn.TranDataToDB("delete from PACK_ITEM where itemid=" + txtItemSwid.Text);
if (icheck < 0)
{
glb_function.MsgBox("Error in item Package");
cnn.glb_RollbackTransaction();
return;
}
icheck = cnn.TranDataToDB("delete from items where swid=" + txtItemSwid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("Error in items");
cnn.glb_RollbackTransaction();
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("Deleted");
}
public static bool MultiTransData()
{
if (arrInsertLogs.Count == 0)
{
MsgBox("Error saving MultiTransData");
return(false);
}
int iTransCount = arrInsertLogs.Count;
ConnectionToDB cnn = new ConnectionToDB();
ConnectionToDB.objCmd = new Oracle.ManagedDataAccess.Client.OracleCommand();
string strResult = "";
DataTable dt = new DataTable();
dt.Columns.Add("sqlstcol");
foreach (var item in glb_function.arrInsertLogs)
{
DataRow dRow = dt.NewRow();
string str = item.ToString();
dRow[0] = str;
dt.Rows.Add(dRow);
}
dt.TableName = "sqlsttab";
System.IO.StringWriter writer = new System.IO.StringWriter();
dt.WriteXml(writer);
string strDataAsXML = writer.ToString();
string str1 = strDataAsXML.Length.ToString();
ConnectionToDB.objCmd.Parameters.Add("mytab", Oracle.ManagedDataAccess.Client.OracleDbType.Clob).Value = strDataAsXML;
ConnectionToDB.objCmd.Parameters.Add("ExcutSqlStCout", Oracle.ManagedDataAccess.Client.OracleDbType.Varchar2, 2000).Direction = ParameterDirection.Output;
strResult = cnn.ExecutePro("GeneralTrans.ExcuteSqlSt", "ExcutSqlStCout");
arrInsertLogs.Clear();
if (iTransCount.ToString() == strResult.Trim())
{
cnn.glb_commitTransaction();
glb_function.MsgBox("تمت العملية بنجاح");
return(true);
}
else
{
cnn.glb_RollbackTransaction();
glb_function.MsgBox("حدث خطأ اثناء العملية");
return(false);
}
}
