private void llAdd_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
using (var mForm = new 申请餐费报销())
{
mForm.ShowDialog();
btnSearch_Click(sender, new EventArgs());
}
}
private void dgvGiftStockOut_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == dgvGiftStockOut.Columns["ColDel"].Index)
{
//删除
if (dgvGiftStockOut.Rows[e.RowIndex].Cells["statusDataGridViewTextBoxColumn"].Value.ToString() == "已领卡")
{
MessageBox.Show("该消费卡尚未归还,不能删除!");
return;
}
if (MessageBox.Show("确认要删除该条记录吗?", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
{
return;
}
using (SqlConnection mConn = new SqlConnection(Common.CommonClass.SqlConnStr))
{
mConn.Open();
using (SqlTransaction mTrans = mConn.BeginTransaction())
{
try
{
var adapter = new T_MealsTableAdapter();
adapter.Connection = mConn;
adapter.Transaction = mTrans;
int ret = 0;
ret = adapter.MyDelete(Convert.ToInt64(dgvGiftStockOut.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value));
if (ret > 0)
{
if (dgvGiftStockOut.Rows[e.RowIndex].Cells["statusDataGridViewTextBoxColumn"].Value.ToString() == "已还卡") //已还卡的
{
var adapter1 = new T_CardsTableAdapter();
adapter1.Connection = mConn;
adapter1.Transaction = mTrans;
ret = adapter1.ExpenseById(-Convert.ToDecimal(dgvGiftStockOut.Rows[e.RowIndex].Cells["mealMoneyDataGridViewTextBoxColumn"].Value), Convert.ToInt64(dgvGiftStockOut.Rows[e.RowIndex].Cells["cardid"].Value));
}
if (ret > 0)
{
mTrans.Commit();
MessageBox.Show("删除成功");
mConn.Close();
btnSearch_Click(sender, new EventArgs());
return;
}
else
{
mTrans.Rollback();
MessageBox.Show("删除失败:2");
return;
}
}
else
{
mTrans.Rollback();
MessageBox.Show("删除失败:1");
return;
}
}
catch (Exception ex)
{
mTrans.Rollback();
MessageBox.Show(ex.Message);
return;
}
}
}
}
if (e.ColumnIndex == dgvGiftStockOut.Columns["ColModify"].Index)
{
//修改
using (var mForm = new 申请餐费报销())
{
mForm.mId = Convert.ToInt64(dgvGiftStockOut.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value);
mForm.oldStatus = dgvGiftStockOut.Rows[e.RowIndex].Cells["statusDataGridViewTextBoxColumn"].Value.ToString();
mForm.oldCardName = dgvGiftStockOut.Rows[e.RowIndex].Cells["cardIdDataGridViewTextBoxColumn"].Value.ToString();
mForm.ShowDialog();
btnSearch_Click(sender, new EventArgs());
}
}
if (e.ColumnIndex == dgvGiftStockOut.Columns["ColGetCard"].Index)
{
//领卡
if (dgvGiftStockOut.Rows[e.RowIndex].Cells["statusDataGridViewTextBoxColumn"].Value.ToString() != "审核已通过" || dgvGiftStockOut.Rows[e.RowIndex].Cells["cardIdDataGridViewTextBoxColumn"].Value.ToString() == "现金")
{
return;
}
long cardId = Convert.ToInt64(dgvGiftStockOut.Rows[e.RowIndex].Cells["CardId"].Value);
var mRow = (销售管理.DAL.DataSetCards.T_CardsRow) new T_CardsTableAdapter().GetDataById(cardId).Rows[0];
if (mRow.UserName.Trim() != string.Empty)
{
MessageBox.Show("卡已被" + mRow.UserName + "借出");
return;
}
using (SqlConnection mConn = new SqlConnection(Common.CommonClass.SqlConnStr))
{
mConn.Open();
using (SqlTransaction mTrans = mConn.BeginTransaction())
{
try
{
var adapter = new T_MealsTableAdapter();
adapter.Connection = mConn;
adapter.Transaction = mTrans;
int ret = adapter.UpdateStatus("已领卡", Convert.ToInt64(dgvGiftStockOut.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value));
if (ret > 0)
{
var adapter1 = new T_CardsTableAdapter();
adapter1.Connection = mConn;
adapter1.Transaction = mTrans;
ret = adapter1.UpdateUserName(Convert.ToString(dgvGiftStockOut.Rows[e.RowIndex].Cells["userIdDataGridViewTextBoxColumn"].Value), cardId);
if (ret > 0)
{
mTrans.Commit();
mConn.Close();
MessageBox.Show("领卡成功");
btnSearch_Click(sender, new EventArgs());
return;
}
else
{
mTrans.Rollback();
MessageBox.Show("领卡失败:2");
return;
}
}
else
{
mTrans.Rollback();
MessageBox.Show("领卡失败:1");
return;
}
}
catch (Exception ex)
{
mTrans.Rollback();
MessageBox.Show(ex.Message);
return;
}
}
}
}
//还卡金额录入
if (e.ColumnIndex == dgvGiftStockOut.Columns["ColBackCard"].Index)
{
//还卡
if (dgvGiftStockOut.Rows[e.RowIndex].Cells["statusDataGridViewTextBoxColumn"].Value.ToString() != "已领卡")
{
MessageBox.Show("还未领卡!");
return;
}
using (var mForm = new 输入消费金额())
{
long mId = Convert.ToInt64(dgvGiftStockOut.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value);
decimal mMoney = 0;
DateTime mBackDate;
if (mForm.ShowDialog() == DialogResult.OK)
{
mMoney = mForm.mMoney;
mBackDate = mForm.mBackTime;
//修改日期：2016/8/8 修改内容：添加超额提示
#region
String username; //销售姓名
String userid; //销售编号
String maxMoney; //销售剩余额度
username = dgvGiftStockOut.Rows[e.RowIndex].Cells["IntUsedID"].Value.ToString();
if (username == String.Empty)
{
MessageBox.Show("获取‘使用人’失败！");
return;
}
String sql = string.Format(@"SELECT id FROM dbo.T_Users WHERE UserName='******'", username);
userid = SqlHelper.ExecuteScalar(sql).ToString();
string mSql = string.Format(@"select ss.salesum - gs.GiftSum-ms.mealsum from (select isnull(sum(summoney)/200,0) salesum from T_Saledetails where saledate between (convert(varchar(4),getdate(),120) + '-01-01') and (convert(varchar(4),getdate(),120) + '-12-31') and username={0}) ss,(select isnull(sum(GiftSum),0) giftsum from t_GiftStockOut where userid={0} and datadate between (convert(varchar(4),getdate(),120) + '-01-01') and (convert(varchar(4),getdate(),120) + '-12-31') and status not in('已删除','审核未通过')) gs,(select isnull(sum(mealmoney),0) mealsum from t_meals where userid={0} and datadate between (convert(varchar(4),getdate(),120) + '-01-01') and (convert(varchar(4),getdate(),120) + '-12-31') and status <>'已删除') ms", userid);
maxMoney = SqlHelper.ExecuteScalar(mSql).ToString();
if ((Convert.ToDecimal(maxMoney) - Convert.ToDecimal(mMoney)) <= -5000)
{
DialogResult dr;
dr = MessageBox.Show("剩余额度已超5000元，是否继续报销", "超额提醒", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
if (dr == DialogResult.No)
{
return;
}
}
#endregion
using (SqlConnection mConn = new SqlConnection(Common.CommonClass.SqlConnStr))
{
mConn.Open();
using (SqlTransaction mTrans = mConn.BeginTransaction())
{
try
{
var adapter = new T_MealsTableAdapter();
adapter.Connection = mConn;
adapter.Transaction = mTrans;
int ret = adapter.BackCard(mBackDate, mMoney, mId);
if (ret > 0)
{
var adapter1 = new T_CardsTableAdapter();
adapter1.Connection = mConn;
adapter1.Transaction = mTrans;
long mCardId = Convert.ToInt64(dgvGiftStockOut.Rows[e.RowIndex].Cells["CardId"].Value);
ret = adapter1.BackCard(mMoney, mCardId);
if (ret > 0)
{
mTrans.Commit();
MessageBox.Show("还卡成功");
btnSearch_Click(sender, new EventArgs());
return;
}
else
{
mTrans.Rollback();
MessageBox.Show("还卡失败:2");
return;
}
}
else
{
mTrans.Rollback();
MessageBox.Show("还卡失败:1");
return;
}
}
catch (Exception ex)
{
mTrans.Rollback();
MessageBox.Show(ex.Message);
return;
}
}
}
}
}
}
}
