示例#1
0
        public int Fill(YouthOneDS.PriseDataTable dataTable, string memberOID)
        {
            this.Adapter.SelectCommand = MySelectSqlComand;
            this.Adapter.SelectCommand.Parameters[0].Value = memberOID;

            if ((this.ClearBeforeFill == true))
            {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);

            if (returnValue < 7)
            {
                for (int i = 7; i > returnValue; i--)
                {
                    dataTable.AddPriseRow(Guid.NewGuid().ToString(), memberOID, "", "", new DateTime(1900, 1, 1), 0, "");
                }
            }

            dataTable.Rows[1]["EX_TEXT"] = "获";
            dataTable.Rows[2]["EX_TEXT"] = "奖";
            dataTable.Rows[3]["EX_TEXT"] = "情";
            dataTable.Rows[4]["EX_TEXT"] = "况";
            dataTable.Rows[dataTable.Rows.Count - 1]["EX_TEXT"] = "E";

            return(returnValue);
        }
示例#2
0
        public YouthOneDS.PriseDataTable GetData(string memberOID)
        {
            memberOID = memberOID ?? string.Empty;

            YouthOneDS.PriseDataTable dataTable = new YouthOneDS.PriseDataTable();

            this.Adapter.SelectCommand = MySelectSqlComand;
            this.Adapter.SelectCommand.Parameters[0].Value = memberOID;
            this.Adapter.Fill(dataTable);

            return(dataTable);
        }