Пример #1
0
        public static EProp AccessSelectByCodeForConvertor(int Code, OleDbTransaction _transaction, OleDbConnection _connection)
        {
            OleDbConnection connection = _connection;
            OleDbCommand    command    = new OleDbCommand("E_Prop_Select", connection);

            command.CommandType = CommandType.StoredProcedure;
            command.Transaction = _transaction;
            //connection.Open();
            command.Parameters.Add(new OleDbParameter("iCode", Code));
            OleDbDataReader reader = command.ExecuteReader();
            EProp           _EProp = new EProp();

            if (reader.Read())
            {
                _EProp.Code        = Convert.ToInt32(reader["Code"].ToString());
                _EProp.Name        = Convert.ToString(reader["Name"].ToString());
                _EProp.ProductCode = Convert.ToInt32(reader["ProductCode"].ToString());
                _EProp.XCode       = new Guid(reader["XCode"].ToString());
            }
            else
            {
                _EProp.Code = -1;
            }

            reader.Close();
            //connection.Close();
            return(_EProp);
        }
Пример #2
0
        public static bool GetFromBProductLocal()
        {
            Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;

            DataTable bp = Atend.Base.Base.BProduct.SelectByTypeX(Convert.ToInt32(Atend.Control.Enum.ProductType.Prop));

            ed.WriteMessage("bp.Count={0}\n", bp.Rows.Count);
            foreach (DataRow dr in bp.Rows)
            {
                EProp Prop = Atend.Base.Equipment.EProp.SelectByProductCode(Convert.ToInt32(dr["ID"].ToString()));
                if (Prop.Code != -1)
                {
                    ed.WriteMessage("Prop.Name={0}\n", Prop.Name);
                    Prop.Name = dr["Name"].ToString();
                    ed.WriteMessage("ProductCode={0}\n", dr["ID"].ToString());
                    Prop.ProductCode = Convert.ToInt32(dr["ID"].ToString());
                    if (!Prop.UpdateX())
                    {
                        return(false);
                    }
                }
                else
                {
                    ed.WriteMessage("InsertProp\n");
                    Prop.ProductCode = Convert.ToInt32(dr["ID"].ToString());
                    Prop.Name        = dr["Name"].ToString();
                    if (!Prop.InsertX())
                    {
                        return(false);
                    }
                }
            }
            return(true);
        }
Пример #3
0
        public static EProp SelectByCodeForLocal(int Code, SqlTransaction LocalTransaction, SqlConnection LocalConnection)
        {
            SqlConnection connection = LocalConnection;
            SqlCommand    command    = new SqlCommand("E_Prop_Select", connection);

            command.CommandType = CommandType.StoredProcedure;

            command.Parameters.Add(new SqlParameter("iCode", Code));
            EProp Prop = new EProp();

            try
            {
                command.Transaction = LocalTransaction;
                SqlDataReader reader = command.ExecuteReader();
                if (reader.Read())
                {
                    Prop.Code = Convert.ToInt16(reader["Code"].ToString());

                    Prop.Name        = reader["Name"].ToString();
                    Prop.ProductCode = Convert.ToInt32(reader["ProductCode"].ToString());
                    Prop.XCode       = new Guid(reader["XCode"].ToString());
                    Prop.IsDefault   = Convert.ToBoolean(reader["IsDefault"].ToString());
                }
                else
                {
                    Prop.Code = -1;
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
                ed.WriteMessage("Error EProp.In SelectByXCode.TransAction:{0}\n", ex.Message);
            }

            return(Prop);
        }
Пример #4
0
        public static EProp SelectByProductCode(int ProductCode)
        {
            SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.LocalcnString);
            SqlCommand    command    = new SqlCommand("E_Prop_SelectByProductCode", connection);

            command.CommandType = CommandType.StoredProcedure;

            connection.Open();
            command.Parameters.Add(new SqlParameter("iProductCode", ProductCode));
            SqlDataReader reader = command.ExecuteReader();
            EProp         Prop   = new EProp();

            if (reader.Read())
            {
                Prop.Code = Convert.ToInt16(reader["Code"].ToString());

                Prop.Name        = reader["Name"].ToString();
                Prop.ProductCode = Convert.ToInt32(reader["ProductCode"].ToString());
                Prop.XCode       = new Guid(reader["XCode"].ToString());
                Prop.IsDefault   = Convert.ToBoolean(reader["IsDefault"].ToString());
            }
            else
            {
                Prop.Code = -1;
            }
            reader.Close();
            connection.Close();

            Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;

            //ed.WriteMessage(string.Format(" Values: {0} , {1} , {2}  \n", bus.ProductCode, bus.Size, bus, bus.Type));



            return(Prop);
        }