/// <summary>
/// 发放单个支部的经费
/// </summary>
/// <param name="OID"></param>
/// <param name="OP_ADMIN"></param>
/// <param name="OL_NUM"></param>
/// <returns></returns>
public int PublishOne(string OL_OID)
{
PublishOneCommand.Parameters[0].Value = OL_OID;
PublishOneCommand.Parameters[1].Value = AuthenUser.GetCurrentUser().UserID;
return(AdapterHelper.ExecuteCommand(PublishOneCommand));
}
public virtual int MyUpdate(string OID, string CAT_NAME, string POST_NAME)
{
if (OID == null)
{
throw new global::System.ArgumentNullException("OID");
}
else
{
MyUpdateSqlComand.Parameters[0].Value = OID;
}
if (CAT_NAME == null)
{
throw new global::System.ArgumentNullException("CAT_NAME");
}
else
{
MyUpdateSqlComand.Parameters[1].Value = CAT_NAME;
}
if (POST_NAME == null)
{
throw new global::System.ArgumentNullException("POST_NAME");
}
else
{
MyUpdateSqlComand.Parameters[2].Value = POST_NAME;
}
return(AdapterHelper.ExecuteCommand(MyUpdateSqlComand));
}
/// <summary>
/// 修改用户登录密码
/// </summary>
/// <returns></returns>
public int ChangePassword(string OID, string PAS_WORD)
{
ChangePasswordComand.Parameters[0].Value = PAS_WORD;
ChangePasswordComand.Parameters[1].Value = OID;
return(AdapterHelper.ExecuteCommand(ChangePasswordComand));
}
/// <summary>
/// 发放单个支部的经费
/// </summary>
/// <param name="OID"></param>
/// <param name="OP_ADMIN"></param>
/// <param name="OL_NUM"></param>
/// <returns></returns>
public int OutlayRemark(string YG_NAME, decimal OL_SL, decimal OL_ZC, decimal OL_LEFT, string OL_DESC, string OID)
{
OutlayRemarkCommand.Parameters[0].Value = OID;
OutlayRemarkCommand.Parameters[1].Value = OL_DESC;
return(AdapterHelper.ExecuteCommand(OutlayRemarkCommand));
}
/// <summary>
/// 更新支部的年度金费
/// </summary>
/// <param name="OID"></param>
/// <param name="OP_ADMIN"></param>
/// <param name="OL_NUM"></param>
/// <returns></returns>
public int MyUpdate(string YG_NAME, decimal OL_NUM, string OID)
{
MyUpdateCommand.Parameters[0].Value = OID;
MyUpdateCommand.Parameters[1].Value = AuthenUser.GetCurrentUser().UserID;
MyUpdateCommand.Parameters[2].Value = OL_NUM;
return(AdapterHelper.ExecuteCommand(MyUpdateCommand));
}
/// <summary>
/// 改变组织的顺序
/// </summary>
/// <param name="MOVE_OID">需要改变顺序的组织</param>
/// <param name="AFTER_OID">调整后组织的前一个节点</param>
/// <param name="PARENT_OID">父节点</param>
/// <returns></returns>
public int MoveNode(string MOVE_OID, string AFTER_OID, string PARENT_OID)
{
MoveNodeSqlComand.Parameters[0].Value = MOVE_OID;
MoveNodeSqlComand.Parameters[1].Value = AFTER_OID;
MoveNodeSqlComand.Parameters[2].Value = PARENT_OID;
return(AdapterHelper.ExecuteCommand(MoveNodeSqlComand));
}
/// <summary>
/// 修改经费使用明细
/// </summary>
/// <returns></returns>
public int MyUpdate(string YG_NAME, decimal OU_JY, decimal OU_SL, decimal OU_ZC, string OU_DESC, DateTime OU_DATE, string OID)
{
MyUpdateCommand.Parameters[0].Value = OID;
MyUpdateCommand.Parameters[1].Value = OU_SL;
MyUpdateCommand.Parameters[2].Value = OU_ZC;
return(AdapterHelper.ExecuteCommand(MyUpdateCommand));
}
/// <summary>
/// 团员转出
/// </summary>
/// <param name="MM_OID">团员OID</param>
/// <param name="CYG_OID">转入团支部OID</param>
/// <returns></returns>
public int ChangeYG(string MM_OID, string YG_OID, string OP_ADMIN)
{
ChangeYGComand.Parameters[0].Value = MM_OID;
ChangeYGComand.Parameters[1].Value = YG_OID;
ChangeYGComand.Parameters[2].Value = OP_ADMIN;
NotificationTableAdapter.ClearNfCache();
return(AdapterHelper.ExecuteCommand(ChangeYGComand));
}
/// <summary>
/// 记录经费使用明细
/// </summary>
/// <returns></returns>
public int NewOutLayUse(string YG_OID, string OU_TYPE, decimal OU_NUM, string OU_DESC, string OU_ADMIN)
{
NewOutlayUseComand.Parameters[0].Value = YG_OID;
NewOutlayUseComand.Parameters[1].Value = OU_TYPE;
NewOutlayUseComand.Parameters[2].Value = OU_NUM;
NewOutlayUseComand.Parameters[3].Value = OU_DESC;
NewOutlayUseComand.Parameters[4].Value = OU_ADMIN;
return(AdapterHelper.ExecuteCommand(NewOutlayUseComand));
}
/// <summary>
/// 修改获奖情况
/// </summary>
/// <param name="YG_OID"></param>
/// <param name="BA_NUM"></param>
/// <param name="BA_DESC"></param>
/// <param name="BA_STATUS"></param>
/// <param name="OID"></param>
/// <returns></returns>
public int MyUpdate(string PR_NAME, decimal PR_VALUE, string PR_UNIT, DateTime PR_DATE, string OID)
{
MyUpdateSqlComand.Parameters[0].Value = OID;
MyUpdateSqlComand.Parameters[1].Value = PR_VALUE;
MyUpdateSqlComand.Parameters[2].Value = PR_NAME;
MyUpdateSqlComand.Parameters[3].Value = PR_UNIT;
MyUpdateSqlComand.Parameters[4].Value = PR_DATE;
return(AdapterHelper.ExecuteCommand(MyUpdateSqlComand));
}
public virtual int MyUpdate(string OID, string LOG_NAME, string PAS_WORD, string ROL_NAME, string YG_OID)
{
if (OID == null)
{
throw new global::System.ArgumentNullException("OID");
}
else
{
MyUpdateSqlComand.Parameters[0].Value = OID;
}
if (LOG_NAME == null)
{
throw new global::System.ArgumentNullException("LOG_NAME");
}
else
{
MyUpdateSqlComand.Parameters[1].Value = LOG_NAME;
}
if (PAS_WORD == null)
{
throw new global::System.ArgumentNullException("PAS_WORD");
}
else if (PAS_WORD == "PAS_WORD_TONY")
{
MyUpdateSqlComand.Parameters[2].Value = PAS_WORD;
}
else
{
//--对密码进行加密存储
MyUpdateSqlComand.Parameters[2].Value = AdapterHelper.Hash(PAS_WORD);
}
if (ROL_NAME == null)
{
throw new global::System.ArgumentNullException("ROL_NAME");
}
else
{
MyUpdateSqlComand.Parameters[3].Value = ROL_NAME;
}
if (YG_OID == null)
{
throw new global::System.ArgumentNullException("YG_OID");
}
else
{
MyUpdateSqlComand.Parameters[4].Value = YG_OID;
}
return(AdapterHelper.ExecuteCommand(MyUpdateSqlComand));
}
public int MyDelete(string OID)
{
if ((OID == null))
{
throw new global::System.ArgumentNullException("OID");
}
else
{
MyDeleteSqlComand.Parameters[0].Value = OID;
}
return(AdapterHelper.ExecuteCommand(MyDeleteSqlComand));
}
/// <summary>
/// 对通知进行操作
/// </summary>
public int NotifiationOp(string NF_OID, string NF_CAT, string OP_ADMIN, string MM_OID
, string YG_OID, string FZ_OID, string DP_NAME, string KS_NAME, string PS_NAME)
{
NotifiationOpSqlComand.Parameters[0].Value = NF_OID;
NotifiationOpSqlComand.Parameters[1].Value = NF_CAT;
NotifiationOpSqlComand.Parameters[2].Value = OP_ADMIN;
NotifiationOpSqlComand.Parameters[3].Value = MM_OID;
NotifiationOpSqlComand.Parameters[4].Value = YG_OID;
NotifiationOpSqlComand.Parameters[5].Value = FZ_OID;
NotifiationOpSqlComand.Parameters[6].Value = DP_NAME;
NotifiationOpSqlComand.Parameters[7].Value = KS_NAME;
NotifiationOpSqlComand.Parameters[8].Value = PS_NAME;
ClearNfCache();
return(AdapterHelper.ExecuteCommand(NotifiationOpSqlComand));
}
public int ChangeStatus(string MM_OID, string HrStatus)
{
SqlCommand comm = new SqlCommand();
comm.Connection = this.Connection;
comm.CommandText = "UPDATE dbo.Member SET HrStatus = @HrStatus WHERE OID = @MM_OID";
comm.CommandType = System.Data.CommandType.Text;
comm.Parameters.Add("@HrStatus", System.Data.SqlDbType.NVarChar, 50);
comm.Parameters.Add("@MM_OID", System.Data.SqlDbType.NVarChar, 50);
comm.Parameters[0].Value = HrStatus;
comm.Parameters[1].Value = MM_OID;
NotificationTableAdapter.ClearNfCache();
return(AdapterHelper.ExecuteCommand(comm));
}
/// <summary>
/// 修改支部月度预算
/// </summary>
/// <param name="YG_OID"></param>
/// <param name="BA_NUM"></param>
/// <param name="BA_DESC"></param>
/// <param name="BA_STATUS"></param>
/// <param name="OID"></param>
/// <returns></returns>
public int MyUpdate(string YG_OID, DateTime CRE_DATE, decimal BA_NUM, string YJ_MONTH, string BA_DESC, string BA_STATUS, string SP_REASON, string OID)
{
string roleName = AuthenUser.GetCurrentUser().RoleName;
//if (roleName != AuthenUserType.TW_Finance && roleName != AuthenUserType.Admin && roleName != AuthenUserType.TW_Admin
// && BA_STATUS != "等待审核中")
// return 0;
MyUpdateSqlComand.Parameters[0].Value = OID;
MyUpdateSqlComand.Parameters[1].Value = BA_NUM;
MyUpdateSqlComand.Parameters[2].Value = BA_DESC;
MyUpdateSqlComand.Parameters[3].Value = BA_STATUS;
MyUpdateSqlComand.Parameters[4].Value = AuthenUser.GetCurrentUser().UserID;
MyUpdateSqlComand.Parameters[5].Value = YJ_MONTH;
MyUpdateSqlComand.Parameters[6].Value = String.IsNullOrEmpty(SP_REASON) ? String.Empty : SP_REASON;
return(AdapterHelper.ExecuteCommand(MyUpdateSqlComand));
}
public virtual int MyUpdate(string OID, string SE_TYPE, string SE_KEY, string SE_VALUE)
{
if (OID == null)
{
throw new global::System.ArgumentNullException("OID");
}
else
{
MyUpdateSqlComand.Parameters[0].Value = OID;
}
if (SE_TYPE == null)
{
throw new global::System.ArgumentNullException("SE_TYPE");
}
else
{
MyUpdateSqlComand.Parameters[1].Value = SE_TYPE;
}
if (SE_KEY == null)
{
throw new global::System.ArgumentNullException("SE_KEY");
}
else
{
MyUpdateSqlComand.Parameters[2].Value = SE_KEY;
}
if (SE_VALUE == null)
{
throw new global::System.ArgumentNullException("SE_VALUE");
}
else
{
MyUpdateSqlComand.Parameters[3].Value = SE_VALUE;
}
return(AdapterHelper.ExecuteCommand(MyUpdateSqlComand));
}
public int MyInsert(string OG_NAME, string PARENT_OID, DateTime CRE_DATE)
{
if (OG_NAME == null)
{
throw new global::System.ArgumentNullException("OG_NAME");
}
else
{
MyInsertSqlComand.Parameters[0].Value = OG_NAME;
}
if (PARENT_OID == null)
{
throw new global::System.ArgumentNullException("PARENT_OID");
}
else
{
MyInsertSqlComand.Parameters[1].Value = PARENT_OID;
}
return(AdapterHelper.ExecuteCommand(MyInsertSqlComand));
}
public virtual int MyUpdate(string OID, string YG_NAME, DateTime CRE_DATE)
{
if (OID == null)
{
throw new global::System.ArgumentNullException("OID");
}
else
{
MyUpdateSqlComand.Parameters[0].Value = OID;
}
if (YG_NAME == null)
{
throw new global::System.ArgumentNullException("YG_NAME");
}
else
{
MyUpdateSqlComand.Parameters[1].Value = YG_NAME;
}
return(AdapterHelper.ExecuteCommand(MyUpdateSqlComand));
}
/// <summary>
/// 删除经费使用明细
/// </summary>
/// <returns></returns>
public int DeleteOutlayUse(string OID)
{
MyDeleteCommand.Parameters[0].Value = OID;
return(AdapterHelper.ExecuteCommand(MyDeleteCommand));
}
/// <summary>
/// 删除本支部已审批预算通知
/// </summary>
/// <param name="OID"></param>
/// <returns></returns>
public int DeleteAuditApply(string YG_OID)
{
DeleteAuditApplySqlComand.Parameters[0].Value = YG_OID;
return(AdapterHelper.ExecuteCommand(DeleteAuditApplySqlComand));
}
/// <summary>
/// 备份团员数据
/// </summary>
/// <returns></returns>
public int BackupMemberData(string MY_ADMIN)
{
YearBackupSqlComand.Parameters[0].Value = MY_ADMIN;
return(AdapterHelper.ExecuteCommand(YearBackupSqlComand));
}
public int MyUpdate(
string EmpName,
string HrCode,
string Sex,
string Dept,
string WorkGroup,
string Post,
string ParttimeName,
string Politics,
System.DateTime PartyDate,
string Wedding,
string Nation,
string NativePlace,
string Mobile,
string EmpID,
string House,
System.DateTime Birthday,
System.DateTime JobDateTime,
System.DateTime ComDateTime,
string FstSchoolExp,
string FstDegree,
string LstSchoolExp,
string LstDegree,
string SkillLevel,
string VolunteerInfo,
string SpecialSkill,
string ApplyParty,
System.DateTime ApplyPartyDate,
string FstSchool,
string FstProfession,
System.DateTime FstGraduateDate,
string LstSchool,
string LstProfession,
System.DateTime LstGraduateDate,
string HrType,
string HrStatus,
int YouthChargeStd,
string Email,
string FK_YouthGroup,
string FK_YouthGroup_FZ,
string OID
)
{
if ((OID == null))
{
throw new global::System.ArgumentNullException("OID");
}
else
{
MyUpdateSqlComand.Parameters[0].Value = ((string)(OID));
}
if ((FK_YouthGroup_FZ == null))
{
MyUpdateSqlComand.Parameters[1].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[1].Value = ((string)(FK_YouthGroup_FZ));
}
if ((Dept == null))
{
throw new global::System.ArgumentNullException("Dept");
}
else
{
MyUpdateSqlComand.Parameters[2].Value = ((string)(Dept));
}
if ((WorkGroup == null))
{
MyUpdateSqlComand.Parameters[3].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[3].Value = ((string)(WorkGroup));
}
if ((Post == null))
{
MyUpdateSqlComand.Parameters[4].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[4].Value = ((string)(Post));
}
if ((HrCode == null))
{
MyUpdateSqlComand.Parameters[5].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[5].Value = ((string)(HrCode));
}
if ((HrType == null))
{
throw new global::System.ArgumentNullException("HrType");
}
else
{
MyUpdateSqlComand.Parameters[6].Value = ((string)(HrType));
}
if ((HrStatus == null))
{
throw new global::System.ArgumentNullException("HrStatus");
}
else
{
MyUpdateSqlComand.Parameters[7].Value = ((string)(HrStatus));
}
if ((EmpName == null))
{
throw new global::System.ArgumentNullException("EmpName");
}
else
{
MyUpdateSqlComand.Parameters[8].Value = ((string)(EmpName));
}
if ((Sex == null))
{
throw new global::System.ArgumentNullException("Sex");
}
else
{
MyUpdateSqlComand.Parameters[9].Value = ((string)(Sex));
}
if ((EmpID == null))
{
throw new global::System.ArgumentNullException("EmpID");
}
else
{
MyUpdateSqlComand.Parameters[10].Value = ((string)(EmpID));
}
MyUpdateSqlComand.Parameters[11].Value = 0;
MyUpdateSqlComand.Parameters[12].Value = ((System.DateTime)(Birthday));
if ((ParttimeName == null))
{
MyUpdateSqlComand.Parameters[13].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[13].Value = ((string)(ParttimeName));
}
MyUpdateSqlComand.Parameters[14].Value = ((System.DateTime)(JobDateTime));
MyUpdateSqlComand.Parameters[15].Value = ((System.DateTime)(ComDateTime));
if ((Wedding == null))
{
throw new global::System.ArgumentNullException("Wedding");
}
else
{
MyUpdateSqlComand.Parameters[16].Value = ((string)(Wedding));
}
if ((NativePlace == null))
{
MyUpdateSqlComand.Parameters[17].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[17].Value = ((string)(NativePlace));
}
if ((Politics == null))
{
throw new global::System.ArgumentNullException("Politics");
}
else
{
MyUpdateSqlComand.Parameters[18].Value = ((string)(Politics));
}
MyUpdateSqlComand.Parameters[19].Value = ((System.DateTime)(PartyDate));
if ((Nation == null))
{
throw new global::System.ArgumentNullException("Nation");
}
else
{
MyUpdateSqlComand.Parameters[20].Value = ((string)(Nation));
}
if ((House == null))
{
throw new global::System.ArgumentNullException("House");
}
else
{
MyUpdateSqlComand.Parameters[21].Value = ((string)(House));
}
if ((SkillLevel == null))
{
MyUpdateSqlComand.Parameters[22].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[22].Value = ((string)(SkillLevel));
}
if ((FstSchoolExp == null))
{
MyUpdateSqlComand.Parameters[23].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[23].Value = ((string)(FstSchoolExp));
}
if ((FstDegree == null))
{
MyUpdateSqlComand.Parameters[24].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[24].Value = ((string)(FstDegree));
}
if ((LstSchoolExp == null))
{
MyUpdateSqlComand.Parameters[25].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[25].Value = ((string)(LstSchoolExp));
}
if ((LstDegree == null))
{
MyUpdateSqlComand.Parameters[26].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[26].Value = ((string)(LstDegree));
}
if ((FstSchool == null))
{
MyUpdateSqlComand.Parameters[27].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[27].Value = ((string)(FstSchool));
}
if ((FstProfession == null))
{
MyUpdateSqlComand.Parameters[28].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[28].Value = ((string)(FstProfession));
}
MyUpdateSqlComand.Parameters[29].Value = ((System.DateTime)(FstGraduateDate));
if ((LstSchool == null))
{
MyUpdateSqlComand.Parameters[30].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[30].Value = ((string)(LstSchool));
}
if ((LstProfession == null))
{
MyUpdateSqlComand.Parameters[31].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[31].Value = ((string)(LstProfession));
}
MyUpdateSqlComand.Parameters[32].Value = ((System.DateTime)(LstGraduateDate));
if ((ApplyParty == null))
{
MyUpdateSqlComand.Parameters[33].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[33].Value = ((string)(ApplyParty));
}
MyUpdateSqlComand.Parameters[34].Value = ((System.DateTime)(ApplyPartyDate));
if ((VolunteerInfo == null))
{
MyUpdateSqlComand.Parameters[35].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[35].Value = ((string)(VolunteerInfo));
}
if ((Mobile == null))
{
MyUpdateSqlComand.Parameters[36].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[36].Value = ((string)(Mobile));
}
if ((Email == null))
{
MyUpdateSqlComand.Parameters[37].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[37].Value = ((string)(Email));
}
if ((SpecialSkill == null))
{
MyUpdateSqlComand.Parameters[38].Value = String.Empty;
}
else
{
MyUpdateSqlComand.Parameters[38].Value = ((string)(SpecialSkill));
}
MyUpdateSqlComand.Parameters[39].Value = ((int)(YouthChargeStd));
return(AdapterHelper.ExecuteCommand(MyUpdateSqlComand));
}
/// <summary>
/// 清空导入数据
/// </summary>
/// <returns></returns>
public int TruncateTable()
{
return(AdapterHelper.ExecuteCommand(TruncateTableComand));
}
/// <summary>
/// 发放单个支部的经费
/// </summary>
/// <param name="OID"></param>
/// <param name="OP_ADMIN"></param>
/// <param name="OL_NUM"></param>
/// <returns></returns>
public int PublishAll()
{
PublishAllCommand.Parameters[0].Value = AuthenUser.GetCurrentUser().UserID;
return(AdapterHelper.ExecuteCommand(PublishAllCommand));
}