public bool UpdateX()
{
SqlTransaction transaction;
SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.LocalcnString);
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "B_EquipStatus_Update";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("iCode", Code));
command.Parameters.Add(new SqlParameter("iName", Name));
command.Parameters.Add(new SqlParameter("iACode", ACode));
command.Parameters.Add(new SqlParameter("iIsDefault", IsDefault));
command.Parameters.Add(new SqlParameter("iPricePercent", PricePercent));
command.Parameters.Add(new SqlParameter("iExecutePricePercent", ExecutePricePercent));
command.Parameters.Add(new SqlParameter("iWagePricePercent", WagePricePercent));
try
{
connection.Open();
transaction = connection.BeginTransaction();
command.Transaction = transaction;
try
{
command.ExecuteNonQuery();
for (int i = 0; i < arraySub.Count; i++)
{
Atend.Base.Base.BStatusWorkOrder status = new BStatusWorkOrder();
status.EquipStatusCode = Code;
status.WorkOrderCode = Convert.ToInt32(arraySub[i].ToString());
if (!status.InsertX())
{
throw new Exception("Failed");
}
}
transaction.Commit();
connection.Close();
return(true);
}
catch (System.Exception ex)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
ed.WriteMessage(string.Format(" ERROR BEquipStatus.Update(transaction) {0}\n", ex.Message));
transaction.Rollback();
connection.Close();
return(false);
}
}
catch (System.Exception ex1)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
ed.WriteMessage(string.Format(" ERROR BEquipStatus.Update {0}\n", ex1.Message));
connection.Close();
return(false);
}
}
public static BStatusWorkOrder SelectByCode(int Code)
{
SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.LocalcnString);
SqlDataAdapter adapter = new SqlDataAdapter("B_Status_WorkOrder_Select", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("iCode", Code));
DataSet dsProduct = new DataSet();
adapter.Fill(dsProduct);
BStatusWorkOrder product = new BStatusWorkOrder();
if (dsProduct.Tables[0].Rows.Count > 0)
{
product.Code = Convert.ToInt32(dsProduct.Tables[0].Rows[0]["Code"].ToString());
product.EquipStatusCode = Convert.ToInt32(dsProduct.Tables[0].Rows[0]["EquipStatusCode"].ToString());
product.WorkOrderCode = Convert.ToInt32(dsProduct.Tables[0].Rows[0]["WorkOrderCode"].ToString());
}
else
{
product.Code = -1;
}
return(product);
}
