/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model">数据实体</param>
/// <returns></returns>
public int Add(Models.APP.Application model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@a_id", model.a_id),
new SqlParameter("@type", model.type),
new SqlParameter("@state", model.state),
new SqlParameter("@code", model.code),
new SqlParameter("@m_id", model.m_id),
new SqlParameter("@name", model.name),
new SqlParameter("@phon", model.phon),
new SqlParameter("@sex", model.sex),
new SqlParameter("@age", model.age),
new SqlParameter("@address", model.address),
new SqlParameter("@professional", model.professional),
new SqlParameter("@company", model.company),
new SqlParameter("@createtime", model.createtime),
new SqlParameter("@modifytime", model.modifytime),
new SqlParameter("@userid", model.userid),
new SqlParameter("@muserid", model.muserid),
new SqlParameter("@pk_id", model.pk_id),
new SqlParameter("@amount", model.amount)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"INSERT INTO App_Application(
a_id
,type
,state
,code
,m_id
,name
,phon
,sex
,age
,address
,professional
,company
,createtime
,modifytime
,userid
,muserid
,pk_id
,amount
) VALUES(
@a_id
,@type
,@state
,@code
,@m_id
,@name
,@phon
,@sex
,@age
,@address
,@professional
,@company
,@createtime
,@modifytime
,@userid
,@muserid
,@pk_id
,@amount
);SELECT @@Identity;" );
return(Convert.ToInt32(SqlHelper.ExecuteScalar(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, cmdText.ToString(), para)));
}
catch (ArgumentNullException ex)
{
logger.Error("调用方法Add()发生ArgumentNullException", ex);
}
catch (SqlException ex)
{
logger.Error("调用方法Add()发生SqlException", ex);
}
catch (Exception ex)
{
logger.Error("调用方法Add()发生Exception", ex);
}
return(-1);
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="_entity"></param>
/// <returns></returns>
public int Update(Models.APP.Application model)
{
return(dal.Update(model));
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="_entity"></param>
/// <returns></returns>
public int Update(Models.APP.Application model)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@ap_id", model.ap_id),
new SqlParameter("@a_id", model.a_id),
new SqlParameter("@type", model.type),
new SqlParameter("@state", model.state),
new SqlParameter("@code", model.code),
new SqlParameter("@m_id", model.m_id),
new SqlParameter("@name", model.name),
new SqlParameter("@phon", model.phon),
new SqlParameter("@sex", model.sex),
new SqlParameter("@age", model.age),
new SqlParameter("@address", model.address),
new SqlParameter("@professional", model.professional),
new SqlParameter("@company", model.company),
new SqlParameter("@createtime", model.createtime),
new SqlParameter("@modifytime", model.modifytime),
new SqlParameter("@userid", model.userid),
new SqlParameter("@muserid", model.muserid),
new SqlParameter("@pk_id", model.pk_id)
};
StringBuilder cmdText = new StringBuilder();
cmdText.Append(@"UPDATE [App_Application]
SET [a_id]=@a_id
,[type]=@type
,[state]=@state
,[code]=@code
,[m_id]=@m_id
,[name]=@name
,[phon]=@phon
,[sex]=@sex
,[age]=@age
,[address]=@address
,[professional]=@professional
,[company]=@company
,[createtime]=@createtime
,[modifytime]=@modifytime
,[userid]=@userid
,[muserid]=@muserid
,[pk_id]=@pk_id
WHERE [ap_id]=@ap_id" );
return(SqlHelper.ExecuteNonQuery(DefaultConnection.ConnectionStringByDefaultDB, CommandType.Text, cmdText.ToString(), para));
}
catch (ArgumentNullException ex)
{
logger.Error("调用方法Update()发生ArgumentNullException", ex);
}
catch (SqlException ex)
{
logger.Error("调用方法Update()发生SqlException", ex);
}
catch (Exception ex)
{
logger.Error("调用方法Update()发生Exception", ex);
}
return(-1);
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model">数据实体</param>
/// <returns></returns>
public int Add(Models.APP.Application model)
{
return(dal.Add(model));
}
