/// <summary> /// 保存门票出库回库信息 /// </summary> /// <param name="ticketOutEntity"></param> /// <param name="errorCode"></param> /// <returns></returns> public bool SaveTicketOutBack(TicketOutEntity ticketOutEntity, ref string errorCode) { bool flag = false; if (ticketOutEntity == null) { errorCode = "ERROR_BLL_001"; return(flag); } try { // 无数据的具体原因分两种, 1: SQL查询出现系统级别错误, 2:按条件查询到的门票出库回库的票据个数与填写的个数不符 DataTable dt = ticketOutDAL.GetTicketOutBack(ticketOutEntity, ref errorCode); if (dt == null) { return(flag); } if (dt.Rows.Count != ticketOutEntity.TOUT_TICKET_COUNT) { errorCode = "MSG_001"; // 按条件查询到的门票出库回库的票据个数与填写的个数不符 } else { flag = ticketOutDAL.SaveTicketOutBack(ticketOutEntity, ref errorCode); } } catch (Exception ex) { // 记录日志 flag = false; } return(flag); }
/// <summary> /// 财务出库 /// INSERT TSS_FINANCIAL_OUT TOUT_TYPE = 0 /// UPDATE TSS_TICKET IS_FOUT=1 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void simpleButton1_Click(object sender, EventArgs e) { bool flag = false; string errorCode = ""; if (this.lookUpEdit2.EditValue == null || this.lookUpEdit2.EditValue.ToString() == "nulltext") { //提示信息,说明未选择下拉框 MessageBox.Show("带 * 为必填项!"); return; } TicketOutEntity ticketOutEntity = new TicketOutEntity(); ticketOutEntity.TOUT_LEADBACK_ID = this.lookUpEdit2.EditValue.ToString(); ticketOutEntity.TOUT_TICKET_START = txtQSHM.Text; ticketOutEntity.TOUT_TICKET_COUNT = Int32.Parse(txtZS.Text); ticketOutEntity.TOUT_TICKET_END = txtZZHM.Text; ticketOutEntity.TOUT_OPERATE_ID = SystemInfo.UserID; ticketOutEntity.TOUT_OPERATE_DATE = DateTime.Now; ticketOutEntity.TOUT_TYPE = "0"; flag = ticketOutBLL.SaveTicketOut(ticketOutEntity, ref errorCode); if (!flag) { MessageBox.Show(errorCode); } else { MessageBox.Show("操作成功!"); } }
/// <summary> /// 查询同类型票据信息 /// </summary> /// <param name="ticketOutEntity">将要保存的门票出库回库信息</param> /// <param name="errorCode">系统错误编码</param> /// <returns>返回数据库中符合条件的票据集合</returns> public DataTable GetTicketOutBack(TicketOutEntity ticketOutEntity, ref string errorCode) { DataTable dt = null; if (ticketOutEntity == null) { errorCode = "ERROR_001"; return(dt); } try { // 查询出开头为“**”的可门票出库回库的票据记录 string sqlStr = string.Format(@" SELECT T.TICKET_ID FROM TSS_TICKET T WHERE T.IS_DEL = '0' AND T.TICKET_ID LIKE '{0}%' AND T.IS_SALE = '0' AND T.IS_READY_SALE = '1' AND T.TICKET_TOUT_USER_ID = '{1}' AND T.TICKET_ID BETWEEN '{2}' AND '{3}'" , ticketOutEntity.TOUT_TICKET_START.Substring(0, 2) , ticketOutEntity.TOUT_LEADBACK_ID , ticketOutEntity.TOUT_TICKET_START , ticketOutEntity.TOUT_TICKET_END); dt = dbHelper.ExecuteQuery(sqlStr); } catch (Exception ex) { errorCode = "ERROR_002"; } return(dt); }
public bool SaveTicketOut(TicketOutEntity ticketOutEntity, ref string errorCode) { bool flag = true; ArrayList strListSQL = new ArrayList(); try { string ticketID = ticketOutEntity.TOUT_TICKET_START; string prefixStr = ticketID.Substring(0, 2); int iStartTicketID = Int32.Parse(ticketID.Substring(2)); // =======================插入门票出库表====================== // string sqlStr = string.Format(@"INSERT INTO TSS_TICKET_OUT( TOUT_LEADBACK_ID, TOUT_TICKET_START, TOUT_TICKET_COUNT ,TOUT_TICKET_END, TOUT_OPERATE_ID ,TOUT_OPERATE_DATE, TOUT_TYPE) VALUES ( '{0}', '{1}', '{2}' ,'{3}', '{4}' ,'{5}', '{6}')", ticketOutEntity.TOUT_LEADBACK_ID, ticketOutEntity.TOUT_TICKET_START, ticketOutEntity.TOUT_TICKET_COUNT, ticketOutEntity.TOUT_TICKET_END, ticketOutEntity.TOUT_OPERATE_ID, ticketOutEntity.TOUT_OPERATE_DATE, ticketOutEntity.TOUT_TYPE); strListSQL.Add(sqlStr); // =======================更新门票信息表====================== // sqlStr = string.Format(@"UPDATE TSS_TICKET SET IS_READY_SALE = '1', TICKET_TOUT_USER_ID = '{0}', TICKET_TOUT_DATE = GETDATE() WHERE TICKET_ID BETWEEN '{1}' AND '{2}' AND IS_DEL = '0'", ticketOutEntity.TOUT_LEADBACK_ID, ticketOutEntity.TOUT_TICKET_START, ticketOutEntity.TOUT_TICKET_END); strListSQL.Add(sqlStr); // =======================插入门票出库明细表====================== // //DataSet tDS = dbHelper.Query("select * from TSS_TICKET where 1=2", "TSS_TICKET"); //new DataTable("TSS_TICKET"); //DataTable tDT = tDS.Tables["TSS_TICKET"]; //DateTime time = DateTime.Now; //for (int i = 1; i <= ticketOutEntity.TOUT_TICKET_COUNT; i++) //{ // DataRow dataRow = tDT.NewRow(); // dataRow["TICKET_ID"] = ticketID; // dataRow["TICKET_TOUT_USER_ID"] = userID; // dataRow["TICKET_TOUT_DATE"] = time; // dataRow["TICKET_OUT_USER_ID"] = DBNull.Value; // dataRow["TICKET_OUT_DATE"] = DBNull.Value; // dataRow["IS_FOUT"] = "0"; // dataRow["IS_READY_SALE"] = "0"; // dataRow["IS_SALE"] = "0"; // dataRow["IS_REFUND"] = "0"; // dataRow["IS_CHECKIN"] = "0"; // dataRow["VALIDITY_START_DATE"] = time; // dataRow["VALIDITY_END_DATE"] = time.AddYears(1); // dataRow["IS_PREBOOKING"] = "0"; // dataRow["IS_DEL"] = "0"; // tDT.Rows.Add(dataRow); // ticketID = prefixStr + (iStartTicketID + i).ToString("00000000"); //} //flag = dbHelper.BlukImport(tDT); // =====================统一在一个事务中执行并提交==================== // //if (flag) dbHelper.ExecuteSqlTran(strListSQL); } catch (Exception ex) { // 记录日志 errorCode = "ERROR_002"; flag = false; } return(flag); }