/// <summary>
/// 保存财务入库信息
/// </summary>
/// <param name="financeStockInEntity"></param>
/// <param name="userID"></param>
/// <param name="errorCode"></param>
/// <returns></returns>
public bool SaveFinanceStockIn(FinanceStockInEntity financeStockInEntity, string userID, ref string errorCode)
{
bool flag = false;
if (financeStockInEntity == null)
{
errorCode = "ERROR_BLL_001";
return(flag);
}
try
{
// 无数据的具体原因分两种， 1： SQL查询出现系统级别错误， 2：存在票号数据交叉，不能保存
DataTable dt = financeStockInDAL.GetTicketStockIn(financeStockInEntity, ref errorCode);
if (dt != null && dt.Rows.Count > 0)
{
errorCode = "MSG_001"; // 已存在相关票据不能再次入库
}
else if (dt != null && dt.Rows.Count == 0)
{
flag = financeStockInDAL.SaveFinanceStockIn(financeStockInEntity, userID, ref errorCode);
}
else
{
// errorCode 在 DAL 的 GetTicketStockIn 方法内被赋值
}
}
catch (Exception ex)
{
// 记录日志
flag = false;
}
return(flag);
}
/// <summary>
/// 查询同类型票据信息
/// </summary>
/// <param name="financeStockInEntity">将要保存的财务入库信息</param>
/// <param name="errorCode">系统错误编码</param>
/// <returns>返回数据库中已存在的票据集合</returns>
public DataTable GetTicketStockIn(FinanceStockInEntity financeStockInEntity, ref string errorCode)
{
DataTable dt = null;
if (financeStockInEntity == 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.TICKET_ID BETWEEN '{1}' AND '{2}'"
, financeStockInEntity.FIN_TICKET_START.Substring(0, 2)
, financeStockInEntity.FIN_TICKET_START
, financeStockInEntity.FIN_TICKET_END);
dt = dbHelper.ExecuteQuery(sqlStr);
}
catch (Exception ex)
{
errorCode = "ERROR_002";
}
return(dt);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
bool flag = false;
string errorCode = "";
if (this.lookUpEdit1.EditValue == null || this.lookUpEdit1.EditValue.ToString() == "nulltext")
{
//提示信息,说明未选择下拉框
MessageBox.Show("带 * 为必填项！");
return;
}
FinanceStockInEntity financeStockInEntity = new FinanceStockInEntity();
financeStockInEntity.FIN_SUPPLY_ID = this.lookUpEdit2.EditValue.ToString();
financeStockInEntity.FIN_TICKET_START = txtQSHM.Text;
financeStockInEntity.FIN_TICKET_COUNT = Int32.Parse(txtZS.Text);
financeStockInEntity.FIN_TICKET_END = txtZZHM.Text;
financeStockInEntity.FIN_TICKET_ITEM_ID = this.lookUpEdit1.EditValue.ToString();
financeStockInEntity.FIN_OPERATE_ID = SystemInfo.UserID;
financeStockInEntity.FIN_OPERATE_DATE = DateTime.Now;
financeStockInEntity.FIN_TYPE = "0";
flag = financeStockInBLL.SaveFinanceStockIn(financeStockInEntity, SystemInfo.UserID, ref errorCode);
if (!flag)
{
MessageBox.Show(errorCode);
}
else
{
MessageBox.Show("操作成功！");
}
}
/// <summary>
/// 保存财务入库退票信息
/// </summary>
/// <param name="financeStockInEntity"></param>
/// <param name="userID"></param>
/// <param name="errorCode"></param>
/// <returns></returns>
public bool SaveFinanceStockInBack(FinanceStockInEntity financeStockInEntity, string userID, ref string errorCode)
{
bool flag = false;
if (financeStockInEntity == null)
{
errorCode = "ERROR_BLL_001";
return(flag);
}
try
{
flag = financeStockInDAL.SaveFinanceStockInBack(financeStockInEntity, userID, ref errorCode);
}
catch (Exception ex)
{
// 记录日志
flag = false;
}
return(flag);
}
public bool SaveFinanceStockIn(FinanceStockInEntity financeStockInEntity, string userID, ref string errorCode)
{
bool flag = false;
ArrayList strListSQL = new ArrayList();
try
{
string ticketID = financeStockInEntity.FIN_TICKET_START;
string prefixStr = ticketID.Substring(0, 2);
int iStartTicketID = Int32.Parse(ticketID.Substring(2));
string sqlStr = string.Format(@"INSERT INTO TSS_FINANCIAL_IN(
FIN_SUPPLY_ID, FIN_TICKET_START, FIN_TICKET_COUNT
,FIN_TICKET_END, FIN_TICKET_ITEM_ID, FIN_OPERATE_ID
,FIN_OPERATE_DATE, FIN_TYPE)
VALUES (
'{0}', '{1}', '{2}'
,'{3}', '{4}', '{5}'
,'{6}', '{7}')",
financeStockInEntity.FIN_SUPPLY_ID,
financeStockInEntity.FIN_TICKET_START,
financeStockInEntity.FIN_TICKET_COUNT,
financeStockInEntity.FIN_TICKET_END,
financeStockInEntity.FIN_TICKET_ITEM_ID,
financeStockInEntity.FIN_OPERATE_ID,
financeStockInEntity.FIN_OPERATE_DATE,
financeStockInEntity.FIN_TYPE);
// =======================插入主表====================== //
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 <= financeStockInEntity.FIN_TICKET_COUNT; i++)
{
DataRow dataRow = tDT.NewRow();
// =====================插入门票信息表==================== //
dataRow["TICKET_ID"] = ticketID;
dataRow["TICKET_ITEM_ID"] = financeStockInEntity.FIN_TICKET_ITEM_ID;
dataRow["TICKET_FIN_USER_ID"] = userID;
dataRow["TICKET_FIN_DATE"] = time;
dataRow["TICKET_FOUT_USER_ID"] = DBNull.Value;
dataRow["TICKET_FOUT_DATE"] = DBNull.Value;
dataRow["TICKET_TOUT_USER_ID"] = DBNull.Value;
dataRow["TICKET_TOUT_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_001";
}
return(flag);
}
/// <summary>
/// 保存财务入库退票信息，更新IS_DEL为1
/// </summary>
/// <param name="financeStockInEntity"></param>
/// <param name="userID"></param>
/// <param name="errorCode"></param>
/// <returns></returns>
public bool SaveFinanceStockInBack(FinanceStockInEntity financeStockInEntity, string userID, ref string errorCode)
{
bool flag = true;
ArrayList strListSQL = new ArrayList();
try
{
string counts = dbHelper.GetSingle(string.Format(@"
SELECT COUNT(*) AS COUNTS
FROM TSS_TICKET
WHERE IS_FOUT = '0' AND IS_DEL = '0'
AND TICKET_ID LIKE '{0}%'
AND TICKET_ID BETWEEN '{1}' AND '{2}'"
, financeStockInEntity.FIN_TICKET_START.Substring(0, 2)
, financeStockInEntity.FIN_TICKET_START
, financeStockInEntity.FIN_TICKET_END)).ToString();
// 与预计影响行数相同则更新
if (financeStockInEntity.FIN_TICKET_COUNT.ToString().Equals(counts))
{
string sqlStr = string.Format(@"
INSERT INTO TSS_FINANCIAL_IN(
FIN_SUPPLY_ID, FIN_TICKET_START, FIN_TICKET_COUNT
,FIN_TICKET_END, FIN_TICKET_ITEM_ID, FIN_OPERATE_ID
,FIN_OPERATE_DATE, FIN_TYPE)
VALUES (
'{0}', '{1}', '{2}'
,'{3}', '{4}', '{5}'
,'{6}', '{7}')",
financeStockInEntity.FIN_SUPPLY_ID,
financeStockInEntity.FIN_TICKET_START,
financeStockInEntity.FIN_TICKET_COUNT,
financeStockInEntity.FIN_TICKET_END,
financeStockInEntity.FIN_TICKET_ITEM_ID,
financeStockInEntity.FIN_OPERATE_ID,
financeStockInEntity.FIN_OPERATE_DATE,
financeStockInEntity.FIN_TYPE);
strListSQL.Add(sqlStr);
sqlStr = string.Format(@"
UPDATE TSS_TICKET
SET IS_DEL = '1'
WHERE IS_FOUT = '0' AND IS_DEL = '0'
AND TICKET_ID LIKE '{0}%'
AND TICKET_ID BETWEEN '{1}' AND '{2}'"
, financeStockInEntity.FIN_TICKET_START.Substring(0, 2)
, financeStockInEntity.FIN_TICKET_START
, financeStockInEntity.FIN_TICKET_END);
strListSQL.Add(sqlStr);
dbHelper.ExecuteSqlTran(strListSQL);
}
else
{
// 存在交叉数据，不能退这些票
flag = false;
errorCode = "MSG_002";
}
}
catch (Exception ex)
{
// 记录日志
flag = false;
errorCode = "ERROR_001";
}
return(flag);
}