Ejemplo n.º 1
0
        public static BusProject PopulateBusProject(IDataReader reader)
        {
            BusProject item = new BusProject();

            item.ProjectID      = reader["ProjectID"] as string;
            item.ProjectCode    = reader["ProjectCode"] as string;
            item.ProjectName    = reader["ProjectName"] as string;
            item.ProjectType    = reader["ProjectType"] as string;
            item.ProjectStatus  = reader["ProjectStatus"] as string;
            item.ProjectManager = reader["ProjectManager"] as string;
            item.WorkDate       = Double.Parse(reader["WorkDate"].ToString());
            item.WorkUnit       = reader["WorkUnit"] as string;
            item.ProjectDesc    = reader["ProjectDesc"] as string;
            item.TranDate       = Convert.ToDateTime(reader["TranDate"]);
            item.TranUser       = reader["TranUser"] as string;

            return(item);
        }
Ejemplo n.º 2
0
        public static void SaveBusProject(BusProject item, DataProviderAction action)
        {
            if (item == null)
            {
                return;
            }

            SqlConnection conn = DBUtils.GetConnection();
            SqlCommand    cmd  = DBUtils.GetCommand();

            try
            {
                cmd.Transaction = conn.BeginTransaction();

                ArrayList paras = new ArrayList();

                paras.Add(DBUtils.MakeInParam("@ProjectID", SqlDbType.VarChar, 20, item.ProjectID));
                paras.Add(DBUtils.MakeInParam("@ProjectCode", SqlDbType.NVarChar, 20, item.ProjectCode));
                paras.Add(DBUtils.MakeInParam("@ProjectName", SqlDbType.NVarChar, 50, item.ProjectName));
                paras.Add(DBUtils.MakeInParam("@ProjectType", SqlDbType.VarChar, 2, item.ProjectType));
                paras.Add(DBUtils.MakeInParam("@ProjectStatus", SqlDbType.VarChar, 2, item.ProjectStatus));
                paras.Add(DBUtils.MakeInParam("@ProjectManager", SqlDbType.VarChar, 14, item.ProjectManager));
                paras.Add(DBUtils.MakeInParam("@WorkDate", SqlDbType.Decimal, item.WorkDate));
                paras.Add(DBUtils.MakeInParam("@WorkUnit", SqlDbType.VarChar, 2, item.WorkUnit));
                paras.Add(DBUtils.MakeInParam("@ProjectDesc", SqlDbType.Text, item.ProjectDesc));
                paras.Add(DBUtils.MakeInParam("@TranDate", SqlDbType.DateTime, item.TranDate));
                paras.Add(DBUtils.MakeInParam("@TranUser", SqlDbType.VarChar, 14, item.TranUser));
                paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));

                DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Save_BusProject", paras);
                item.ProjectID = ((SqlParameter)paras[0]).Value != DBNull.Value ? ((SqlParameter)paras[0]).Value.ToString() : "";

                cmd.Transaction.Commit();
            }
            catch (Exception)
            {
                cmd.Transaction.Rollback();
                throw;
            }
            finally
            {
                DBUtils.SetDispose(conn, cmd);
            }
        }
Ejemplo n.º 3
0
        public static BusProject GetBusProjectByDB(int dbid)
        {
            BusProject item = new BusProject();

            try
            {
                ArrayList paras = new ArrayList();
                paras.Add(DBUtils.MakeInParam("@DBID", SqlDbType.Int, dbid));

                SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Get_BusProjectByDB", paras);

                if (reader.Read())
                {
                    item = PopulateBusProject(reader);
                }

                reader.Close();
            }
            catch { throw; }

            return(item);
        }
Ejemplo n.º 4
0
        public static BusProject GetBusProject(string projectid)
        {
            BusProject item = new BusProject();

            try
            {
                ArrayList paras = new ArrayList();
                paras.Add(DBUtils.MakeInParam("@ProjectID", SqlDbType.VarChar, 20, projectid));
                paras.Add(DBUtils.MakeInParam("@Get_Action", SqlDbType.NVarChar, 10, DataGetAction.Row.ToString().ToLower()));

                SqlDataReader reader = DBUtils.ExecuteReader(CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Get_BusProject", paras);

                if (reader.Read())
                {
                    item = PopulateBusProject(reader);
                }

                reader.Close();
            }
            catch { throw; }

            return(item);
        }