/// <summary>
/// 新增公章申请
/// </summary>
/// <param name="model"></param>
/// <param name="list"></param>
/// <returns></returns>
public bool Add(OA.Model.ApplyPublicPower model, IList <ApplyPublicPowerItem> list)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ApplyPublicPower(");
strSql.Append("AppID,DeptID,ApplyDate,Creator,CreateTime,FirstChecker,SecondChecker)");
strSql.Append(" values (");
strSql.Append("@AppID,@DeptID,@ApplyDate,@Creator,@CreateTime,@FirstChecker,@SecondChecker)");
SqlParameter[] parameters =
{
new SqlParameter("@AppID", SqlDbType.VarChar, 36),
new SqlParameter("@DeptID", SqlDbType.VarChar, 36),
new SqlParameter("@ApplyDate", SqlDbType.Char, 8),
new SqlParameter("@Creator", SqlDbType.VarChar, 36),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@FirstChecker", SqlDbType.VarChar, 36),
new SqlParameter("@SecondChecker", SqlDbType.VarChar, 36)
};
parameters[0].Value = model.AppID;
parameters[1].Value = model.DeptID;
parameters[2].Value = model.ApplyDate;
parameters[3].Value = model.Creator;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.FirstChecker;
parameters[6].Value = model.SecondChecker;
IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString);
try
{
DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
ApplyPublicPowerItemDAL itemBll = new ApplyPublicPowerItemDAL();
for (int i = 0; i < list.Count; i++)
{
ApplyPublicPowerItem item = list[i] as ApplyPublicPowerItem;
itemBll.Add(item);
}
transaction.Commit();
}
catch
{
transaction.Rollback();
}
return(true);
}
/// <summary>
/// 新增公章申请
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(OA.Model.ApplyPublicPower model, IList <ApplyPublicPowerItem> list)
{
return(iApplyPublicPowerDAL.Add(model, list));
}