// Queue<Object> queue = new Queue<object>(); private void button_print_Click(object sender, EventArgs e) { DB.BLL.TASK bll_Task = new DB.BLL.TASK(); DB.Model.TASK model_Task = new DB.Model.TASK(); MessageForm fm = new MessageForm(fPrintNames.Count()); fm.Show(this); //防止用户点击两次,重复加入任务 int i = 0; foreach(string tem in fPrintNames) { i++; Thread.Sleep(30); model_Task.FILE_FULLNAME = tem; model_Task.TASK_GUID = System.Guid.NewGuid().ToString(); model_Task.SAVE_PATH = textBox_TargetAddr.Text; model_Task.PRINTER = comboBox_printerlist.Text; model_Task.PAPER = comboBox_PaperSizeList.Text; model_Task.ORDERED = 0; model_Task.ISPRINTING = 0; model_Task.PRINTING_TIME = System.DateTime.Now; bll_Task.Add(model_Task); fm.setPos(i); } Thread.Sleep(1000); fm.Close(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DB.Model.TASK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TASK set "); strSql.Append("FILE_FULLNAME=:FILE_FULLNAME,"); strSql.Append("ORDERED=:ORDERED,"); strSql.Append("PRINTING_TIME=:PRINTING_TIME,"); strSql.Append("SAVE_PATH=:SAVE_PATH,"); strSql.Append("PRINTER=:PRINTER,"); strSql.Append("PAPER=:PAPER,"); strSql.Append("ISPRINTING=:ISPRINTING"); strSql.Append(" where TASK_GUID=:TASK_GUID "); OracleParameter[] parameters = { new OracleParameter(":FILE_FULLNAME", OracleType.VarChar, 500), new OracleParameter(":ORDERED", OracleType.Number, 1), new OracleParameter(":PRINTING_TIME", OracleType.DateTime), new OracleParameter(":SAVE_PATH", OracleType.VarChar, 500), new OracleParameter(":PRINTER", OracleType.VarChar, 50), new OracleParameter(":PAPER", OracleType.VarChar, 50), new OracleParameter(":ISPRINTING", OracleType.Number, 1), new OracleParameter(":TASK_GUID", OracleType.VarChar, 100) }; parameters[0].Value = model.FILE_FULLNAME; parameters[1].Value = model.ORDERED; parameters[2].Value = model.PRINTING_TIME; parameters[3].Value = model.SAVE_PATH; parameters[4].Value = model.PRINTER; parameters[5].Value = model.PAPER; parameters[6].Value = model.ISPRINTING; parameters[7].Value = model.TASK_GUID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DB.Model.TASK DataRowToModel(DataRow row) { DB.Model.TASK model = new DB.Model.TASK(); if (row != null) { if (row["TASK_GUID"] != null) { model.TASK_GUID = row["TASK_GUID"].ToString(); } if (row["FILE_FULLNAME"] != null) { model.FILE_FULLNAME = row["FILE_FULLNAME"].ToString(); } if (row["ORDERED"] != null && row["ORDERED"].ToString() != "") { model.ORDERED = decimal.Parse(row["ORDERED"].ToString()); } if (row["PRINTING_TIME"] != null && row["PRINTING_TIME"].ToString() != "") { model.PRINTING_TIME = DateTime.Parse(row["PRINTING_TIME"].ToString()); } if (row["SAVE_PATH"] != null) { model.SAVE_PATH = row["SAVE_PATH"].ToString(); } if (row["PRINTER"] != null) { model.PRINTER = row["PRINTER"].ToString(); } if (row["PAPER"] != null) { model.PAPER = row["PAPER"].ToString(); } if (row["ISPRINTING"] != null && row["ISPRINTING"].ToString() != "") { model.ISPRINTING = decimal.Parse(row["ISPRINTING"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DB.Model.TASK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TASK("); strSql.Append("TASK_GUID,FILE_FULLNAME,ORDERED,PRINTING_TIME,SAVE_PATH,PRINTER,PAPER,ISPRINTING)"); strSql.Append(" values ("); strSql.Append(":TASK_GUID,:FILE_FULLNAME,:ORDERED,:PRINTING_TIME,:SAVE_PATH,:PRINTER,:PAPER,:ISPRINTING)"); OracleParameter[] parameters = { new OracleParameter(":TASK_GUID", OracleType.VarChar, 100), new OracleParameter(":FILE_FULLNAME", OracleType.VarChar, 500), new OracleParameter(":ORDERED", OracleType.Number, 1), new OracleParameter(":PRINTING_TIME", OracleType.DateTime), new OracleParameter(":SAVE_PATH", OracleType.VarChar, 500), new OracleParameter(":PRINTER", OracleType.VarChar, 50), new OracleParameter(":PAPER", OracleType.VarChar, 50), new OracleParameter(":ISPRINTING", OracleType.Number, 1) }; parameters[0].Value = model.TASK_GUID; parameters[1].Value = model.FILE_FULLNAME; parameters[2].Value = model.ORDERED; parameters[3].Value = model.PRINTING_TIME; parameters[4].Value = model.SAVE_PATH; parameters[5].Value = model.PRINTER; parameters[6].Value = model.PAPER; parameters[7].Value = model.ISPRINTING; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DB.Model.TASK GetModel(string TASK_GUID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select TASK_GUID,FILE_FULLNAME,ORDERED,PRINTING_TIME,SAVE_PATH,PRINTER,PAPER,ISPRINTING from TASK "); strSql.Append(" where TASK_GUID=:TASK_GUID "); OracleParameter[] parameters = { new OracleParameter(":TASK_GUID", OracleType.VarChar, 100) }; parameters[0].Value = TASK_GUID; DB.Model.TASK model = new DB.Model.TASK(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }