public static ModulePermission ModulePermission_SelectByp_gid(string p_gid)
{
using (SystemDAL access = new SystemDAL())
{
return(access.ModulePermission_SelectByp_gid(p_gid));
}
}
public bool addNewEquipments()
{
string quary = "exec AddEquipment '" + this._equipID + "','" + this._equipName + "'," + this._price;
bool result = new SystemDAL().executeNonQueryS(quary);
return(result);
}
public bool deleteAttendance()
{
string quary = "exec DeleteAattendance '" + this.attendanceID + "'";
bool result = new SystemDAL().executeNonQueryS(quary);
return(result);
}
public bool updatePayment()
{
string quary = "exec updatepayments '" + this.paymentID + "','" + this.dueDate + "','" + this.paidDate + "','" + this.paymentStatus + "'," + this.total + ",'" + this.cid + "','" + this.fn + "'";
bool result = new SystemDAL().executeNonQueryS(quary);
return(result);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
int docID = Convert.ToInt32(txtID.Text);
// BIZ.Doctor doctor = db.Doctor.Where(d => d.ID == docID).FirstOrDefault();
// doctor.ID = docID;
// doctor.Name = txtName.Text;
//// doctor.Specialization = txtSpecilization.Text;
// doctor.Qualification = txtQulalification.Text;
// doctor.Fee = Convert.ToDecimal(txtFee.Text);
// doctor.Contact = Convert.ToInt32(txtContact.Text);
// db.Doctor.Attach(doctor);
// var entry = db.Entry(doctor);
// entry.State = System.Data.Entity.EntityState.Modified;
// var res = db.SaveChanges();
string query = "updateDoc '" + docID + "', '" + txtName.Text + "','" + txtQulalification.Text + "','" + txtContact.Text + "','" + txtFee.Text + "','" + cmbSpecilization.SelectedValue + "'";
bool res = new SystemDAL().executeNonQuerys(query);
if (res == true)
{
MessageBox.Show("Success");
}
else
{
MessageBox.Show("Failed");
}
}
/// <summary>
/// 查询单个用户
/// </summary>
/// <param name="u_gid"></param>
/// <returns></returns>
public static User User_SelectByu_gid(string u_gid)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_SelectByu_gid(u_gid));
}
}
public static int User_DeleteByu_gid(string u_gid)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_DeleteByu_gid(u_gid));
}
}
/// <summary>
/// 分页查询角色权限 所有的
/// </summary>
/// <param name="cloumns"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="orderBy"></param>
/// <param name="where"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public static List <Role_ModualPermission_Mapping> Role_ModualPermission_Mapping_SelectPage(string cloumns, int pageIndex, int pageSize, string orderBy, string where, out int rowCount)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_ModualPermission_Mapping_SelectPage(cloumns, pageIndex, pageSize, orderBy, where, out rowCount));
}
}
/// <summary>
/// 更新角色权限
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static int Role_ModualPermission_Mapping_UpdateByr_p_id(Role_ModualPermission_Mapping obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_ModualPermission_Mapping_UpdateByr_p_id(obj));
}
}
/// <summary>
/// 插入角色权限
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static int Role_ModualPermission_Mapping_Insert(Role_ModualPermission_Mapping obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_ModualPermission_Mapping_Insert(obj));
}
}
/// <summary>
/// 查询单条角色权限
/// </summary>
/// <param name="r_p_id">id主键</param>
/// <returns></returns>
public static Role_ModualPermission_Mapping Role_ModualPermission_Mapping_SelectByr_p_id(int r_p_id)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_ModualPermission_Mapping_SelectByr_p_id(r_p_id));
}
}
/// <summary>
/// 删除角色权限
/// </summary>
/// <param name="r_gid">角色gid</param>
/// <param name="p_gid">权限gid</param>
/// <returns></returns>
public static int Role_ModualPermission_Mapping_DeleteByr_gidAndp_gid(string r_gid, string p_gid)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_ModualPermission_Mapping_DeleteByr_gidAndp_gid(r_gid, p_gid));
}
}
/// <summary>
/// 查询角色对应的 某个模块下拥有的权限
/// </summary>
/// <param name="rgid">角色gid</param>
/// <param name="mgid">模块gid</param>
/// <returns></returns>
public static List <ModulePermission> ModulePermission_SelectModulePerByRoleGid(string rgid, string mgid)
{
using (SystemDAL access = new SystemDAL())
{
return(access.ModulePermission_SelectModulePerByRoleGid(rgid, mgid));
}
}
public static List <ModulePermission> ModulePermission_SelectPage(SystemPermissionSearchInfo search, int pageIndex, int pageSize, out int rowCount)
{
using (SystemDAL access = new SystemDAL())
{
return(access.ModulePermission_SelectPage("*", pageIndex, pageSize, search.DefaultOrder, search.ToWhereString(), out rowCount));
}
}
public static List <User_Role_Mapping> User_Role_Mapping_SelectByu_gid(string u_gid)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_Role_Mapping_SelectByu_gid(u_gid));
}
}
public static int Role_Insert(Role obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_Insert(obj));
}
}
public static int User_Role_Mapping_DeleteByr_gidAndu_gid(string r_gid, string u_gid)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_Role_Mapping_DeleteByr_gidAndu_gid(r_gid, u_gid));
}
}
public static int Role_DeleteByr_gid(string obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_DeleteByr_gid(obj));
}
}
public static int User_UpdateByu_gid(User obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_UpdateByu_gid(obj));
}
}
public static int Role_UpdateByr_gid(Role obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_UpdateByr_gid(obj));
}
}
public static List <User> User_SelectPage(SystemUserSearchInfo search, int pageIndex, int pageSize, out int rowCount)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_SelectPage("*", pageIndex, pageSize, search.DefaultOrder, search.ToWhereString(), out rowCount));
}
}
public static Role Role_SelectByr_gid(string r_gid)
{
using (SystemDAL access = new SystemDAL())
{
return(access.Role_SelectByr_gid(r_gid));
}
}
public bool createPaymentbalance()
{
string quary = "exec Addoutstandingbalance '" + this._BalcID + "','" + this._PaymentID + "','" + this._Fn + "','" + this._Feesmode + "','" + this._PaidDate + "','" + this._Total + "','" + this._Paid + "'," + this._Balance;
bool result = new SystemDAL().executeNonQueryS(quary);
return(result);
}
public static int User_Role_Mapping_Insert(User_Role_Mapping obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_Role_Mapping_Insert(obj));
}
}
public Drug_Edit(int id)
{
InitializeComponent();
DID = id;
cmbCategory.ItemsSource = db.Drug_Category.ToList();
var row = db.Drug_Inventory.Find(id);
txtName.Text = row.Name;
txtDiscription.Text = row.Description;
cmbCategory.SelectedValue = row.Drug_Category;
txtSellingPrice.Text = row.Unit_Selling_Price.ToString();
txtReorder.Text = row.Reorder_Level.ToString();
txtbuyingPrice.Text = row.Unit_Buying_Price.ToString();
txtType.Text = row.Drug_Type;
txtShelf.Text = row.Shelf;
string query = "select[Drug_Category_ID] from [dbo].[Drug_Inventory] where [ID]='" + id + "'";
SqlDataReader reader = new SystemDAL().executeQuerys(query);
if (reader.Read())
{
cmbCategory.SelectedValue = Convert.ToInt32(reader[0]);
}
}
public static int User_Role_Mapping_UpdateByu_r_id(User_Role_Mapping obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_Role_Mapping_UpdateByu_r_id(obj));
}
}
public bool addUsers()
{
string quary = "exec Addusers'" + this._userID + "','" + this._UserName + "','" + this._Password + "','" + this._email + "','" + this._Type + "'";
bool result = new SystemDAL().executeNonQueryS(quary);
return(result);
}
public static User_Role_Mapping User_Role_Mapping_SelectByu_r_id(int u_r_id)
{
using (SystemDAL access = new SystemDAL())
{
return(access.User_Role_Mapping_SelectByu_r_id(u_r_id));
}
}
public bool addAttendance()
{
string quary = "exec AddAattendance '" + this.attendanceID + "','" + this.scheduleID + "','" + this.memberName + "','" + this.trainer + "','" + this.date + "','" + this.time + "','" + this.present + "'";
bool result = new SystemDAL().executeNonQueryS(quary);
return(result);
}
public static int ModulePermission_UpdateByp_gid(ModulePermission obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.ModulePermission_UpdateByp_gid(obj));
}
}
