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