public bool UpdateStuffFinanceInfor(int StuffUserId, string StuffSAPNo, bool IsApprover, decimal?ApproveAmount)
{
int rowsAffected = 0;
// 根据 StuffUserId 查找要修改的数据
AuthorizationDS.StuffUserDataTable tab = this.StuffUserAdapter.GetDataById(StuffUserId);
if (tab.Count == 0)
{
return(false);
}
try {
// 进行传值
AuthorizationDS.StuffUserRow row = tab[0];
row.IsApprover = IsApprover;
if (ApproveAmount != null)
{
row.ApproveAmount = ApproveAmount.GetValueOrDefault();
}
else
{
row.ApproveAmount = 0;
}
// 更新数据
rowsAffected = this.StuffUserAdapter.Update(row);
} catch (Exception e) {
// put errors
throw e;
}
return(rowsAffected == 1);
}
public bool UpdateStuffUser(int StuffUserId, string StuffName, string StuffId, string UserName, string UserPassword, bool IsActive, string Telephone, string EMail, string EnglishName, DateTime AttendDate, decimal?TrafficFeeLimit, decimal?TelephoneFeeLimit, string BankCard)
{
int rowsAffected = 0;
// 对唯一性进行检查
int iCount = (int)this.StuffUserAdapter.QueryForUpdDistinct(StuffUserId, UserName);
if (iCount > 0)
{
throw new ApplicationException("登陆帐号重复，请变更！");
}
iCount = (int)this.StuffUserAdapter.QueryForUpdDistinctStuffID(StuffId, StuffUserId);
if (iCount > 0)
{
throw new ApplicationException("员工工号重复，请修改！");
}
// 根据 StuffUserId 查找要修改的数据
AuthorizationDS.StuffUserDataTable tab = this.StuffUserAdapter.GetDataById(StuffUserId);
if (tab.Count == 0)
{
return(false);
}
try {
// 进行传值
AuthorizationDS.StuffUserRow row = tab[0];
row.StuffName = StuffName;
row.StuffId = StuffId;
row.UserName = UserName;
if ((UserPassword != null) && (UserPassword != ""))
{
row.UserPassword = UserPassword;
row.LastSetPasswordTime = DateTime.Now;
}
row.IsActive = IsActive;
row.Telephone = Telephone;
row.EMail = EMail;
row.EnglishName = EnglishName;
row.AttendDate = AttendDate;
row.TrafficFeeLimit = TrafficFeeLimit.GetValueOrDefault();
row.TelephoneFeeLimit = TelephoneFeeLimit.GetValueOrDefault();
row.BankCard = BankCard;
// 更新数据
rowsAffected = this.StuffUserAdapter.Update(row);
} catch (Exception e) {
// put errors
throw e;
}
return(rowsAffected == 1);
}
public bool InsertStuffUser(string StuffName, string StuffId, string UserName, string UserPassword, string Telephone, string EMail, string EnglishName, DateTime AttendDate, decimal?TrafficFeeLimit, decimal?TelephoneFeeLimit, string BankCard)
{
int rowsAffected = 0;
// 对唯一性进行检查
int iCount = (int)this.StuffUserAdapter.QueryForInsDistinct(UserName);
if (iCount > 0)
{
throw new ApplicationException("登陆帐号重复，请修改！");
}
iCount = (int)this.StuffUserAdapter.QueryForInsDistinctStuffID(StuffId);
if (iCount > 0)
{
throw new ApplicationException("员工工号重复，请修改！");
}
// 进行数据新增处理
AuthorizationDS.StuffUserDataTable tab = new AuthorizationDS.StuffUserDataTable();
AuthorizationDS.StuffUserRow row = tab.NewStuffUserRow();
try {
// 进行传值
row.StuffName = StuffName;
row.StuffId = StuffId;
row.UserName = UserName;
row.UserPassword = UserPassword;
row.LastSetPasswordTime = DateTime.Now;
row.IsActive = true;
row.Telephone = Telephone;
row.EMail = EMail;
row.EnglishName = EnglishName;
row.AttendDate = AttendDate;
row.TrafficFeeLimit = TrafficFeeLimit.GetValueOrDefault();
row.TelephoneFeeLimit = TelephoneFeeLimit.GetValueOrDefault();
row.BankCard = BankCard;
// 填加行并进行更新处理
tab.AddStuffUserRow(row);
rowsAffected = this.StuffUserAdapter.Update(tab);
} catch (Exception e) {
// put errors
throw e;
}
return(rowsAffected == 1);
}
protected void LogInValidator_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = this.BLL.LogInUser(Request.UserHostAddress, this.UserIdCtl.Text.Trim(), FormsAuthentication.HashPasswordForStoringInConfigFile(this.PasswordCtl.Text, "MD5"));
//args.IsValid = this.BLL.LogInUser(Request.UserHostAddress, this.UserIdCtl.Text.Trim(), this.PasswordCtl.Text);
if (!args.IsValid)
{
AuthorizationDS.StuffUserDataTable stuffUserDT = this.BLL.GetStuffUserByUserId(this.UserIdCtl.Text.Trim());
if (stuffUserDT != null && stuffUserDT.Rows.Count > 0)
{
if (!stuffUserDT[0].IsActive)
{
this.MessageCtl.Text = "该帐户已被停用！";
}
}
else
{
this.MessageCtl.Text = "系统不存在登陆帐号" + this.UserIdCtl.Text.Trim() + "!";
}
}
}
public bool LogInUser(string clientIP, string userName, string password)
{
bool result = false;
LogInAction action = new LogInAction();
action.UserName = userName;
action.ClientIP = clientIP;
action.LogInTime = DateTime.Now;
AuthorizationDS.StuffUserDataTable table = this.StuffUserAdapter.GetDataByUserName(userName);
if (table.Count > 0)
{
action.StuffName = table[0].StuffName;
action.StuffId = table[0].StuffId;
if (table[0].UserPassword.Equals(password))
{
if (table[0].IsLatestLogInTimeNull())
{
table[0].SetLaterLogInTimeNull();
}
else
{
table[0].LaterLogInTime = table[0].LatestLogInTime;
}
table[0].LatestLogInTime = DateTime.Now;
this.StuffUserAdapter.Update(table);
action.Success = true;
result = true;
}
}
if (result == false)
{
action.Success = false;
}
SysLog.LogLogInAction(action);
return(result);
}
public bool InsertStuffUser(string StuffName, string StuffId, string UserName, string UserPassword, string Telephone, string EMail, string EnglishName, DateTime AttendDate, int StaffLevelID,string VendorCode)
{
int rowsAffected = 0;
// ��Ψһ�Խ��м��
int iCount = (int)this.StuffUserAdapter.QueryForInsDistinct(UserName);
if (iCount > 0) {
throw new ApplicationException("��½�ʺ��ظ������ģ�");
}
iCount = (int)this.StuffUserAdapter.QueryForInsDistinctStuffID(StuffId);
if (iCount > 0) {
throw new ApplicationException("Ա�������ظ������ģ�");
}
// ����������������
AuthorizationDS.StuffUserDataTable tab = new AuthorizationDS.StuffUserDataTable();
AuthorizationDS.StuffUserRow row = tab.NewStuffUserRow();
try {
// ���д�ֵ
row.StuffName = StuffName;
row.StuffId = StuffId;
row.UserName = UserName;
row.UserPassword = UserPassword;
row.LastSetPasswordTime = DateTime.Now;
row.IsActive = true;
row.Telephone = Telephone;
row.EMail = EMail;
row.EnglishName = EnglishName;
row.AttendDate = AttendDate;
row.StaffLevelID = StaffLevelID;
row.StuffNo = StuffId;
row.VendorCode = VendorCode;
// ����в����и��´���
tab.AddStuffUserRow(row);
rowsAffected = this.StuffUserAdapter.Update(tab);
} catch (Exception e) {
// put errors
throw e;
}
return rowsAffected == 1;
}
