public DataPage <BSOInfo> BSO_Find( BSOSearchCriteria criteria, List <SortCriteria <BSOSortField> > sortCriteria, PageRequest pageRequest) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@TemporaryPolicyNumberFrom", SqlDbType.NVarChar, criteria.TemporaryPolicyNumberFrom); parameters.AddInputParameter("@TemporaryPolicyNumberTo", SqlDbType.NVarChar, criteria.TemporaryPolicyNumberTo); parameters.AddInputParameter("@PolicyPartyNumber", SqlDbType.NVarChar, criteria.PolicyPartyNumber); parameters.AddInputParameter("@StatusId", SqlDbType.BigInt, criteria.StatusId); parameters.AddInputParameter("@ResponsibleID", SqlDbType.BigInt, criteria.ResponsibleID); parameters.AddInputParameter("@StatusDateFrom", SqlDbType.Date, criteria.StatusDateFrom); parameters.AddInputParameter("@StatusDateTo", SqlDbType.Date, criteria.StatusDateTo); parameters.AddInputParameter("@ChangeDateFrom", SqlDbType.DateTime, criteria.ChangeDateFrom); parameters.AddInputParameter("@ChangeDateTo", SqlDbType.DateTime, criteria.ChangeDateTo); parameters.AddInputParameter("@DeliveryCenterIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryCenterIds)); parameters.AddInputParameter("@DeliveryPointIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryPointIds)); //parameters.AddInputParameter("@ResponsibleIDs", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.ResponsibleIDs)); SqlParameter totalCountParameter = parameters.AddOutputParameter("@total_count", SqlDbType.Int); parameters.AddInputParameter("@sort_criteria", SqlDbType.Structured, DaoHelper.GetSortFieldsTable(sortCriteria)); parameters.AddInputParameter("@Page_size", SqlDbType.Int, pageRequest.PageSize); parameters.AddInputParameter("@Page_number", SqlDbType.Int, pageRequest.PageNumber); List <BSOInfo> bsos = Execute_GetList(BSOInfoMaterializer.Instance, "BSO_Find", parameters); return(DaoHelper.GetDataPage(bsos, totalCountParameter, pageRequest)); }
/// <summary> /// 添加排序SQL到Hashtable条件中 /// </summary> /// <param name="condtion"></param> /// <param name="orderColl"></param> protected void AddOrderPropertyCondition(Hashtable condtion, NameValueCollection orderColl) { string orderSql = DaoHelper.CreateOrderSql(orderColl, _orderPropertyColumnMap); if (string.IsNullOrEmpty(orderSql)) { orderSql = DaoHelper.CreateOrderSql(DefaultOrderCollection, _orderPropertyColumnMap); } if (string.IsNullOrEmpty(orderSql)) { return; } if (condtion == null) { condtion = new Hashtable(); } if (condtion.ContainsKey(SqlMapConstants.OrderPropertyParam)) { throw new DaoException("Dao查询条件Hashtable中不能定义键名为" + SqlMapConstants.OrderPropertyParam + ",与查询条件键字冲突。"); } condtion.Add(SqlMapConstants.OrderPropertyParam, orderSql); }
public DataPage <ClientBaseInfo> Client_Find( ClientSearchCriteria criteria, List <SortCriteria <ClientSortField> > sortCriteria, PageRequest pageRequest) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, criteria.Firstname); parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, criteria.Secondname); parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, criteria.Lastname); parameters.AddInputParameter("@Birthday", SqlDbType.Date, criteria.Birthday); parameters.AddInputParameter("@TemporaryPolicyDateFrom", SqlDbType.Date, criteria.TemporaryPolicyDateFrom); parameters.AddInputParameter("@TemporaryPolicyDateTo", SqlDbType.Date, criteria.TemporaryPolicyDateTo); parameters.AddInputParameter("@TemporaryPolicyNumber", SqlDbType.NVarChar, criteria.TemporaryPolicyNumber); parameters.AddInputParameter("@PolicySeries", SqlDbType.NVarChar, criteria.PolicySeries); parameters.AddInputParameter("@PolicyNumber", SqlDbType.NVarChar, criteria.PolicyNumber); parameters.AddInputParameter("@PolicyDateFrom", SqlDbType.Date, criteria.PolicyDateFrom); parameters.AddInputParameter("@PolicyDateTo", SqlDbType.Date, criteria.PolicyDateTo); parameters.AddInputParameter("@UnifiedPolicyNumber", SqlDbType.NVarChar, criteria.UnifiedPolicyNumber); SqlParameter totalCountParameter = parameters.AddOutputParameter("@total_count", SqlDbType.Int); parameters.AddInputParameter("@sort_criteria", SqlDbType.Structured, DaoHelper.GetSortFieldsTable(sortCriteria)); parameters.AddInputParameter("@Page_size", SqlDbType.Int, pageRequest.PageSize); parameters.AddInputParameter("@Page_number", SqlDbType.Int, pageRequest.PageNumber); List <ClientBaseInfo> clients = Execute_GetList(ClientBaseInfoMaterializer.Instance, "Client_Find", parameters); return(DaoHelper.GetDataPage(clients, totalCountParameter, pageRequest)); }
public string Build(bool ignorePrefix = true) { var sql = new StringBuilder(); var type = typeof(T); var(tableName, properties) = DaoHelper.GetMetas(type); var selectSql = new StringBuilder(); if (_selectField.Length > 0) { selectSql.Append(_selectField); } else { foreach (var property in properties) { selectSql.Append($"{property.ColumnName} as {property.Parameter},"); } selectSql.Remove(selectSql.Length - 1, 1); } sql.Append($"select {selectSql} from {tableName} {prefix} "); sql.Append(whereCommand.Build().Replace(DatabaseFactory.ParamterSplit, paramterPrefix)); return(sql.ToString()); }
/// <summary> /// 根据条件查询 /// </summary> /// <param name="condition">查询条件,如为null或为空则查询所有</param> /// <param name="orderPropertyColl"></param> /// <returns></returns> protected virtual IList <T> Select(Hashtable condition, NameValueCollection orderPropertyColl = null) { AddOrderPropertyCondition(condition, orderPropertyColl); Hashtable ht = DaoHelper.ProcessConditionHashtable(condition); return(_sqlMapper.QueryForList <T>(GetStatementIdWithNamespace(SqlMapConstants.SelectStatementId), ht)); }
public static string Send(string subject, string body, string to, string cc, string from) { string adminMain = WebConfigurationManager.AppSettings["MailAdmin"]; string message = ""; if ("".Equals(from)) { from = adminMain; } DaoResult daoResult = DaoHelper.Create("[dbo].[SP_Send_Mail] @profile_name, @program_key, @recipients, @copy_recipients, " + " @blind_copy_recipients, @subject, @body, @body_format, @importance, @sensitive, @from") .AddParameter("@profile_name", "Hunter Alert") // DB發信的設定名稱 .AddParameter("@program_key", "Hunter_Models_Mail_Send") .AddParameter("@recipients", to) // 收件者 .AddParameter("@copy_recipients", cc) // CC .AddParameter("@blind_copy_recipients", "") // 密件副本 .AddParameter("@subject", subject) // .AddParameter("@body", body) .AddParameter("@body_format", "HTML") .AddParameter("@importance", "NORMAL") .AddParameter("@sensitive", "NORMAL") .AddParameter("@from", from) // from .SetConnection("KWSEAI") .ExecuteUpdate(); if (!daoResult.IsSuccess) { message = daoResult.Message; } return(message); }
private void btn确定_Click(object sender, EventArgs e) { //switch (this.Text) //{ // case "起始地": // m_clzy.起始地时间 = (DateTime?)m_cm.DisplayManager.DataControls["途径地时间"].SelectedDataValue; // break; // case "途径地": // m_clzy.途径地时间 = (DateTime?)m_cm.DisplayManager.DataControls["途径地时间"].SelectedDataValue; // break; // case "终止地": // m_clzy.终止地时间 = (DateTime?)m_cm.DisplayManager.DataControls["途径地时间"].SelectedDataValue; // break; // default: // throw new ArgumentOutOfRangeException("实时监控经过地名时间 out of range"); //} if (m_cm.SaveCurrent()) { DaoHelper.DoInRepository(m_dao, (rep) => { m_dao.更新作业监控状态2(rep, m_clzy, (DateTime)m_cm.DisplayManager.DataControls["途径地时间"].SelectedDataValue, (string)m_cm.DisplayManager.DataControls["途径地编号"].SelectedDataValue, "结束"); }); this.DialogResult = System.Windows.Forms.DialogResult.OK; } else { this.DialogResult = System.Windows.Forms.DialogResult.None; } }
public string Build(bool ignorePrefix = true) { var columnList = new List <string>(); var parameterList = new List <string>(); var type = typeof(T); var(tableName, properties) = DaoHelper.GetMetas(type); foreach (var p in properties) { if (p.IsIdentity) { continue; } columnList.Add(p.ColumnName); parameterList.Add($"{paramterPrefix}{p.Parameter}"); //Console.WriteLine("Name:{0} Value:{1}", p.Name, p.GetValue(_model)); } StringBuilder sql = new StringBuilder(); sql.Append($"insert into {tableName} ({string.Join(",", columnList)}) values ({string.Join(",", parameterList)})"); return(sql.ToString()); }
public List <FundRequestRecid> ClientVisitId_GetByFundRequesetRecid(IEnumerable <long> recids) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@Recids", SqlDbType.Structured, DaoHelper.GetObjectIds(recids)); return(Execute_GetList <FundRequestRecid>(FundRequestRecidMaterializer.Instance, "ClientVisitId_GetByFundRequesetRecid", parameters)); }
public List <Nomernik.ClientShotInfo> ClientsShotInfo_Get(IEnumerable <long> listClientIds) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@ClientIDs", SqlDbType.Structured, DaoHelper.GetObjectIds(listClientIds)); List <Nomernik.ClientShotInfo> list = Execute_GetList(NomernikClientShotInfoMaterializer.Instance, "NomernikClientsShotInfo_Get", parameters); return(list); }
/// <summary> /// 根据条件分页查询(虚方法,可重写) /// </summary> /// <param name="startRecordIndex">当前页数据记录的起始索引,从1开始</param> /// <param name="pageSize">每页显示的记录数</param> /// <param name="condition">查询条件,如为null或未设置查询条件则查询所有</param> /// <param name="orderPropertyColl">排序条件</param> /// <returns>查询结果</returns> public virtual IList <T> SelectByPage(int startRecordIndex, int pageSize, Hashtable condition = null, NameValueCollection orderPropertyColl = null) { AddOrderPropertyCondition(condition, orderPropertyColl); Hashtable ht = DaoHelper.ProcessConditionHashtable(condition); DaoHelper.SetPageArg(ref ht, startRecordIndex, pageSize); return(_sqlMapper.QueryForList <T>(GetStatementIdWithNamespace(SqlMapConstants.SelectByPageStatementId), ht)); }
static TasksDaoHelper() { List <Assembly> assemblies = new List <Assembly> { typeof(TasksDaoHelper).Assembly, typeof(AuditLog).Assembly, }; DaoHelper.RegisterAssembly(typeof(TasksDaoHelper), assemblies); }
/// <summary> /// 根据条件删除 /// </summary> /// <param name="condition">删除条件,如为null或空则不进行删除</param> /// <returns>删除数量</returns> protected virtual int Delete(Hashtable condition) { Hashtable ht = DaoHelper.ProcessConditionHashtable(condition); if (ht == null || ht.Count == 0) { return(default(int)); } return(_sqlMapper.Delete(GetStatementIdWithNamespace(SqlMapConstants.DeleteStatementId), ht)); }
public DataPage <ClientVisitInfo> ClientVisit_Find( ClientVisitSearchCriteria criteria, List <SortCriteria <ClientVisitSortField> > sortCriteria, PageRequest pageRequest) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@ID", SqlDbType.BigInt, criteria.Id); parameters.AddInputParameter("@UnifiedPolicyNumber", SqlDbType.NVarChar, criteria.UnifiedPolicyNumber); parameters.AddInputParameter("@SNILS", SqlDbType.NVarChar, criteria.SNILS); parameters.AddInputParameter("@DocumentTypeId", SqlDbType.BigInt, criteria.DocumentTypeId); parameters.AddInputParameter("@DocumentNumber", SqlDbType.NVarChar, criteria.DocumentNumber); parameters.AddInputParameter("@DocumentSeries", SqlDbType.NVarChar, criteria.DocumentSeries); parameters.AddInputParameter("@TemporaryPolicyNumber", SqlDbType.NVarChar, criteria.TemporaryPolicyNumber); parameters.AddInputParameter("@TemporaryPolicyDateFrom", SqlDbType.DateTime, criteria.TemporaryPolicyDateFrom); parameters.AddInputParameter("@TemporaryPolicyDateTo", SqlDbType.DateTime, criteria.TemporaryPolicyDateTo); parameters.AddInputParameter("@PolicyNumber", SqlDbType.NVarChar, criteria.PolicyNumber); parameters.AddInputParameter("@PolicySeries", SqlDbType.NVarChar, criteria.PolicySeries); parameters.AddInputParameter("@PolicyDateFrom", SqlDbType.DateTime, criteria.PolicyDateFrom); parameters.AddInputParameter("@PolicyDateTo", SqlDbType.DateTime, criteria.PolicyDateTo); parameters.AddInputParameter("@UpdateDateFrom", SqlDbType.DateTime, criteria.UpdateDateFrom); parameters.AddInputParameter("@UpdateDateTo", SqlDbType.DateTime, criteria.UpdateDateTo); parameters.AddInputParameter("@StatusDateFrom", SqlDbType.DateTime, criteria.StatusDateFrom); parameters.AddInputParameter("@StatusDateTo", SqlDbType.DateTime, criteria.StetusDateTo); parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, criteria.Firstname); parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, criteria.Secondname); parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, criteria.Lastname); parameters.AddInputParameter("@UserId", SqlDbType.BigInt, criteria.UserId); parameters.AddInputParameter("@Birthday", SqlDbType.Date, criteria.Birthday); parameters.AddInputParameter("@PartyNumber", SqlDbType.NVarChar, criteria.PartyNumber); parameters.AddInputParameter("@DeliveryCenterIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryCenterIds)); parameters.AddInputParameter("@DeliveryPointIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.DeliveryPointIds)); parameters.AddInputParameter("@StatusIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.StatusIds)); parameters.AddInputParameter("@ScenarioIds", SqlDbType.Structured, DaoHelper.GetObjectIds(criteria.ScenarioIds)); parameters.AddInputParameter("@IsTemporaryPolicyNumberNotEmpty", SqlDbType.Bit, criteria.IsTemporaryPolicyNumberNotEmpty); parameters.AddInputParameter("@IsActualInVisitGroup", SqlDbType.Bit, criteria.IsActualInVisitGroup); parameters.AddInputParameter("@IsReadyToFundSubmitRequest", SqlDbType.Bit, criteria.IsReadyToFundSubmitRequest); parameters.AddInputParameter("@IsDifficultCase", SqlDbType.Bit, criteria.IsDifficultCase); SqlParameter totalCountParameter = parameters.AddOutputParameter("@total_count", SqlDbType.Int); parameters.AddInputParameter("@sort_criteria", SqlDbType.Structured, DaoHelper.GetSortFieldsTable(sortCriteria)); parameters.AddInputParameter("@Page_size", SqlDbType.Int, pageRequest.PageSize); parameters.AddInputParameter("@Page_number", SqlDbType.Int, pageRequest.PageNumber); List <ClientVisitInfo> clients = Execute_GetList(ClientVisitInfoMaterializer.Instance, "ClientVisit_Find", parameters); return(DaoHelper.GetDataPage(clients, totalCountParameter, pageRequest)); }
public List <BSOHistoryItem> BSO_GetListHistory(DateTime StatusDateFrom, DateTime StatusDateTo, List <long> BSO_IDs) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@StatusDateFrom", SqlDbType.DateTime, StatusDateFrom); parameters.AddInputParameter("@StatusDateTo", SqlDbType.DateTime, StatusDateTo); var temp = DaoHelper.GetObjectIds(BSO_IDs); parameters.AddInputParameter("@BSO_IDs", SqlDbType.Structured, DaoHelper.GetObjectIds(BSO_IDs)); List <BSOHistoryItem> result = Execute_GetList(BSOHistoryItemMaterializer.Instance, "BSO_GetListHistory", parameters); return(result); }
/// <summary> /// 根据查询条件更新关联领域对象(虚方法,可重写) /// </summary> /// <param name="relatedDomain">更新关联领域对象的值</param> /// <param name="relatedDomainId">更新关联领域对象Id的值</param> /// <param name="condition">查询条件</param> /// <returns>更新记录数</returns> public virtual int UpdateRelated(string relatedDomain, string relatedDomainId, Hashtable condition) { if (condition == null || condition.Count == 0) { return(default(int)); } Hashtable ht = CreateRelatedConditionHashtable(relatedDomain, relatedDomainId, condition); ht = DaoHelper.ProcessConditionHashtable(ht); return(_sqlMapper.Update(GetStatementIdWithNamespace(SqlMapConstants.UpdateRelatedStatementId), ht)); }
public void Delete(int id) { Livre _livre; _livre = dao.GetById(id); DaoHelper.BeginTransaction(); dao.Delete(_livre); try { DaoHelper.CommitTransaction(); } catch { } }
public void Delete(int id) { Media _media; _media = dao.GetById(id); DaoHelper.BeginTransaction(); dao.Delete(_media); try { DaoHelper.CommitTransaction(); } catch { } }
public HttpResponseMessage Post([FromBody] Media media) { if (media == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } DaoHelper.BeginTransaction(); dao.Save(media); try { DaoHelper.CommitTransaction(); } catch { } return(new HttpResponseMessage(HttpStatusCode.Created)); }
public HttpResponseMessage Post([FromBody] Livre livre) { if (livre == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } DaoHelper.BeginTransaction(); dao.Save(livre); try { DaoHelper.CommitTransaction(); } catch { } return(new HttpResponseMessage()); }
public void Put(int id, [FromBody] Media media) { int i = media.Id; Media _media; _media = dao.GetById(id); _media.Libelle = media.Libelle; DaoHelper.BeginTransaction(); dao.Save(_media); try { DaoHelper.CommitTransaction(); } catch { } }
/// <summary> /// 根据条件查询顶部指定数量的数据,此方法使用SELECT TOP语句进行查询 /// </summary> /// <param name="topCount">查询数量</param> /// <param name="condition">查询条件,如为null或空则查询所有</param> /// <param name="orderPropertyColl">排序条件</param> /// <returns>查询结果</returns> protected virtual IList <T> SelectTop(int topCount, Hashtable condition, NameValueCollection orderPropertyColl) { if (condition == null) { condition = new Hashtable(); } if (condition.ContainsKey(SqlMapConstants.TopCountParam)) { throw new DaoException("查询条件Hashtable中不能定义名称为" + SqlMapConstants.TopCountParam + "的Key。"); } condition.Add(SqlMapConstants.TopCountParam, topCount); AddOrderPropertyCondition(condition, orderPropertyColl); Hashtable ht = DaoHelper.ProcessConditionHashtable(condition); return(_sqlMapper.QueryForList <T>(GetStatementIdWithNamespace(SqlMapConstants.SelectTopStatementId), ht)); }
public string Build(bool ignorePrefix = true) { var sql = new StringBuilder(); var type = typeof(T); var(tableName, properties) = DaoHelper.GetMetas(type); sql.Append($"update {tableName} set "); if (_visitor.UpdatedFields.Any()) { _visitor.UpdatedFields.ForEach(t => { sql.Append($" {t.ColumnName} = {paramterPrefix}{t.Parameter},"); }); sql.Remove(sql.Length - 1, 1); sql.Append(" where "); foreach (var member in properties.Where(t => t.IsPrimaryKey)) { sql.Append($" {member.ColumnName} = {paramterPrefix}{member.Parameter} and"); } } else { var existProperty = properties.Where(p => !p.IsPrimaryKey && _ignorevisitor.UpdatedFields.All(t => t.ColumnName != p.ColumnName)); foreach (var p in existProperty) { sql.Append($" {p.ColumnName} = {paramterPrefix}{p.Parameter},"); } sql.Remove(sql.Length - 1, 1); sql.Append(" where "); foreach (var member in properties.Where(t => t.IsPrimaryKey)) { sql.Append($" {member.ColumnName} = {paramterPrefix}{member.Parameter} and"); } } sql.Remove(sql.Length - 3, 3); return(sql.ToString()); }
private void btn退回_Click(object sender, EventArgs e) { 车辆作业Dao dao1 = new 车辆作业Dao(); 专家任务Dao dao2 = new 专家任务Dao(); DaoHelper.DoInRepository((rep) => { m_clzy.IsActive = false; string ly = (string)m_dm.DataControls["理由"].SelectedDataValue; m_clzy.备注 += "已退回," + (string.IsNullOrEmpty(ly) ? string.Empty : ("理由:" + ly)); dao1.Update(rep, m_clzy); m_clzy.专家任务.车辆作业 = null; //m_clzy.专家任务.是否已下达 = false; dao2.Update(rep, m_clzy.专家任务); }); }
public string Build() { var sql = new StringBuilder(); var type = typeof(T); var(tableName, _) = DaoHelper.GetMetas(type); sql.Append($"delete from {tableName} "); //sql.Append(" where "); sql.Append(whereCommand.Build().Replace(DatabaseFactory.ParamterSplit, DbPrefix)); //sql.Remove(sql.Length - 3, 3); return(sql.ToString()); }
public string Build(bool ignorePrefix = true) { var sql = new StringBuilder(); var type = typeof(T); var(tableName, _) = DaoHelper.GetMetas(type); sql.Append($"update {tableName} set "); sql.Append(setSql); sql.Remove(sql.Length - 1, 1); sql.Append(whereCommand.Build().Replace(DatabaseFactory.ParamterSplit, paramterPrefix)); return(sql.ToString()); }
private static bool CheckAuthLogin( DbConnection conn, string userId, out int success, out DateTime?currentTime, out DateTime?loginTime, out DateTime?hangUpTime ) { success = 0; currentTime = null; loginTime = null; hangUpTime = null; bool retVal = false; const string strQuery = "SELECT SUCCESS, SYSDATE, LOGINTIME, HANGUPTIME FROM ASPIRIN.AUTHLOGIN " + "WHERE USERID = :UserId AND RECID = (SELECT MAX(RECID) FROM ASPIRIN.AUTHLOGIN WHERE USERID = :UserId)"; using (DbCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; DaoHelper.AddInputParameter(cmd, "UserId", userId); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { success = Convert.ToInt32(reader[0]); currentTime = reader[1] as DateTime?; loginTime = reader[2] as DateTime?; hangUpTime = reader[3] as DateTime?; retVal = true; } } } return(retVal); }
public long User_Save(User.SaveData data) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.AddInputParameter("@Login", SqlDbType.NVarChar, data.Login); parameters.AddInputParameter("@PasswordHash", SqlDbType.NVarChar, data.PasswordHash); parameters.AddInputParameter("@DepartmentId", SqlDbType.BigInt, data.DepartmentId); parameters.AddInputParameter("@DeliveryPointId", SqlDbType.BigInt, data.DeliveryPointId); parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, data.Firstname); parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, data.Secondname); parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, data.Lastname); parameters.AddInputParameter("@Roles", SqlDbType.Structured, DaoHelper.GetObjectIds(data.Roles)); parameters.AddInputParameter("@SaveDate", SqlDbType.DateTime, DateTime.Now); parameters.AddInputParameter("@Position", SqlDbType.NVarChar, data.Position); parameters.AddInputParameter("@Email", SqlDbType.NVarChar, data.Email); parameters.AddInputParameter("@Phone", SqlDbType.NVarChar, data.Phone); SqlParameter userId = parameters.AddInputOutputParameter("@UserID", SqlDbType.BigInt, data.Id); Execute_StoredProcedure("User_Save", parameters); return((long)userId.Value); }
public IList <string> FilmTitleWhereWasPartecipateSpecificActor(int ActorId) { var parameters = CreateDbParameters(); string parameterName = string.Empty; string parameterName4Sql = string.Empty; parameterName = "idActor"; parameterName4Sql = DaoHelper.GetParamNameForProvider(parameterName); parameters.AddWithValue(parameterName4Sql, ActorId); Film film = null; //Actor actor = null; //Cast cast = null; string selectStr = @"SELECT DISTINCT FILMTITLE FROM {0} INNER JOIN CAST ON FILMS.ID = FILMID INNER JOIN ACTORS ON ACTORID = ACTORS.IDACTOR WHERE ACTORS.IDACTOR = {1}".FormatWith(film.GetTableNameForEntity(), parameters[0].Value); var builder = NewSqlQueryBuilder() .CustomSql(selectStr); //.RegisterTableAlias(aliasFilm, film.GetTableNameForEntity()) //.RegisterTableAlias(aliasActor, actor.GetTableNameForEntity()) //.RegisterTableAlias(aliasCast, cast.GetTableNameForEntity()) //.Select() //.Distinct() //.AddFieldsToSelect<Film>(aliasFilm, x => x.FilmTitle) //.From(aliasFilm) //.InnerJoin(new TableDef {Alias = aliasCast, Schema = Schema, TableName = cast.GetTableNameForEntity() }) //.On() //.JoinCondition(aliasFilm, film.GetFieldName( f => f.Id), WhereOperator.EqualTo, aliasCast, cast.GetFieldName(c => c.FilmId)) //.InnerJoin(new TableDef {Alias = aliasActor, Schema = Schema, TableName = actor.GetTableNameForEntity() }) //.On() //.JoinCondition(aliasCast, cast.GetFieldName(c => c.ActorId), WhereOperator.EqualTo ,aliasActor, actor.GetFieldName(a => a.Id)) //.Where() //.Condition<Actor>(aliasActor, a => a.Id, WhereOperator.EqualTo, idActor); return(QueryForListOfString(builder)); }
public HttpResponseMessage Put(int id, [FromBody] Livre livre) { var x = new HttpResponseMessage(); Livre _livre = dao.GetById(id); if (_livre.Version == livre.Version) { _livre.Auteur = livre.Auteur; _livre.Titre = livre.Titre; if (_livre.Genre != livre.Genre) { _livre.Genre = daoGenre.GetById(livre.Genre.Id); } if (_livre.TypeDocument.Id != livre.TypeDocument.Id) { _livre.TypeDocument = daoTypeDocument.GetById(livre.TypeDocument.Id); } DaoHelper.BeginTransaction(); dao.Save(_livre); try { DaoHelper.CommitTransaction(); } catch { } return(new HttpResponseMessage(HttpStatusCode.OK)); } else { x.ReasonPhrase = "coucou"; } return(x); }