//销假主函数
public void CancelLeave(CancelLeaveDetailEntity model)
{
SqlConnection conn = new SqlConnection(SqlHelper.ConnString);
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
//第一步 操作TAB_LeaveMgr_CancelLeaveDetail，并修改人员表状态
AddCancelLeaveDetail(trans, model);
//第二步 操作TAB_LeaveMgr_AnnualLeave
new DBAnnualLeave().ExecuteUnLeave(trans, model);
//第三步 插入请销假消息
model.msgType = MSGTYPE.MSG_LEAVE;
string strMsg = AttentionMsg.ReturnStrJson(model);
CreatMsg(trans, strMsg);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
conn.Close();
}
}
}
/// <summary>
/// 添加消息
/// </summary>
/// <param name="trans"></param>
/// <param name="model"></param>
/// <param name="strAskLeaveGUID"></param>
private void CreatMsg(SqlTransaction trans, string strMsg)
{
AttentionMsg msg = new AttentionMsg();
msg.msgType = MSGTYPE.MSG_LEAVE;//请销假消息类别
msg.param = strMsg;
msg.CreatMsg(trans);
}
/// <summary>
/// 提交测酒记录
/// </summary>
/// <param name="?"></param>
public void SubmitDrink(MDDrink MDR, SqlTransaction trans)
{
#region 添加测酒记录
MDR.strPlaceName = MDR.strPlaceName != "" ? MDR.strPlaceName : getPlaceName(MDR.strPlaceID);
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("strTrainmanGUID", MDR.trainmanID),
new SqlParameter("dtCreateTime", MDR.createTime),
new SqlParameter("nVerifyID", MDR.verifyID),
new SqlParameter("strPlaceID", MDR.oPlaceId.ToString()),
new SqlParameter("strGUID", MDR.strGuid),
new SqlParameter("nDrinkResult", MDR.drinkResult),
new SqlParameter("strAreaGUID", MDR.strAreaGUID),
new SqlParameter("strDutyGUID", MDR.dutyUserID),
new SqlParameter("bLocalAreaTrainman", MDR.nLocalAreaTrainman),
new SqlParameter("strTrainmanName", MDR.strTrainmanName),
new SqlParameter("strTrainmanNumber", MDR.strTrainmanNumber),
new SqlParameter("strTrainNo", MDR.strTrainNo),
new SqlParameter("strTrainNumber", MDR.strTrainNumber),
new SqlParameter("strTrainTypeName", MDR.strTrainTypeName),
new SqlParameter("strWorkShopGUID", MDR.strWorkShopGUID),
new SqlParameter("strWorkShopName", MDR.strWorkShopName),
new SqlParameter("strPlaceIDs", MDR.strPlaceID),
new SqlParameter("strPlaceName", MDR.strPlaceName),
new SqlParameter("strSiteGUID", MDR.strSiteGUID),
new SqlParameter("strSiteName", MDR.strSiteName),
new SqlParameter("dwAlcoholicity", MDR.dwAlcoholicity),
new SqlParameter("strWorkID", MDR.strWorkID),
new SqlParameter("nWorkTypeID", MDR.nWorkTypeID),
new SqlParameter("strImagePath", MDR.imagePath),
new SqlParameter("strDepartmentID", MDR.strDepartmentID),
new SqlParameter("strDepartmentName", MDR.strDepartmentName),
new SqlParameter("nCadreTypeID", MDR.nCadreTypeID),
new SqlParameter("strCadreTypeName", MDR.strCadreTypeName)
};
string sqlText = @"insert into TAB_Drink_Information (strGUID,strTrainmanGUID,nDrinkResult,dtCreateTime,strAreaGUID,strDutyGUID,nVerifyID,strWorkID,nWorkTypeID,
strImagePath,strTrainmanName,strTrainmanNumber,strTrainNo,strTrainNumber,strTrainTypeName,strWorkShopGUID,strWorkShopName,strPlaceID,
strPlaceName,strSiteGUID,strSiteName,dwAlcoholicity,bLocalAreaTrainman,strDepartmentID,strDepartmentName,nCadreTypeID,strCadreTypeName)
values (@strGUID,@strTrainmanGUID,@nDrinkResult,@dtCreateTime,
@strAreaGUID,@strDutyGUID,@nVerifyID,@strWorkID,@nWorkTypeID,@strImagePath,@strTrainmanName,@strTrainmanNumber,
@strTrainNo,@strTrainNumber,@strTrainTypeName,@strWorkShopGUID,@strWorkShopName,@strPlaceIDs,@strPlaceName,@strSiteGUID,@strSiteName,
@dwAlcoholicity,@bLocalAreaTrainman,@strDepartmentID,@strDepartmentName,@nCadreTypeID,@strCadreTypeName)";
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sqlText, sqlParams);
#endregion
#region 插入消息记录
MDR.msgType = MSGTYPE.MSG_DRINK;
MDR.workTypeID = MDR.nWorkTypeID;
string strMsg = AttentionMsg.ReturnStrJson(MDR);
AttentionMsg msg = new AttentionMsg();
msg.msgType = MSGTYPE.MSG_DRINK;//测酒消息类别
msg.param = strMsg;
msg.CreatMsg(trans);
#endregion
}
/// <summary>
/// 更新数据
/// </summary>
public int AskLeave(LeaveApplyEntity model)
{
//判断人员机组是否处于调休状态
if (ISTXState(model.strTrainmanGUID))
{
return(2);
}
SqlConnection conn = new SqlConnection(SqlHelper.ConnString);
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
//第一步AddAskLeave
string strAskLeaveGUID = System.Guid.NewGuid().ToString();
model.strAskLeaveGUID = strAskLeaveGUID;
int obj = AddAskLeave(trans, model, strAskLeaveGUID);
if (obj > 0)
{
//第二步AddAskLeaveDetail
obj = AddAskLeaveDetail(trans, model, strAskLeaveGUID);
if (obj > 0)
{
//第三步DeleteTrainman
obj = DeleteTrainman(trans, model);
//第四步 插入请销假消息
model.msgType = MSGTYPE.MSG_LEAVE;
string strMsg = AttentionMsg.ReturnStrJson(model);
CreatMsg(trans, strMsg);
trans.Commit();
return(0);
}
}
trans.Rollback();
return(1);
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
trans.Dispose();
}
}
}
/// <summary>
/// 添加数据
/// </summary>
public bool AddDrinkInfo(DrinkInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Drink_Information");
strSql.Append("( strGUID,bLocalAreaTrainman,strTrainmanGUID,strTrainmanNumber,strTrainmanName ,dwAlcoholicity ,nDrinkResult,dtCreateTime ,");
strSql.Append(" strTrainNo , strTrainNumber , strTrainTypeName , strPlaceID , strPlaceName, strSiteGUID , strSiteNumber,strSiteName ,");
strSql.Append(" strWorkShopGUID , strWorkShopName ,strAreaGUID,strDutyNumber,strDutyName,nVerifyID,strWorkID,nWorkTypeID,strImagePath,strDepartmentID,strDepartmentName,nCadreTypeID,strCadreTypeName )");
strSql.Append("values (newid(),@bLocalAreaTrainman,@strTrainmanGUID,@strTrainmanNumber,@strTrainmanName,@dwAlcoholicity,@nDrinkResult,@dtCreateTime,");
strSql.Append(" @strTrainNo , @strTrainNumber , @strTrainTypeName , @strPlaceID , @strPlaceName, @strSiteGUID ,@strSiteNumber, @strSiteName ,");
strSql.Append(" @strWorkShopGUID , @strWorkShopName ,@strAreaGUID,@strDutyNumber,@strDutyName,@nVerifyID,@strWorkID,@nWorkTypeID,@strImagePath,@strDepartmentID,@strDepartmentName,@nCadreTypeID,@strCadreTypeName)");
SqlParameter[] parameters =
{
new SqlParameter("@bLocalAreaTrainman", model.bLocalAreaTrainman),
new SqlParameter("@strTrainmanGUID", model.strTrainmanGUID),
new SqlParameter("@strTrainmanNumber", model.strTrainmanNumber),
new SqlParameter("@strTrainmanName", model.strTrainmanName),
new SqlParameter("@dwAlcoholicity", model.dwAlcoholicity.ToString()),
new SqlParameter("@nDrinkResult", model.nDrinkResult),
new SqlParameter("@dtCreateTime", model.dtCreateTime),
new SqlParameter("@strTrainNo", model.strTrainNo),
new SqlParameter("@strTrainNumber", model.strTrainNumber),
new SqlParameter("@strTrainTypeName", model.strTrainTypeName),
new SqlParameter("@strPlaceID", model.strPlaceID),
new SqlParameter("@strPlaceName", model.strPlaceName),
new SqlParameter("@strSiteGUID", model.strSiteGUID),
new SqlParameter("@strSiteNumber", model.strSiteNumber),
new SqlParameter("@strSiteName", model.strSiteName),
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("@strWorkShopName", model.strWorkShopName),
new SqlParameter("@strAreaGUID", model.strAreaGUID),
new SqlParameter("@strDutyNumber", model.strDutyNumber),
new SqlParameter("@strDutyName", model.strDutyName),
new SqlParameter("@nVerifyID", model.nVerifyID),
new SqlParameter("@strWorkID", model.strWorkID),
new SqlParameter("@nWorkTypeID", model.nWorkTypeID),
new SqlParameter("@strImagePath", model.strImagePath),
new SqlParameter("strDepartmentID", model.strDepartmentID),
new SqlParameter("strDepartmentName", model.strDepartmentName),
new SqlParameter("nCadreTypeID", model.nCadreTypeID),
new SqlParameter("strCadreTypeName", model.strCadreTypeName)
//new SqlParameter("@strWorkTypeName", model.strWorkTypeName),
//new SqlParameter("@strDrinkResultName", model.strDrinkResultName),
//new SqlParameter("@strVerifyName", model.strVerifyName),
//new SqlParameter("@strDutyGUID", model.strDutyGUID),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters);
#region 插入消息记录
MDDrink4Msg MDMsg = new MDDrink4Msg();
MDMsg = this.getModel(model);
string strMsg = AttentionMsg.ReturnStrJson(MDMsg);
AttentionMsg msg = new AttentionMsg();
msg.msgType = MSGTYPE.MSG_DRINK;//测酒消息类别
msg.param = strMsg;
msg.CreatMsg();
#endregion
return(true);
}
/// <summary>
/// 添加数据
/// </summary>
public bool AddDrinkInfo(MDBianXie.DrinkInfo model)
{
SqlTrans sqltrans = new SqlTrans();
sqltrans.Begin();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Drink_Information");
strSql.Append("( strGUID,bLocalAreaTrainman,strTrainmanGUID,strTrainmanNumber,strTrainmanName ,dwAlcoholicity ,nDrinkResult,dtCreateTime ,");
strSql.Append(" strTrainNo , strTrainNumber , strTrainTypeName , strPlaceID , strPlaceName, strSiteGUID , strSiteNumber,strSiteName ,");
strSql.Append(" strWorkShopGUID , strWorkShopName ,strAreaGUID,strDutyNumber,strDutyName,nVerifyID,strWorkID,nWorkTypeID,strImagePath,strDepartmentID,strDepartmentName,nCadreTypeID,strCadreTypeName )");
strSql.Append("values (newid(),@bLocalAreaTrainman,@strTrainmanGUID,@strTrainmanNumber,@strTrainmanName,@dwAlcoholicity,@nDrinkResult,@dtCreateTime,");
strSql.Append(" @strTrainNo , @strTrainNumber , @strTrainTypeName , @strPlaceID , @strPlaceName, @strSiteGUID ,@strSiteNumber, @strSiteName ,");
strSql.Append(" @strWorkShopGUID , @strWorkShopName ,@strAreaGUID,@strDutyNumber,@strDutyName,@nVerifyID,@strWorkID,@nWorkTypeID,@strImagePath,@strDepartmentID,@strDepartmentName,@nCadreTypeID,@strCadreTypeName)");
SqlParameter[] parameters =
{
new SqlParameter("@bLocalAreaTrainman", model.bLocalAreaTrainman),
new SqlParameter("@strTrainmanGUID", model.strTrainmanGUID),
new SqlParameter("@strTrainmanNumber", model.strTrainmanNumber),
new SqlParameter("@strTrainmanName", model.strTrainmanName),
new SqlParameter("@dwAlcoholicity", model.dwAlcoholicity),
new SqlParameter("@nDrinkResult", model.nDrinkResult),
new SqlParameter("@dtCreateTime", model.dtCreateTime),
new SqlParameter("@strTrainNo", model.strTrainNo),
new SqlParameter("@strTrainNumber", model.strTrainNumber),
new SqlParameter("@strTrainTypeName", model.strTrainTypeName),
new SqlParameter("@strPlaceID", model.strPlaceID),
new SqlParameter("@strPlaceName", model.strPlaceName),
new SqlParameter("@strSiteGUID", model.strSiteGUID),
new SqlParameter("@strSiteNumber", model.strSiteNumber),
new SqlParameter("@strSiteName", model.strSiteName),
new SqlParameter("@strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("@strWorkShopName", model.strWorkShopName),
new SqlParameter("@strAreaGUID", model.strAreaGUID),
new SqlParameter("@strDutyNumber", model.strDutyNumber),
new SqlParameter("@strDutyName", model.strDutyName),
new SqlParameter("@nVerifyID", model.nVerifyID),
new SqlParameter("@strWorkID", model.strWorkID),
new SqlParameter("@nWorkTypeID", model.nWorkTypeID),
new SqlParameter("@strImagePath", model.strImagePath),
new SqlParameter("strDepartmentID", model.strDepartmentID),
new SqlParameter("strDepartmentName", model.strDepartmentName),
new SqlParameter("nCadreTypeID", model.nCadreTypeID),
new SqlParameter("strCadreTypeName", model.strCadreTypeName)
};
SqlHelper.ExecuteNonQuery(sqltrans.trans, CommandType.Text, strSql.ToString(), parameters);
#region 插入消息记录
string strMsg = Newtonsoft.Json.JsonConvert.SerializeObject(model);
AttentionMsg msg = new AttentionMsg();
msg.msgType = MSGTYPE.MSG_DRINK;//测酒消息类别
msg.param = strMsg;
msg.CreatMsg(sqltrans.trans);
#endregion
sqltrans.Commit();
return(true);
}
catch (Exception ex)
{
sqltrans.RollBack();
throw ex;
}
}
