/// <summary>
/// 得到一行员工信息
/// </summary>
/// <param name="yybh"></param>
/// <param name="ydjh"></param>
/// <returns></returns>
public QyygxxModel GetModel(string yybh, string ydjh)
{
string sql = "SELECT * FROM dbo.qy_ygxx WHERE yybh = @yybh AND ydjh = @ydjh";
using (IDbConnection conn = new DapperConnection().DbConnection)
{
QyygxxModel obj = conn.QueryFirstOrDefault <QyygxxModel>(sql, new { yybh = yybh, ydjh = ydjh });
return(obj);
}
}
public void ConfirmOrder(DdjbxxModel ddModel, List <DdZhxmModel> zhxmList, QyygxxModel ygModel)
{
StringBuilder strSql = new StringBuilder();
using (IDbConnection conn = new DapperConnection().DbConnection)
{
IDbTransaction transaction = conn.BeginTransaction();
try
{
if (ddModel.jsbz == 0)//自已才更新
{
strSql.AppendFormat("UPDATE dbo.qy_ygxx SET sfyy=@sfyy WHERE id=@id");
conn.Execute(strSql.ToString(), new { sfyy = ygModel.sfyy, id = ygModel.id }, transaction);
}
strSql.Clear();
if (string.IsNullOrEmpty(ddModel.csrq))
{
ddModel.csrq = DateTime.Now.ToString("yyyy-MM-dd");
}
strSql.Append("insert into dd_jbxx_new(");
strSql.Append("trade_no,zffs,ddbh,dsfdd,dsfbzid,ddzt,tcid,tcmc,dwbh,tcjg,jxbjg,ddze,intime,sfout,outtime,dh,xm,xb,hz,zjlx,zjhm,yykssj,yyjssj,sfdj,djtime,sfbg,bgtime,djlsh,sfjx,jxlist,sfjs,csrq,nl,remark,yybh,ddly,dwmc,jsbz,ygzh)");
strSql.Append(" values (");
strSql.Append("'',@zffs,@ddbh,@dsfdd,@dsfbzid,@ddzt,@tcid,@tcmc,@dwbh,@tcjg,@jxbjg,@ddze,@intime,@sfout,@outtime,@dh,@xm,@xb,@hz,@zjlx,@zjhm,@yykssj,@yyjssj,@sfdj,@djtime,@sfbg,@bgtime,@djlsh,@sfjx,@jxlist,@sfjs,@csrq,@nl,@remark,@yybh,@ddly,@dwmc,@jsbz,@ygzh)");
conn.Execute(strSql.ToString(), ddModel, transaction);
strSql.Clear();
strSql.Append("insert into dd_zhxm(");
strSql.Append("ddbh,zhxmbh,zhxmmc,jg,sfjx,sfdj)");
strSql.Append(" values (");
strSql.Append("@ddbh,@zhxmbh,@zhxmmc,@jg,@sfjx,@sfdj)");
conn.Execute(strSql.ToString(), zhxmList, transaction);
transaction.Commit();
}
catch (Exception ex)
{
LogApiHelper.AddLog(ex.Message);
transaction.Rollback();
throw;
}
}
}
/// <summary>
/// 删除员工
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteQyyg(int id)
{
QyygxxModel model = new QyygxxModel();
string sqlGet = "SELECT * FROM dbo.qy_ygxx WHERE id=@id";
using (IDbConnection conn = new DapperConnection().DbConnection)
{
model = conn.QueryFirstOrDefault <QyygxxModel>(sqlGet, new { id = id });
}
string sql = "delete from xt_yhb where zh='" + model.ygzh + "'; delete from dd_zhxm where ddbh in (select ddbh from dd_jbxx_new where yybh ='" + model.yybh + "' and dsfdd='" + model.ydjh + "' and ddly=1 ); delete from dd_jbxx_new where yybh ='" + model.yybh + "' and dsfdd='" + model.ydjh + "' and ddly=1;delete from qy_ygxx where id=" + id;
using (IDbConnection conn = new DapperConnection().DbConnection)
{
return(conn.Execute(sql, null));
}
}
