/// <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;
}
