/// <summary>
/// 更新审核状态
/// </summary>
/// <param name="MODELDAYCHECKPERSONAL"></param>
/// <returns></returns>
public bool UpdateCheckState(MODELDAYCHECKPERSONAL MODELDAYCHECKPERSONAL)
{
StringBuilder str = new StringBuilder();
str.Append("UPDATE DAYCHECKPERSONAL SET CHECKERID=@CHECKERID,CHECKERNAME=@CHECKERNAME,CHECKDATETIME=@CHECKDATETIME WHERE DAYCHECKID=@DAYCHECKID");
SqlParameter[] para =
{
new SqlParameter("@CHECKERID", SqlDbType.VarChar, 30),
new SqlParameter("@CHECKERNAME", SqlDbType.VarChar, 50),
new SqlParameter("@CHECKDATETIME", SqlDbType.DateTime),
new SqlParameter("@DAYCHECKID", SqlDbType.VarChar, 30),
};
para[0].Value = MODELDAYCHECKPERSONAL.CHECKERID;
para[1].Value = MODELDAYCHECKPERSONAL.CHECKERNAME;
if (MODELDAYCHECKPERSONAL.CHECKERID == null)
{
para[2].Value = null;
}
else
{
para[2].Value = MODELDAYCHECKPERSONAL.CHECKDATETIME;
}
para[3].Value = MODELDAYCHECKPERSONAL.DAYCHECKID;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
private void btUnCheck_Click(object sender, EventArgs e)
{
if (dgList.Rows.Count <= 1)
{
mes.Show("没有可反审核的日结数据!");
return;
}
if (dgList.SelectedRows.Count == 0)
{
mes.Show("请选择要反审核的日结数据!");
return;
}
try
{
for (int i = 0; i < dgList.SelectedRows.Count; i++)
{
object objID = dgList.SelectedRows[i].Cells["DAYCHECKID"].Value;
if (objID != null && objID != DBNull.Value)
{
MODELDAYCHECKPERSONAL MODELDAYCHECKPERSONAL = new MODELDAYCHECKPERSONAL();
MODELDAYCHECKPERSONAL.DAYCHECKID = objID.ToString();
MODELDAYCHECKPERSONAL.CHECKERID = null;
MODELDAYCHECKPERSONAL.CHECKERNAME = null;
MODELDAYCHECKPERSONAL.CHECKDATETIME = mes.GetDatetimeNow();
if (BLLDAYCHECKPERSONAL.UpdateCheckState(MODELDAYCHECKPERSONAL))
{
//dgList.SelectedRows[i].Cells["CHECKERID"].Value = strLogID;
dgList.SelectedRows[i].Cells["CHECKERNAME"].Value = null;
dgList.SelectedRows[i].Cells["CHECKDATETIME"].Value = DBNull.Value;
}
else
{
mes.Show("更新日结单据'" + MODELDAYCHECKPERSONAL.DAYCHECKID + "'的审核状态失败,请重新查询后重试!");
return;
}
}
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
}
public bool Insert(MODELDAYCHECKPERSONAL MODELDAYCHECKPERSONAL)
{
StringBuilder str = new StringBuilder();
str.Append(
"INSERT INTO DAYCHECKPERSONAL(DAYCHECKID,DAYCHECKDATEIME,DAYCHECKWORKERID,DAYCHECKWORKERNAME," +
"DAYCHECKSUMMONEY,DAYCHECKMONEY,DAYCHECKPOS,DAYCHECKZHUANZHANG,RECEIPTNOCOUNT,INVOICENOCOUNT,MEMO) " +
"VALUES(@DAYCHECKID,@DAYCHECKDATEIME,@DAYCHECKWORKERID,@DAYCHECKWORKERNAME," +
"@DAYCHECKSUMMONEY,@DAYCHECKMONEY,@DAYCHECKPOS,@DAYCHECKZHUANZHANG,@RECEIPTNOCOUNT,@INVOICENOCOUNT,@MEMO) "
);
SqlParameter[] para =
{
new SqlParameter("@DAYCHECKID", SqlDbType.VarChar, 50),
new SqlParameter("@DAYCHECKDATEIME", SqlDbType.DateTime),
new SqlParameter("@DAYCHECKWORKERID", SqlDbType.VarChar, 50),
new SqlParameter("@DAYCHECKWORKERNAME", SqlDbType.VarChar, 50),
new SqlParameter("@DAYCHECKSUMMONEY", SqlDbType.Decimal),
new SqlParameter("@DAYCHECKMONEY", SqlDbType.Decimal),
new SqlParameter("@DAYCHECKPOS", SqlDbType.Decimal),
new SqlParameter("@DAYCHECKZHUANZHANG", SqlDbType.Decimal),
new SqlParameter("@RECEIPTNOCOUNT", SqlDbType.Int),
new SqlParameter("@INVOICENOCOUNT", SqlDbType.Int),
new SqlParameter("@MEMO", SqlDbType.VarChar, 50)
};
para[0].Value = MODELDAYCHECKPERSONAL.DAYCHECKID;
para[1].Value = MODELDAYCHECKPERSONAL.DAYCHECKDATEIME;
para[2].Value = MODELDAYCHECKPERSONAL.DAYCHECKWORKERID;
para[3].Value = MODELDAYCHECKPERSONAL.DAYCHECKWORKERNAME;
para[4].Value = MODELDAYCHECKPERSONAL.DAYCHECKSUMMONEY;
para[5].Value = MODELDAYCHECKPERSONAL.DAYCHECKMONEY;
para[6].Value = MODELDAYCHECKPERSONAL.DAYCHECKPOS;
para[7].Value = MODELDAYCHECKPERSONAL.DAYCHECKZHUANZHANG;
para[8].Value = MODELDAYCHECKPERSONAL.RECEIPTNOCOUNT;
para[9].Value = MODELDAYCHECKPERSONAL.INVOICENOCOUNT;
para[10].Value = MODELDAYCHECKPERSONAL.MEMO;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
private void toolDayCheck_Click(object sender, EventArgs e)
{
try
{
if (cmbChargerWorkName.SelectedValue == null || cmbChargerWorkName.SelectedValue == DBNull.Value)
{
mes.Show("请选择收款员查询收款数据后再执行日结操作!");
return;
}
string strFilterCheck = " AND DAYCHECKSTATE='1' " + txtFilter.Text;
DataTable dtDaychecked = BLLWATERFEECHARGE.QueryWaterFeeAndPrestoreCharge(strFilterCheck);
if (dtDaychecked.Rows.Count > 0)
{
mes.Show("本次查询含有已日结的数据,请删除历史日结信息或重新查询未日结信息后再日结!");
return;
}
//string strFilter = " AND DAYCHECKSTATE<>'1' ";
string strFilter = txtFilter.Text;
DataTable dtDayUnchecked = BLLWATERFEECHARGE.QueryWaterFeeAndPrestoreCharge(strFilter);
if (dtDayUnchecked.Rows.Count == 0)
{
mes.Show("未找到未日结的收费数据!");
return;
}
DateTime dtNow = mes.GetDatetimeNow();
MODELDAYCHECKPERSONAL MODELDAYCHECKPERSONAL = new MODELDAYCHECKPERSONAL();
MODELDAYCHECKPERSONAL.DAYCHECKID = GETTABLEID.GetTableID(strLogID, "DAYCHECKPERSONAL");
MODELDAYCHECKPERSONAL.DAYCHECKWORKERID = cmbChargerWorkName.SelectedValue.ToString();
MODELDAYCHECKPERSONAL.DAYCHECKWORKERNAME = cmbChargerWorkName.Text;
MODELDAYCHECKPERSONAL.DAYCHECKDATEIME = dtNow;
MODELDAYCHECKPERSONAL.DAYCHECKSUMMONEY = decBCSS;
MODELDAYCHECKPERSONAL.DAYCHECKMONEY = decYSBCSSXJ + decYCBCSZXJ;
MODELDAYCHECKPERSONAL.DAYCHECKPOS = decYSBCSSPOS + decYCBCSZPOS;
MODELDAYCHECKPERSONAL.DAYCHECKZHUANZHANG = decYSBCSSZHUANZHANG + decYCBCSZZHUANZHANG;
MODELDAYCHECKPERSONAL.RECEIPTNOCOUNT = intYSRECEIPRNOCOUNT + intYCCount;
MODELDAYCHECKPERSONAL.INVOICENOCOUNT = intYSCount;
MODELDAYCHECKPERSONAL.MEMO = null;
if (BLLDAYCHECKPERSONAL.Insert(MODELDAYCHECKPERSONAL))
{
try
{
string strFilterCanDayCheck = " AND CHARGEID IN (SELECT CHARGEID FROM V_WATERFEEANDPRESTORECHARGE WHERE 1=1 " + strFilter + ")";
MODELWATERFEECHARGE MODELWATERFEECHARGE = new MODELWATERFEECHARGE();
MODELWATERFEECHARGE.DAYCHECKSTATE = "1";
MODELWATERFEECHARGE.DAYCHECKWORKERNAME = MODELDAYCHECKPERSONAL.DAYCHECKWORKERNAME;
MODELWATERFEECHARGE.DAYCHECKDATETIME = dtNow;
MODELWATERFEECHARGE.DAYCHECKID = MODELDAYCHECKPERSONAL.DAYCHECKID;
int intCount = BLLWATERFEECHARGE.UpdateDayCheckState(MODELWATERFEECHARGE, strFilterCanDayCheck);
mes.Show("生成日结报表成功!");
}
catch (Exception ex)
{
mes.Show("更新日结标志失败,原因:" + ex.Message);
log.Write(ex.ToString(), MsgType.Error);
BLLDAYCHECKPERSONAL.Delete(MODELDAYCHECKPERSONAL.DAYCHECKID);
}
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
}
private void btUnCheck_Click(object sender, EventArgs e)
{
if (dgDayCheckList.Rows.Count <= 1)
{
mes.Show("没有可反日结的日结数据!");
return;
}
if (dgDayCheckList.SelectedRows.Count == 0)
{
mes.Show("请选择要反日结的日结数据!");
return;
}
for (int i = 0; i < dgDayCheckList.SelectedRows.Count; i++)
{
string strDayCheckID = "";
object objDayCheckID = dgDayCheckList.SelectedRows[i].Cells["DAYCHECKID"].Value;
if (objDayCheckID != null && objDayCheckID != DBNull.Value)
{
strDayCheckID = objDayCheckID.ToString();
}
object objID = dgDayCheckList.SelectedRows[i].Cells["CHECKERNAME"].Value;
if (objID != null && objID != DBNull.Value)
{
mes.Show("日结流水号'" + strDayCheckID + "'对应的收费单据已由核算员审核，无法反日结!");
return;
}
}
try
{
for (int i = dgDayCheckList.SelectedRows.Count - 1; i >= 0; i--)
{
object objID = dgDayCheckList.SelectedRows[i].Cells["DAYCHECKID"].Value;
if (objID != null && objID != DBNull.Value)
{
MODELDAYCHECKPERSONAL MODELDAYCHECKPERSONAL = new MODELDAYCHECKPERSONAL();
MODELDAYCHECKPERSONAL.DAYCHECKID = objID.ToString();
if (BLLDAYCHECKPERSONAL.Delete(MODELDAYCHECKPERSONAL.DAYCHECKID))
{
string strSQLUncheckWaterFee = "UPDATE WATERFEECHARGE SET DAYCHECKWORKERNAME=NULL,DAYCHECKSTATE='0',DAYCHECKDATETIME=NULL," +
"DAYCHECKID=NULL WHERE DAYCHECKID='" + objID.ToString() + "'";
try
{
int intCount = BLLDAYCHECKPERSONAL.Excute(strSQLUncheckWaterFee);
if (intCount == 0)
{
mes.Show("日结流水号'" + objID.ToString() + "'对应的收费单据反日结失败,请重试!");
return;
}
dgDayCheckList.Rows.Remove(dgDayCheckList.SelectedRows[i]);
}
catch (Exception ex)
{
mes.Show("日结流水号'" + objID.ToString() + "'对应的收费单据反日结失败,原因:\r\n" + ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
}
else
{
mes.Show("更新日结单据'" + MODELDAYCHECKPERSONAL.DAYCHECKID + "'的审核状态失败,请重新查询后重试!");
return;
}
}
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
}
private void btCheck_Click(object sender, EventArgs e)
{
try
{
//if (cmbChargerWorkName.SelectedValue == null || cmbChargerWorkName.SelectedValue == DBNull.Value)
//{
// mes.Show("请选择收款员查询收款数据后再执行日结操作!");
// return;
//}
//string strFilter = " AND DAYCHECKSTATE<>'1' ";
//if (txtFilter.Text == "")
// strFilter += " AND CHARGEWORKERID='" + cmbChargerWorkName.SelectedValue.ToString() + "'";
//else
// strFilter += txtFilter.Text;
//DataTable dtDayUnchecked = BLLWATERFEECHARGE.QueryWaterFeeAndPrestoreCharge(strFilter);
//if (dtDayUnchecked.Rows.Count == 0)
//{
// mes.Show("未找到未日结的收费数据!");
// return;
//}
//DateTime dtNow = mes.GetDatetimeNow();
//MODELDAYCHECKPERSONAL MODELDAYCHECKPERSONAL = new MODELDAYCHECKPERSONAL();
//MODELDAYCHECKPERSONAL.DAYCHECKID = GETTABLEID.GetTableID(strLogID, "DAYCHECKPERSONAL");
//MODELDAYCHECKPERSONAL.DAYCHECKWORKERID = cmbChargerWorkName.SelectedValue.ToString();
//MODELDAYCHECKPERSONAL.DAYCHECKWORKERNAME = cmbChargerWorkName.Text;
//MODELDAYCHECKPERSONAL.DAYCHECKDATEIME = dtNow;
//MODELDAYCHECKPERSONAL.DAYCHECKSUMMONEY = decBCSS;
//MODELDAYCHECKPERSONAL.DAYCHECKMONEY = decYSBCSSXJ + decYCBCSZXJ;
//MODELDAYCHECKPERSONAL.DAYCHECKPOS = decYSBCSSPOS + decYCBCSZPOS;
//MODELDAYCHECKPERSONAL.DAYCHECKZHUANZHANG = decYSBCSSZHUANZHANG + decYCBCSZZHUANZHANG;
//MODELDAYCHECKPERSONAL.RECEIPTNOCOUNT = intYSRECEIPRNOCOUNT + intYCCount;
//MODELDAYCHECKPERSONAL.INVOICENOCOUNT = intYSCount;
//MODELDAYCHECKPERSONAL.MEMO = null;
//if (BLLDAYCHECKPERSONAL.Insert(MODELDAYCHECKPERSONAL))
//{
// try
// {
// MODELWATERFEECHARGE MODELWATERFEECHARGE = new MODELWATERFEECHARGE();
// MODELWATERFEECHARGE.DAYCHECKSTATE = "1";
// MODELWATERFEECHARGE.DAYCHECKWORKERNAME = MODELDAYCHECKPERSONAL.DAYCHECKWORKERNAME;
// MODELWATERFEECHARGE.DAYCHECKDATETIME = dtNow;
// MODELWATERFEECHARGE.DAYCHECKID = MODELDAYCHECKPERSONAL.DAYCHECKID;
// int intCount = BLLWATERFEECHARGE.UpdateDayCheckState(MODELWATERFEECHARGE, strFilter);
// mes.Show("生成日结报表成功!");
// }
// catch (Exception ex)
// {
// mes.Show("更新日结标志失败,原因:" + ex.Message);
// log.Write(ex.ToString(), MsgType.Error);
// BLLDAYCHECKPERSONAL.Delete(MODELDAYCHECKPERSONAL.DAYCHECKID);
// }
//}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
if (dgDayCheckList.Rows.Count <= 1)
{
mes.Show("没有可审核的日结数据!");
return;
}
if (dgDayCheckList.SelectedRows.Count == 0)
{
mes.Show("请选择要审核的日结数据!");
return;
}
try
{
for (int i = 0; i < dgDayCheckList.SelectedRows.Count; i++)
{
object objID = dgDayCheckList.SelectedRows[i].Cells["DAYCHECKID"].Value;
if (objID != null && objID != DBNull.Value)
{
MODELDAYCHECKPERSONAL MODELDAYCHECKPERSONAL = new MODELDAYCHECKPERSONAL();
MODELDAYCHECKPERSONAL.DAYCHECKID = objID.ToString();
MODELDAYCHECKPERSONAL.CHECKERID = strLogID;
MODELDAYCHECKPERSONAL.CHECKERNAME = strUserName;
MODELDAYCHECKPERSONAL.CHECKDATETIME = mes.GetDatetimeNow();
if (BLLDAYCHECKPERSONAL.UpdateCheckState(MODELDAYCHECKPERSONAL))
{
//dgList.SelectedRows[i].Cells["CHECKERID"].Value = strLogID;
dgDayCheckList.SelectedRows[i].Cells["CHECKERNAME"].Value = strUserName;
dgDayCheckList.SelectedRows[i].Cells["CHECKDATETIME"].Value = MODELDAYCHECKPERSONAL.CHECKDATETIME;
}
else
{
mes.Show("更新日结单据'" + MODELDAYCHECKPERSONAL.DAYCHECKID + "'的审核状态失败,请重新查询后重试!");
return;
}
}
}
}
catch (Exception ex)
{
mes.Show(ex.Message);
log.Write(ex.ToString(), MsgType.Error);
}
}
