/// <summary>
/// 添加分阅人
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Model.SOReader model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SOReader(");
strSql.Append("SOReadID,SaleOrderID,ReaderID,ReadFlag)");
strSql.Append(" values (");
strSql.Append("@SOReadID,@SaleOrderID,@ReaderID,@ReadFlag)");
SqlParameter[] parameters =
{
new SqlParameter("@SOReadID", SqlDbType.VarChar, 36),
new SqlParameter("@SaleOrderID", SqlDbType.VarChar, 36),
new SqlParameter("@ReaderID", SqlDbType.VarChar, 36),
new SqlParameter("@ReadFlag", SqlDbType.Char, 1)
};
parameters[0].Value = model.SOReadID;
parameters[1].Value = model.SaleOrderID;
parameters[2].Value = model.ReaderID;
parameters[3].Value = model.ReadFlag;
int rows = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据销售订单ID获取分阅人模型
/// </summary>
/// <param name="SaleOrderID"></param>
/// <returns></returns>
public List <Model.SOReader> GetModel(string SaleOrderID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SOReadID,SaleOrderID,ReaderID,ReadTime,ReadFlag,U.UserName from SOReader SOR ");
strSql.Append(" inner join OA_User U on U.UserID = SOR.ReaderID ");
strSql.Append(" where SaleOrderID=@SaleOrderID ");
SqlParameter[] parameters =
{
new SqlParameter("@SaleOrderID", SqlDbType.VarChar, 36)
};
parameters[0].Value = SaleOrderID;
DataSet ds = DBAccess.ExecuteDataset(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
List <Model.SOReader> list = new List <OA.Model.SOReader>();
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Model.SOReader model = new Model.SOReader();
model.SOReadID = dr["SOReadID"].ToString();
model.SaleOrderID = dr["SaleOrderID"].ToString();
model.ReaderID = dr["ReaderID"].ToString();
if (dr["ReadTime"] != null && dr["ReadTime"].ToString() != "")
{
model.ReadTime = DateTime.Parse(dr["ReadTime"].ToString());
}
model.ReadFlag = dr["ReadFlag"].ToString();
model.ReaderName = dr["UserName"].ToString();
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 添加分阅人
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Model.SOReader model)
{
return(iSOReaderDAL.Add(model));
}
