110,566
社区成员
发帖
与我相关
我的任务
分享
//类dbAccess是进行查询的SQL函数
class dbAccess
{
public string QueryProjectFromDb(string connectionString, string sql, ref ArrayList s)
{
MySqlConnection cnn = new MySqlConnection(connectionString);
cnn.Open();
MySqlCommand cmm = cnn.CreateCommand();
cmm.CommandText = sql;
MySqlDataReader dr = cmm.ExecuteReader();
while (dr.Read())
{
objProjects obj_temp = new objProjects();
obj_temp.setAutoID(Convert.ToInt32(dr[0]));
obj_temp.setBatchQty(Convert.ToInt32(dr[1]));
obj_temp.setpointQty(Convert.ToInt32(dr[2]));
s.Add(obj_temp);
}
return "";
}
}
//类objProjects定义了下变量属性
class objProjects
{
private int autoID = 0;
private int batchQty = 0;
private int pointQty = 0;
public objProjects() { }
public void setAutoID(int i) { this.autoID = i; }
public int getAutoID() { return this.autoID; }
public void setBatchQty(int i) { this.batchQty = i; }
public int getBatchQty() { return this.batchQty; }
public void setpointQty(int i) { this.pointQty = i; }
public int getpointQty() { return this.pointQty; }
}
//主程序:
private void button1_Click(object sender, EventArgs e)
{
string _sql = "";
dbAccess mydb = new dbAccess();
_sql = "SELECT AutoID,ProjectName,CodeLength,CodeType,BatchQty,PointQty From printprojectsetting";
string _sMessage = mydb.QueryProjectFromDb(connnectionString, _sql, ref _arrProjects);
if (_sMessage.Trim().Equals(""))
{
foreach (object obj in _arrProjects)
{
objProjects myObjProjects = (objProjects)obj;
//改成myObjProjects.getBatchQty就表示返回批次数量。改成getBatchQty.getpointQty就表示返回积分值
comboBox1.Items.Add(myObjProjects.getAutoID().ToString());
}
}
}