/// <summary>
/// 添加复审人
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(GMSecondCheck model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GMSecondCheck(");
strSql.Append("GMSecondCheckID,GoodsMovementID,SecondChecker,SecondCheckView,SecondCheckTime,CheckFlag)");
strSql.Append(" values (");
strSql.Append("@GMSecondCheckID,@GoodsMovementID,@SecondChecker,@SecondCheckView,@SecondCheckTime,@CheckFlag)");
SqlParameter[] parameters =
{
new SqlParameter("@GMSecondCheckID", SqlDbType.VarChar, 36),
new SqlParameter("@GoodsMovementID", SqlDbType.VarChar, 36),
new SqlParameter("@SecondChecker", SqlDbType.VarChar, 36),
new SqlParameter("@SecondCheckView", SqlDbType.VarChar, 255),
new SqlParameter("@SecondCheckTime", SqlDbType.DateTime),
new SqlParameter("@CheckFlag", SqlDbType.Char, 1)
};
parameters[0].Value = model.GMSecondCheckID;
parameters[1].Value = model.GoodsMovementID;
parameters[2].Value = model.SecondChecker;
parameters[3].Value = model.SecondCheckView;
parameters[4].Value = model.SecondCheckTime;
parameters[5].Value = model.CheckFlag;
int rows = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批准
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Check(GMSecondCheck model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GMSecondCheck set ");
strSql.Append("SecondCheckTime=@SecondCheckTime,");
strSql.Append("SecondCheckView=@SecondCheckView,");
strSql.Append("CheckFlag=@CheckFlag");
strSql.Append(" where GMSecondCheckID=@GMSecondCheckID ");
SqlParameter[] parameters =
{
new SqlParameter("@SecondCheckTime", SqlDbType.DateTime),
new SqlParameter("@SecondCheckView", SqlDbType.VarChar, 255),
new SqlParameter("@CheckFlag", SqlDbType.Char, 1),
new SqlParameter("@GMSecondCheckID", SqlDbType.VarChar, 36)
};
parameters[0].Value = model.SecondCheckTime;
parameters[1].Value = model.SecondCheckView;
parameters[2].Value = model.CheckFlag;
parameters[3].Value = model.GMSecondCheckID;
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="GoodsMovementID"></param>
/// <returns></returns>
public List <GMSecondCheck> GetModel(string GoodsMovementID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select GMSecondCheckID,GoodsMovementID,SecondChecker,SecondCheckView,SecondCheckTime,CheckFlag,U.UserName from GMSecondCheck GMC ");
strSql.Append(" inner join OA_User U on U.UserID = GMC.SecondChecker ");
strSql.Append(" where GoodsMovementID=@GoodsMovementID ");
SqlParameter[] parameters =
{
new SqlParameter("@GoodsMovementID", SqlDbType.VarChar, 36)
};
parameters[0].Value = GoodsMovementID;
DataSet ds = DBAccess.ExecuteDataset(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
List <GMSecondCheck> list = new List <GMSecondCheck>();
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
GMSecondCheck model = new GMSecondCheck();
if (dr["GMSecondCheckID"] != null && dr["GMSecondCheckID"].ToString() != "")
{
model.GMSecondCheckID = dr["GMSecondCheckID"].ToString();
}
if (dr["GoodsMovementID"] != null && dr["GoodsMovementID"].ToString() != "")
{
model.GoodsMovementID = dr["GoodsMovementID"].ToString();
}
if (dr["SecondChecker"] != null && dr["SecondChecker"].ToString() != "")
{
model.SecondChecker = dr["SecondChecker"].ToString();
}
if (dr["SecondCheckView"] != null && dr["SecondCheckView"].ToString() != "")
{
model.SecondCheckView = dr["SecondCheckView"].ToString();
}
if (dr["SecondCheckTime"] != null && dr["SecondCheckTime"].ToString() != "")
{
model.SecondCheckTime = DateTime.Parse(dr["SecondCheckTime"].ToString());
}
if (dr["CheckFlag"] != null && dr["CheckFlag"].ToString() != "")
{
model.CheckFlag = dr["CheckFlag"].ToString();
}
if (dr["UserName"] != null && dr["UserName"].ToString() != "")
{
model.SecondCheckerName = dr["UserName"].ToString();
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 复审
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool SecondCheck(GoodsMovement model, GMSecondCheck gmsc)
{
return(iGoodsMovementDAL.SecondCheck(model, gmsc));
}