/// <summary> /// 如果用户是已绑定的角色,则选中 /// </summary> private void SelectingRole(Owen.Model.Model_UserInfo model) { //超级管理员角色不受限制 if (model.UserType == 1) { //选择 foreach (ListItem li in this.cblRoles.Items) { li.Selected = true; } return; } IList<Owen.Model.Model_UserGroupRole> userGroupRoleLists = new Owen.BLL.BLL_UserGroupRole(). GetEntities(string.Format(" UserID = {0}", userId)); foreach (var ur in userGroupRoleLists) { //选择 foreach (ListItem li in this.cblRoles.Items) { if (ur.RolesID.ToString().Equals(li.Value)) { li.Selected = true; } } } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Distributor entity, CheckBoxList cbl) { bool b = false; using (TransactionScope tranScope = new TransactionScope()) { if (entity == null || entity.DistributorID == 0) tranScope.Dispose(); new BLL_DistributorRelation().DeleteEntity(string.Format(" DistributorID = {0} ", entity.DistributorID)); foreach (ListItem li in cbl.Items) { int hosId = Convert.ToInt32(li.Value); if (li.Selected == true) { Owen.Model.Model_DistributorRelation mDistributorRelation = new Owen.Model.Model_DistributorRelation(); mDistributorRelation.DistributorID = entity.DistributorID; mDistributorRelation.HospitalID = hosId; new BLL_DistributorRelation().AddEntity(mDistributorRelation); } } dataFactory.DistributorDal.UpdateEntity(entity); tranScope.Complete(); b = true; } return b; }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_SysLog AddEntity(Owen.Model.Model_SysLog entity) { int excuteResult = 0; StringBuilder sql = new StringBuilder(50); sql.Append(" INSERT INTO [SysLog](LogClass,LogNote,LogIP,LogDt) "); sql.Append(" VALUES(@LogClass,@LogNote,@LogIP,getDate()); "); sql.Append(" SELECT @ReturnValue=@@IDENTITY; "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@LogClass", SqlDbType = SqlDbType.Int, Value = entity.LogClass }, new SqlParameter(){ParameterName = "@LogNote", SqlDbType = SqlDbType.NVarChar, Size = 1000, Value = (entity.LogNote != null ? entity.LogNote : string.Empty) }, new SqlParameter(){ParameterName = "@LogIP", SqlDbType = SqlDbType.VarChar, Size = 50, Value = (entity.LogIP != null ?entity.LogIP : string.Empty) }, new SqlParameter(){ParameterName = "@ReturnValue", SqlDbType=SqlDbType.Int, Direction=ParameterDirection.Output} }; try { SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters); excuteResult = int.Parse(parameters[3].Value.ToString()); entity.Id = excuteResult; return entity; } catch (Exception ex) { return null; } }
private static void tfn_test() //****************************************************************************80 // // Purpose: // // TFN_TEST tests TFN. // // Licensing: // // This code is distributed under the GNU LGPL license. // // Modified: // // 12 April 2016 // // Author: // // John Burkardt // { double a = 0; double h = 0; double t = 0; Console.WriteLine(""); Console.WriteLine("TFN_TEST"); Console.WriteLine(" TFN evaluates Owen's T function;"); Console.WriteLine(""); Console.WriteLine(" H A T(H,A) Exact"); Console.WriteLine(""); int n_data = 0; for (;;) { Owen.owen_values(ref n_data, ref h, ref a, ref t); if (n_data <= 0) { break; } double t2 = Owen.tfn(h, a); Console.WriteLine(" " + h.ToString(CultureInfo.InvariantCulture).PadLeft(14) + " " + a.ToString(CultureInfo.InvariantCulture).PadLeft(14) + " " + t2.ToString(CultureInfo.InvariantCulture).PadLeft(14) + " " + t.ToString(CultureInfo.InvariantCulture).PadLeft(14) + ""); } }
/// <summary> /// 添加 /// </summary> public bool Insert(Owen.Model.Model_UserInfo entity, CheckBoxList cbl) { bool b = false; using (TransactionScope tranScope = new TransactionScope()) { int id = dataFactory.UserInfoDal.AddEntity(entity).UserID; UpdateUserGroupRole(id, cbl); tranScope.Complete(); b = true; } return b; }
public static void owen_values_test() //****************************************************************************80 // // Purpose: // // OWEN_VALUES_TEST tests OWEN_VALUES. // // Licensing: // // This code is distributed under the GNU LGPL license. // // Modified: // // 09 February 2007 // // Author: // // John Burkardt // { double a = 0; double h = 0; double t = 0; Console.WriteLine(""); Console.WriteLine("OWEN_VALUES_TEST"); Console.WriteLine(" OWEN_VALUES stores values of"); Console.WriteLine(" Owen's T function."); Console.WriteLine(""); Console.WriteLine(" H A T"); Console.WriteLine(""); int n_data = 0; for (;;) { Owen.owen_values(ref n_data, ref h, ref a, ref t); if (n_data == 0) { break; } Console.WriteLine(" " + h.ToString(CultureInfo.InvariantCulture).PadLeft(12) + " " + a.ToString(CultureInfo.InvariantCulture).PadLeft(12) + " " + t.ToString("0.################").PadLeft(24) + ""); } }
/// <summary> /// 根据条件,返回IList /// </summary> /// <param name="sqlWhere">sql条件</param> /// <returns></returns> public IList<Owen.Model.Model_Attentive> GetEntities(Owen.Common.QueryParam queryParam, out int count) { IList<Model.Model_Attentive> list = new List<Owen.Model.Model_Attentive>(); queryParam.TableName = "Attentive"; queryParam.ReturnFields = "*"; if (queryParam.Orderfld == null) { queryParam.Orderfld = "AttentiveID"; } else if (queryParam.Orderfld != "AttentiveID") { queryParam.Orderfld += ",AttentiveID"; } SqlServerHelper.PopulateDelegate<Owen.Model.Model_Attentive> mypd = new SqlServerHelper.PopulateDelegate<Owen.Model.Model_Attentive>(this.Populate_Attentive); return SqlServerHelper.GetEntities(mypd, queryParam, out count); }
/// <summary> /// 根据条件,返回IList /// </summary> /// <param name="sqlWhere">sql条件</param> /// <returns></returns> public IList<Owen.Model.Model_MedicalRelation> GetEntities(Owen.Common.QueryParam queryParam, out int count) { IList<Model.Model_MedicalRelation> list = new List<Owen.Model.Model_MedicalRelation>(); queryParam.TableName = "MedicalRelation"; queryParam.ReturnFields = "*"; if (queryParam.Orderfld == null) { queryParam.Orderfld = "Id"; } else if (queryParam.Orderfld != "Id") { queryParam.Orderfld += ",Id"; } SqlServerHelper.PopulateDelegate<Owen.Model.Model_MedicalRelation> mypd = new SqlServerHelper.PopulateDelegate<Owen.Model.Model_MedicalRelation>(this.Populate_MedicalRelation); return SqlServerHelper.GetEntities(mypd, queryParam, out count); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_UserGroupRole AddEntity(Owen.Model.Model_UserGroupRole entity) { StringBuilder sql = new StringBuilder(30); sql.Append(" IF NOT Exists (SELECT * FROM [UserGroupRole] WHERE UserID=@UserID AND RolesID=@RolesID ) "); sql.Append(" BEGIN INSERT INTO [UserGroupRole](UserID,RolesID,Remark,State) "); sql.Append(" VALUES(@UserID,@RolesID,@Remark,@State) END "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@UserID", SqlDbType = SqlDbType.Int, Value = entity.UserID}, new SqlParameter(){ParameterName = "@RolesID", SqlDbType = SqlDbType.Int, Value = entity.RolesID}, new SqlParameter(){ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.Remark != null ? entity.Remark : string.Empty) }, new SqlParameter(){ParameterName = "@State", SqlDbType = SqlDbType.Int, Value = entity.State} }; try { SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters); return entity; } catch (Exception ex) { return null; } }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_Privilege AddEntity(Owen.Model.Model_Privilege entity) { StringBuilder sql = new StringBuilder(30); sql.Append(" IF NOT Exists (SELECT * FROM [Privilege] WHERE ResourceID=@ResourceID AND OperateID=@OperateID ) "); sql.Append(" BEGIN INSERT INTO [Privilege] (ResourceID,OperateID,Remark) "); sql.Append(" VALUES(@ResourceID,@OperateID,@Remark) END "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@ResourceID", SqlDbType = SqlDbType.Int, Value = entity.ResourceID}, new SqlParameter(){ParameterName = "@OperateID", SqlDbType = SqlDbType.Int, Value = entity.OperateID}, new SqlParameter(){ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.Remark != null ? entity.Remark : string.Empty) } }; try { if (SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters) > 0) return entity; else return null; } catch (Exception ex) { return null; } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Dictionary entity) { return dataFactory.DictionaryDal.UpdateEntity(entity); }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_UserInfo entity) { StringBuilder sql = new StringBuilder(); sql.Append(" UPDATE [UserInfo] SET UserName = @UserName, Password = @Password, "); sql.Append(" Phone = @Phone, Gender = @Gender, Birth = @Birth, Age = @Age, "); sql.Append(" Email = @Email, Address = @Address, ZipCode = @ZipCode, "); sql.Append(" UserType = @UserType, Status = @Status "); sql.Append(" WHERE UserID = @UserID "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@UserName", SqlDbType = SqlDbType.NVarChar, Size = 24, Value = (entity.UserName != null ? entity.UserName : string.Empty)}, new SqlParameter(){ParameterName = "@Password", SqlDbType = SqlDbType.VarChar, Size = 250, Value = (entity.Password != null ?entity.Password : string.Empty)}, new SqlParameter(){ParameterName = "@Phone", SqlDbType = SqlDbType.VarChar, Size = 24, Value = (entity.Phone != null ?entity.Phone : string.Empty)}, new SqlParameter(){ParameterName = "@Gender", SqlDbType = SqlDbType.Int, Value = entity.Gender }, new SqlParameter(){ParameterName = "@Birth", SqlDbType = SqlDbType.VarChar, Size = 24, Value = (entity.Birth != null ?entity.Birth : string.Empty)}, new SqlParameter(){ParameterName = "@Age", SqlDbType = SqlDbType.Int, Value = entity.Age }, new SqlParameter(){ParameterName = "@Email", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = (entity.Email != null ?entity.Email : string.Empty)}, new SqlParameter(){ParameterName = "@Address", SqlDbType = SqlDbType.NVarChar, Size = 250, Value = (entity.Address != null ?entity.Address : string.Empty)}, new SqlParameter(){ParameterName = "@ZipCode", SqlDbType = SqlDbType.Char, Size = 6, Value = (entity.ZipCode != null ?entity.ZipCode : string.Empty)}, new SqlParameter(){ParameterName = "@UserType", SqlDbType = SqlDbType.Int, Value = entity.UserType }, new SqlParameter(){ParameterName = "@Status", SqlDbType = SqlDbType.Int, Value = entity.Status }, new SqlParameter(){ParameterName = "@UserID", SqlDbType = SqlDbType.Int, Value = entity.UserID } }; return SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters) > 0; }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_Dictionary AddEntity(Owen.Model.Model_Dictionary entity) { return dataFactory.DictionaryDal.AddEntity(entity); }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_SysLog entity) { return false; }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_Attentive AddEntity(Owen.Model.Model_Attentive entity) { int excuteResult = 0; StringBuilder sql = new StringBuilder(50); sql.Append(" INSERT INTO [Attentive]([Name],[HospitalName],[HeadImg],[Department],[JobTitle],[Goodat],[Worktime],[Address],[Memo]) "); sql.Append(" VALUES (@Name,@HospitalName,@HeadImg,@Department,@JobTitle,@Goodat,@Worktime,@Address,@Memo); "); sql.Append(" SELECT @current=@@IDENTITY; "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@Name", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.Name != null ?entity.Name : string.Empty) }, new SqlParameter(){ParameterName = "@HospitalName", SqlDbType = SqlDbType.NVarChar, Size = 150, Value = (entity.HospitalName != null ?entity.HospitalName : string.Empty) }, new SqlParameter(){ParameterName = "@HeadImg", SqlDbType = SqlDbType.NVarChar, Size = 250, Value = (entity.HeadImg != null ?entity.HeadImg : string.Empty) }, new SqlParameter(){ParameterName = "@Department", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.Department != null ?entity.Department : string.Empty) }, new SqlParameter(){ParameterName = "@JobTitle", SqlDbType = SqlDbType.NVarChar, Size = 500, Value = (entity.JobTitle != null ?entity.JobTitle : string.Empty) }, new SqlParameter(){ParameterName = "@Goodat", SqlDbType = SqlDbType.NVarChar, Size = 500, Value = (entity.Goodat != null ?entity.Goodat : string.Empty) }, new SqlParameter(){ParameterName = "@Worktime", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = (entity.Worktime != null ?entity.Worktime : string.Empty) }, new SqlParameter(){ParameterName = "@Address", SqlDbType = SqlDbType.NVarChar, Size = 250, Value = (entity.Address != null ?entity.Address : string.Empty) }, new SqlParameter(){ParameterName = "@Memo", SqlDbType = SqlDbType.NText, Value = (entity.Memo != null ?entity.Memo : string.Empty) }, new SqlParameter(){ParameterName = "@current", SqlDbType=SqlDbType.Int, Direction=ParameterDirection.Output} }; try { SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters); excuteResult = int.Parse(parameters[9].Value.ToString()); entity.AttentiveID = excuteResult; return entity; } catch (Exception ex) { return null; } }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_Province AddEntity(Owen.Model.Model_Province entity) { return null; }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_Resource AddEntity(Owen.Model.Model_Resource entity) { StringBuilder sql = new StringBuilder(30); sql.Append(" BEGIN INSERT INTO [Resource](ResourceName,ResourceTitles,Links,Remark,Levels,ParentID,Sort,State) "); sql.Append(" VALUES(@ResourceName,@ResourceTitles,@Links,@Remark,@Levels,@ParentID,@Sort,@State); "); sql.Append(" SELECT @current=@@IDENTITY END;"); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@ResourceName", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = entity.ResourceName}, new SqlParameter(){ParameterName = "@ResourceTitles", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.ResourceTitles != null ?entity.ResourceTitles : string.Empty)}, new SqlParameter(){ParameterName = "@Links", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = entity.Links}, new SqlParameter(){ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = entity.Remark}, new SqlParameter(){ParameterName = "@Levels", SqlDbType = SqlDbType.Int, Value = entity.Levels}, new SqlParameter(){ParameterName = "@ParentID", SqlDbType = SqlDbType.Int, Value = entity.ParentID}, new SqlParameter(){ParameterName = "@Sort", SqlDbType = SqlDbType.Int, Value = entity.Sort}, new SqlParameter(){ParameterName = "@State", SqlDbType = SqlDbType.Int, Value = entity.State}, new SqlParameter(){ParameterName = "@current", SqlDbType=SqlDbType.Int, Direction=ParameterDirection.Output} }; try { SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters); int id = int.Parse(parameters[8].Value.ToString()); entity.ResourceID = id; return entity; } catch (Exception ex) { return null; } }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_Operate AddEntity(Owen.Model.Model_Operate entity) { return dataFactory.OperateDal.AddEntity(entity); }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Operate entity) { return dataFactory.OperateDal.UpdateEntity(entity); }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Medical entity) { StringBuilder sql = new StringBuilder(50); sql.Append(" UPDATE [Medical] "); sql.Append(" SET [HospitalID] = @HospitalID,[HospitalNumber] = @HospitalNumber,[PatientName] = @PatientName,[PatientSex] = @PatientSex,[PatientBirth] = @PatientBirth,[PatientMobile] = @PatientMobile,[DoctorID] = @DoctorID,[Surgery] = @Surgery,[ProductId] = @ProductId,[Finish] = @Finish,[DistributorID] = @DistributorID,[EmployeesID]=@EmployeesID,[Price] = @Price,[PatientAge] = @PatientAge "); sql.Append(" WHERE MedicalID=@MedicalID "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@HospitalID", SqlDbType = SqlDbType.Int, Value = entity.HospitalID }, new SqlParameter(){ParameterName = "@HospitalNumber", SqlDbType = SqlDbType.VarChar, Value = (entity.HospitalNumber != null ?entity.HospitalNumber : string.Empty) }, new SqlParameter(){ParameterName = "@PatientMobile", SqlDbType = SqlDbType.VarChar, Value = (entity.PatientMobile != null ?entity.PatientMobile : string.Empty) }, new SqlParameter(){ParameterName = "@PatientName", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.PatientName != null ?entity.PatientName : string.Empty) }, new SqlParameter(){ParameterName = "@PatientSex", SqlDbType = SqlDbType.Int, Value = entity.PatientSex }, new SqlParameter(){ParameterName = "@PatientBirth", SqlDbType = SqlDbType.VarChar, Value = (entity.PatientBirth != null ?entity.PatientBirth : string.Empty) }, new SqlParameter(){ParameterName = "@DoctorID", SqlDbType = SqlDbType.Int, Value = entity.DoctorID }, new SqlParameter(){ParameterName = "@Surgery", SqlDbType = SqlDbType.NVarChar, Value = (entity.Surgery != null ?entity.Surgery : string.Empty) }, new SqlParameter(){ParameterName = "@ProductId", SqlDbType = SqlDbType.Int, Value = entity.ProductId }, new SqlParameter(){ParameterName = "@Finish", SqlDbType = SqlDbType.Decimal, Value = entity.Finish }, new SqlParameter(){ParameterName = "@DistributorID", SqlDbType = SqlDbType.Int, Value = entity.DistributorID }, new SqlParameter(){ParameterName = "@EmployeesID", SqlDbType = SqlDbType.Int, Value = entity.EmployeesID }, new SqlParameter(){ParameterName = "@Price", SqlDbType = SqlDbType.Decimal, Value = entity.Price }, new SqlParameter(){ParameterName = "@PatientAge", SqlDbType = SqlDbType.Int, Value = entity.PatientAge }, new SqlParameter(){ParameterName = "@MedicalID", SqlDbType = SqlDbType.Int, Value = entity.MedicalID } }; try { if (SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters) > 0) return true; else return false; } catch (Exception ex) { return false; } }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_Medical AddEntity(Owen.Model.Model_Medical entity) { int excuteResult = 0; StringBuilder sql = new StringBuilder(50); sql.Append(" BEGIN INSERT INTO [Medical] ([HospitalID],[HospitalNumber],[PatientName],[PatientSex],[PatientBirth], "); sql.Append(" [PatientMobile],[DoctorID],[Surgery],[ProductId],[Finish],[DistributorID],[EmployeesID],[CreateDt],[Price],[PatientAge]) "); sql.Append(" VALUES(@HospitalID,@HospitalNumber,@PatientName,@PatientSex,@PatientBirth,@PatientMobile,"); sql.Append(" @DoctorID,@Surgery,@ProductId,@Finish,@DistributorID,@EmployeesID,@CreateDt,@Price,@PatientAge);"); sql.Append(" SELECT @current=@@IDENTITY END;"); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@HospitalID", SqlDbType = SqlDbType.Int, Value = entity.HospitalID }, new SqlParameter(){ParameterName = "@HospitalNumber", SqlDbType = SqlDbType.VarChar, Value = (entity.HospitalNumber != null ?entity.HospitalNumber : string.Empty) }, new SqlParameter(){ParameterName = "@PatientMobile", SqlDbType = SqlDbType.VarChar, Value = (entity.PatientMobile != null ?entity.PatientMobile : string.Empty) }, new SqlParameter(){ParameterName = "@PatientName", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.PatientName != null ?entity.PatientName : string.Empty) }, new SqlParameter(){ParameterName = "@PatientSex", SqlDbType = SqlDbType.Int, Value = entity.PatientSex }, new SqlParameter(){ParameterName = "@PatientBirth", SqlDbType = SqlDbType.VarChar, Value = (entity.PatientBirth != null ?entity.PatientBirth : string.Empty) }, new SqlParameter(){ParameterName = "@DoctorID", SqlDbType = SqlDbType.Int, Value = entity.DoctorID }, new SqlParameter(){ParameterName = "@Surgery", SqlDbType = SqlDbType.NVarChar, Value = (entity.Surgery != null ?entity.Surgery : string.Empty) }, new SqlParameter(){ParameterName = "@ProductId", SqlDbType = SqlDbType.Int, Value = entity.ProductId }, new SqlParameter(){ParameterName = "@Finish", SqlDbType = SqlDbType.Decimal, Value = entity.Finish }, new SqlParameter(){ParameterName = "@DistributorID", SqlDbType = SqlDbType.Int, Value = entity.DistributorID }, new SqlParameter(){ParameterName = "@EmployeesID", SqlDbType = SqlDbType.Int, Value = entity.EmployeesID }, new SqlParameter(){ParameterName = "@CreateDt", SqlDbType = SqlDbType.DateTime, Value = entity.CreateDt }, new SqlParameter(){ParameterName = "@Price", SqlDbType = SqlDbType.Decimal, Value = entity.Price }, new SqlParameter(){ParameterName = "@PatientAge", SqlDbType = SqlDbType.Int, Value = entity.PatientAge }, new SqlParameter(){ParameterName = "@current", SqlDbType=SqlDbType.Int, Direction=ParameterDirection.Output} }; try { SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters); excuteResult = int.Parse(parameters[15].Value.ToString()); entity.HospitalID = excuteResult; return entity; } catch (Exception ex) { return null; } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Resource entity) { StringBuilder sql = new StringBuilder(); sql.Append(" update [Resource] set ResourceName=@ResourceName, ResourceTitles=@ResourceTitles, Links=@Links, "); sql.Append(" Remark=@Remark, Levels=@Levels, ParentID=@ParentID, Sort=@Sort, State=@State "); sql.Append(" where ResourceID=@ResourceID "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@ResourceName", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = entity.ResourceName}, new SqlParameter(){ParameterName = "@ResourceTitles", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.ResourceTitles != null ?entity.ResourceTitles : string.Empty)}, new SqlParameter(){ParameterName = "@Links", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = entity.Links}, new SqlParameter(){ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = entity.Remark}, new SqlParameter(){ParameterName = "@Levels", SqlDbType = SqlDbType.Int, Value = entity.Levels}, new SqlParameter(){ParameterName = "@ParentID", SqlDbType = SqlDbType.Int, Value = entity.ParentID}, new SqlParameter(){ParameterName = "@Sort", SqlDbType = SqlDbType.Int, Value = entity.Sort}, new SqlParameter(){ParameterName = "@State", SqlDbType = SqlDbType.Int, Value = entity.State}, new SqlParameter(){ParameterName = "@ResourceID", SqlDbType = SqlDbType.Int, Value = entity.ResourceID}, }; return SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters) > 0; }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_UserGroupRole AddEntity(Owen.Model.Model_UserGroupRole entity) { return dataFactory.UserGroupRoleDal.AddEntity(entity); }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Img entity) { return dataFactory.ImgDal.UpdateEntity(entity); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_RolesAuthorize AddEntity(Owen.Model.Model_RolesAuthorize entity) { StringBuilder sql = new StringBuilder(30); sql.Append(" IF NOT Exists (SELECT * FROM [Authorize] WHERE RolesID=@RolesID AND PrivilegeID=@PrivilegeID ) "); sql.Append(" BEGIN INSERT INTO [Authorize](RolesID,PrivilegeID,Remark,State) "); sql.Append(" VALUES(@RolesID,@PrivilegeID,@Remark,@State) END "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@RolesID", SqlDbType = SqlDbType.Int, Value = entity.RolesID}, new SqlParameter(){ParameterName = "@PrivilegeID", SqlDbType = SqlDbType.Int, Value = entity.PrivilegeID}, new SqlParameter(){ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = string.Empty }, new SqlParameter(){ParameterName = "@State", SqlDbType = SqlDbType.Int, Value = 0 } }; try { SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters); return entity; } catch (Exception ex) { return null; } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Attentive entity) { StringBuilder sql = new StringBuilder(50); sql.Append(" UPDATE [Attentive] "); sql.Append(" SET [Name] = @Name,[HospitalName]=@HospitalName,[HeadImg]=@HeadImg,[Department] = @Department,[JobTitle] = @JobTitle,[Goodat] = @Goodat,[Worktime] = @Worktime,[Address] = @Address,[Memo] = @Memo "); sql.Append(" WHERE AttentiveID=@AttentiveID "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@Name", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.Name != null ?entity.Name : string.Empty) }, new SqlParameter(){ParameterName = "@HospitalName", SqlDbType = SqlDbType.NVarChar, Size = 150, Value = (entity.HospitalName != null ?entity.HospitalName : string.Empty) }, new SqlParameter(){ParameterName = "@HeadImg", SqlDbType = SqlDbType.NVarChar, Size = 250, Value = (entity.HeadImg != null ?entity.HeadImg : string.Empty) }, new SqlParameter(){ParameterName = "@Department", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = (entity.Department != null ?entity.Department : string.Empty) }, new SqlParameter(){ParameterName = "@JobTitle", SqlDbType = SqlDbType.NVarChar, Size = 500, Value = (entity.JobTitle != null ?entity.JobTitle : string.Empty) }, new SqlParameter(){ParameterName = "@Goodat", SqlDbType = SqlDbType.NVarChar, Size = 500, Value = (entity.Goodat != null ?entity.Goodat : string.Empty) }, new SqlParameter(){ParameterName = "@Worktime", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = (entity.Worktime != null ?entity.Worktime : string.Empty) }, new SqlParameter(){ParameterName = "@Address", SqlDbType = SqlDbType.NVarChar, Size = 250, Value = (entity.Address != null ?entity.Address : string.Empty) }, new SqlParameter(){ParameterName = "@Memo", SqlDbType = SqlDbType.NText, Value = (entity.Memo != null ?entity.Memo : string.Empty) }, new SqlParameter(){ParameterName = "@AttentiveID", SqlDbType = SqlDbType.Int, Value = entity.AttentiveID } }; try { if (SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters) > 0) return true; else return false; } catch (Exception ex) { return false; } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Province entity) { return false; }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_RolesAuthorize entity) { StringBuilder sql = new StringBuilder(30); sql.Append(" IF Exists (SELECT * FROM [Authorize] WHERE RolesID=@RolesID AND PrivilegeID=@PrivilegeID ) "); sql.Append(" BEGIN DELETE [Authorize] WHERE RolesID=@RolesID AND PrivilegeID=@PrivilegeID END "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@RolesID", SqlDbType = SqlDbType.Int, Value = entity.RolesID}, new SqlParameter(){ParameterName = "@PrivilegeID", SqlDbType = SqlDbType.Int, Value = entity.PrivilegeID}, new SqlParameter(){ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Size = 50, Value = string.Empty }, new SqlParameter(){ParameterName = "@State", SqlDbType = SqlDbType.Int, Value = 0 } }; return SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters) > 0; }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_SysLog AddEntity(Owen.Model.Model_SysLog entity) { return dataFactory.SysLogDal.AddEntity(entity); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_UserInfo AddEntity(Owen.Model.Model_UserInfo entity) { StringBuilder sql = new StringBuilder(100); sql.Append("BEGIN INSERT INTO [UserInfo](UserName,[Password],Phone,Gender,Birth,Age,Email,[Address], "); sql.Append(" ZipCode,UserType,[Status],CreateDt) "); sql.Append(" VALUES(@UserName,@Password,@Phone,@Gender,@Birth,@Age,@Email,@Address, "); sql.Append(" @ZipCode,@UserType,@Status,getDate()); "); sql.Append(" SELECT @current=@@IDENTITY END;"); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@UserName", SqlDbType = SqlDbType.NVarChar, Size = 24, Value = (entity.UserName != null ? entity.UserName : string.Empty)}, new SqlParameter(){ParameterName = "@Password", SqlDbType = SqlDbType.VarChar, Size = 250, Value = (entity.Password != null ?entity.Password : string.Empty)}, new SqlParameter(){ParameterName = "@Phone", SqlDbType = SqlDbType.VarChar, Size = 24, Value = (entity.Phone != null ?entity.Phone : string.Empty)}, new SqlParameter(){ParameterName = "@Gender", SqlDbType = SqlDbType.Int, Value = entity.Gender }, new SqlParameter(){ParameterName = "@Birth", SqlDbType = SqlDbType.VarChar, Size = 24, Value = (entity.Birth != null ?entity.Birth : string.Empty)}, new SqlParameter(){ParameterName = "@Age", SqlDbType = SqlDbType.Int, Value = entity.Age }, new SqlParameter(){ParameterName = "@Email", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = (entity.Email != null ?entity.Email : string.Empty)}, new SqlParameter(){ParameterName = "@Address", SqlDbType = SqlDbType.NVarChar, Size = 250, Value = (entity.Address != null ?entity.Address : string.Empty)}, new SqlParameter(){ParameterName = "@ZipCode", SqlDbType = SqlDbType.Char, Size = 6, Value = (entity.ZipCode != null ?entity.ZipCode : string.Empty)}, new SqlParameter(){ParameterName = "@UserType", SqlDbType = SqlDbType.Int, Value = entity.UserType }, new SqlParameter(){ParameterName = "@Status", SqlDbType = SqlDbType.Int, Value = entity.Status }, new SqlParameter(){ParameterName = "@current", SqlDbType=SqlDbType.Int, Direction = ParameterDirection.Output} }; try { SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters); int id = int.Parse(parameters[11].Value.ToString()); entity.UserID = id; return entity; } catch (Exception ex) { return null; } }
/// <summary> /// 添加 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public Owen.Model.Model_Privilege AddEntity(Owen.Model.Model_Privilege entity) { return dataFactory.PrivilegeDal.AddEntity(entity); }
/// <summary> /// 修改 /// </summary> /// <param name="entity">泛型实体</param> /// <returns></returns> public bool UpdateEntity(Owen.Model.Model_Dictionary entity) { StringBuilder sql = new StringBuilder(100); sql.Append(" update [Dictionary] set DicType=@DicType, DicName=@DicName, Memo=@Memo, DSort=@DSort "); sql.Append(" where DictionaryID = @DictionaryID "); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(){ParameterName = "@DicType", SqlDbType = SqlDbType.Int, Value = entity.DicType }, new SqlParameter(){ParameterName = "@DicName", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = (entity.DicName != null ?entity.DicName : string.Empty) }, new SqlParameter(){ParameterName = "@Memo", SqlDbType = SqlDbType.NVarChar, Size = 100, Value = (entity.Memo != null ? entity.Memo : string.Empty) }, new SqlParameter(){ParameterName = "@DSort", SqlDbType = SqlDbType.Int, Value = entity.DSort }, new SqlParameter(){ParameterName = "@DictionaryID", SqlDbType = SqlDbType.Int, Value = entity.DictionaryID } }; return SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters) > 0; }