public int InsertByOutput(ApplicationsInfo model) { StringBuilder sb = new StringBuilder(300); sb.Append(@"insert into Applications (Id,Coded,Named,LowerName,Remark) values (@Id,@Coded,@Named,@LowerName,@Remark) " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@Coded", SqlDbType.Char, 6), new SqlParameter("@Named", SqlDbType.NVarChar, 50), new SqlParameter("@LowerName", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 256) }; parms[0].Value = model.Id; parms[1].Value = model.Coded; parms[2].Value = model.Named; parms[3].Value = model.LowerName; parms[4].Value = model.Remark; return(SqlHelper.ExecuteNonQuery(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), parms)); }
public IList <ApplicationsInfo> GetList() { StringBuilder sb = new StringBuilder(300); sb.Append(@"select Id,Coded,Named,LowerName,Remark from Applications order by " ); IList <ApplicationsInfo> list = new List <ApplicationsInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { ApplicationsInfo model = new ApplicationsInfo(); model.Id = reader.GetGuid(0); model.Coded = reader.GetString(1); model.Named = reader.GetString(2); model.LowerName = reader.GetString(3); model.Remark = reader.GetString(4); list.Add(model); } } } return(list); }
public IList <ApplicationsInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select Id,Coded,Named,LowerName,Remark from Applications "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.Append("order by "); IList <ApplicationsInfo> list = new List <ApplicationsInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ApplicationsInfo model = new ApplicationsInfo(); model.Id = reader.GetGuid(0); model.Coded = reader.GetString(1); model.Named = reader.GetString(2); model.LowerName = reader.GetString(3); model.Remark = reader.GetString(4); list.Add(model); } } } return(list); }
public ApplicationsInfo GetModel(Guid id) { ApplicationsInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 Id,Coded,Named,LowerName,Remark from Applications where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier) }; parms[0].Value = id; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new ApplicationsInfo(); model.Id = reader.GetGuid(0); model.Coded = reader.GetString(1); model.Named = reader.GetString(2); model.LowerName = reader.GetString(3); model.Remark = reader.GetString(4); } } } return(model); }
public IList <ApplicationsInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from Applications "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <ApplicationsInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by ) as RowNumber, Id,Coded,Named,LowerName,Remark from Applications " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <ApplicationsInfo> list = new List <ApplicationsInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { ApplicationsInfo model = new ApplicationsInfo(); model.Id = reader.GetGuid(1); model.Coded = reader.GetString(2); model.Named = reader.GetString(3); model.LowerName = reader.GetString(4); model.Remark = reader.GetString(5); list.Add(model); } } } return(list); }
public override void Initialize(string name, NameValueCollection config) { if (config == null) { throw new ArgumentNullException("config"); } if (String.IsNullOrEmpty(name)) { name = "SqlRoleProvider"; } if (string.IsNullOrEmpty(config["description"])) { config.Remove("description"); config.Add("description", SM.GetString(SM.RoleSqlProvider_description)); } base.Initialize(name, config); _AppName = config["applicationName"]; if (string.IsNullOrEmpty(_AppName)) { _AppName = SC.GetDefaultAppName(); } if (_AppName.Length > 256) { throw new ProviderException(SM.GetString(SM.Provider_application_name_too_long)); } config.Remove("connectionStringName"); config.Remove("applicationName"); config.Remove("commandTimeout"); if (config.Count > 0) { string attribUnrecognized = config.GetKey(0); if (!String.IsNullOrEmpty(attribUnrecognized)) { throw new ProviderException(SM.GetString(SM.Provider_unrecognized_attribute, attribUnrecognized)); } } var bll = new Applications(); if (!(bll.GetApplicationId(_AppName) is Guid)) { var appInfo = new ApplicationsInfo(Guid.Empty, "100000", _AppName, _AppName.ToLower(), "默认应用程序"); bll.Insert(appInfo); } }
public int Update(ApplicationsInfo model) { StringBuilder sb = new StringBuilder(500); sb.Append(@"update Applications set Coded = @Coded,Named = @Named,LowerName = @LowerName,Remark = @Remark where Id = @Id " ); SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier), new SqlParameter("@Coded", SqlDbType.Char, 6), new SqlParameter("@Named", SqlDbType.NVarChar, 50), new SqlParameter("@LowerName", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 256) }; parms[0].Value = model.Id; parms[1].Value = model.Coded; parms[2].Value = model.Named; parms[3].Value = model.LowerName; parms[4].Value = model.Remark; return(SqlHelper.ExecuteNonQuery(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), parms)); }
public Guid Insert(ApplicationsInfo model) { var effect = _db.Applications.Insert(model); return(effect.AsGuid); }
public int Update(ApplicationsInfo model) { return(dal.Update(model)); }
public int InsertByOutput(ApplicationsInfo model) { return(dal.InsertByOutput(model)); }
public int Update(ApplicationsInfo model) { throw new NotImplementedException(); }
public int InsertByOutput(ApplicationsInfo model) { throw new NotImplementedException(); }