public bool DeleteBy(SqlConnection conn, SqlTransaction trans, int transportOrderId)
{
DataSet ds = new DAL.TransportOrderItem().GetList("TransportOrderId = " + transportOrderId + "");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
int orderId = Convert.ToInt32(dr["OrderId"]);
decimal factDispatchCount = Convert.ToDecimal(dr["FactDispatchCount"]);
new DAL.Order().UpdateField(conn, trans, orderId, "DispatchedCount = DispatchedCount - " + factDispatchCount + "");
}
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from mtms_TransportOrderItem ");
strSql.Append(" where TransportOrderId=@TransportOrderId");
SqlParameter[] parameters =
{
new SqlParameter("@TransportOrderId", SqlDbType.Int, 4)
};
parameters[0].Value = transportOrderId;
int rows = DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public bool DeleteBy(SqlConnection conn, SqlTransaction trans, int transportOrderId)
{
DataSet ds = new DAL.TransportOrderItem().GetList("TransportOrderId = " + transportOrderId + "");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
int orderId = Convert.ToInt32(dr["OrderId"]);
decimal factDispatchCount = Convert.ToDecimal(dr["FactDispatchCount"]);
new DAL.Order().UpdateField(conn, trans, orderId, "DispatchedCount = DispatchedCount - " + factDispatchCount + "");
}
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from mtms_TransportOrderItem ");
strSql.Append(" where TransportOrderId=@TransportOrderId");
SqlParameter[] parameters = {
new SqlParameter("@TransportOrderId", SqlDbType.Int,4)
};
parameters[0].Value = transportOrderId;
int rows = DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
return false;
}
