//AcDrawGroundPostShield
public static BEquipStatus SelectByACode(int ACode)
{
SqlConnection connection = new SqlConnection(ConnectionString.LocalcnString);
SqlDataAdapter adapter = new SqlDataAdapter("B_EquipStatus_SelectMyACode", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("iACode", ACode));
DataSet dsProduct = new DataSet();
connection.Open();
adapter.Fill(dsProduct);
BEquipStatus product = new BEquipStatus();
if (dsProduct.Tables[0].Rows.Count > 0)
{
product.Code = Convert.ToInt32(dsProduct.Tables[0].Rows[0]["Code"].ToString());
product.Name = dsProduct.Tables[0].Rows[0]["Name"].ToString();
product.ACode = Convert.ToInt32(dsProduct.Tables[0].Rows[0]["ACode"].ToString());
product.IsDefault = Convert.ToBoolean(dsProduct.Tables[0].Rows[0]["IsDefault"].ToString());
product.PricePercent = Convert.ToDouble(dsProduct.Tables[0].Rows[0]["PricePercent"].ToString());
product.ExecutePricePercent = Convert.ToDouble(dsProduct.Tables[0].Rows[0]["ExecutePricePercent"].ToString());
product.WagePricePercent = Convert.ToDouble(dsProduct.Tables[0].Rows[0]["WagePricePercent"].ToString());
}
else
{
product.Code = -1;
}
connection.Close();
return(product);
}
//frmDrawBus
public static BEquipStatus SelectByCode(int Code)
{
SqlConnection connection = new SqlConnection(ConnectionString.LocalcnString);
SqlDataAdapter adapter = new SqlDataAdapter("B_EquipStatus_Select", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("iCode", Code));
DataSet dsProduct = new DataSet();
connection.Open();
adapter.Fill(dsProduct);
BEquipStatus product = new BEquipStatus();
if (dsProduct.Tables[0].Rows.Count > 0)
{
product.Code = Convert.ToInt32(dsProduct.Tables[0].Rows[0]["Code"].ToString());
product.Name = dsProduct.Tables[0].Rows[0]["Name"].ToString();
product.ACode = Convert.ToInt32(dsProduct.Tables[0].Rows[0]["ACode"].ToString());
product.IsDefault = Convert.ToBoolean(dsProduct.Tables[0].Rows[0]["IsDefault"].ToString());
product.PricePercent = Convert.ToDouble(dsProduct.Tables[0].Rows[0]["PricePercent"].ToString());
product.ExecutePricePercent = Convert.ToDouble(dsProduct.Tables[0].Rows[0]["ExecutePricePercent"].ToString());
product.WagePricePercent = Convert.ToDouble(dsProduct.Tables[0].Rows[0]["WagePricePercent"].ToString());
}
else
{
product.Code = -1;
}
adapter.SelectCommand.Parameters.Clear();
adapter.SelectCommand.CommandText = "B_Status_WorkOrder_SelectByStatusEquipCode";
adapter.SelectCommand.Parameters.Add(new SqlParameter("iEquipStatusCode", product.Code));
SqlDataReader dr = adapter.SelectCommand.ExecuteReader();
ArrayList a1 = new ArrayList();
while (dr.Read())
{
a1.Add(dr["WorkOrderCode"].ToString());
}
dr.Close();
product.ArraySub = a1;
connection.Close();
return(product);
}