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); }
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); }