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