public Model.Paymentnode GetModels(int Id, int xuhao, int Distinguish)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,projectId,xuhao,Distinguish,Stateofapproval,SAE,AD,SAD,yinxiaozongjian,caiwu,laoban,zhulaoban,paymentapplicationformiId,Rejection from paymentnode ");
strSql.Append(" where projectId=@Id and xuhao=@xuhao and Distinguish=@Distinguish");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@xuhao", SqlDbType.Int, 4),
new SqlParameter("@Distinguish", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
parameters[1].Value = xuhao;
parameters[2].Value = Distinguish;
Model.Paymentnode model = new Model.Paymentnode();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Paymentnode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into paymentnode(");
strSql.Append("projectId,xuhao,Distinguish,Stateofapproval,SAE,AD,SAD,yinxiaozongjian,caiwu,laoban,zhulaoban,paymentapplicationformiId,Rejection)");
strSql.Append(" values (");
strSql.Append("@projectId,@xuhao,@Distinguish,@Stateofapproval,@SAE,@AD,@SAD,@yinxiaozongjian,@caiwu,@laoban,@zhulaoban,@paymentapplicationformiId,@Rejection)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@projectId", SqlDbType.Int, 4),
new SqlParameter("@xuhao", SqlDbType.Int, 4),
new SqlParameter("@Distinguish", SqlDbType.Int, 4),
new SqlParameter("@Stateofapproval", SqlDbType.Int, 4),
new SqlParameter("@SAE", SqlDbType.NVarChar, 50),
new SqlParameter("@AD", SqlDbType.NVarChar, 50),
new SqlParameter("@SAD", SqlDbType.NVarChar, 50),
new SqlParameter("@yinxiaozongjian", SqlDbType.NVarChar, 50),
new SqlParameter("@caiwu", SqlDbType.NVarChar, 50),
new SqlParameter("@laoban", SqlDbType.NVarChar, 50),
new SqlParameter("@zhulaoban", SqlDbType.NVarChar, 50),
new SqlParameter("@paymentapplicationformiId", SqlDbType.Int, 4),
new SqlParameter("@Rejection", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.projectId;
parameters[1].Value = model.xuhao;
parameters[2].Value = model.Distinguish;
parameters[3].Value = model.Stateofapproval;
parameters[4].Value = model.SAE;
parameters[5].Value = model.AD;
parameters[6].Value = model.SAD;
parameters[7].Value = model.yinxiaozongjian;
parameters[8].Value = model.caiwu;
parameters[9].Value = model.laoban;
parameters[10].Value = model.zhulaoban;
parameters[11].Value = model.paymentapplicationformiId;
parameters[12].Value = model.Rejection;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Paymentnode model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Paymentnode model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Paymentnode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update paymentnode set ");
strSql.Append("projectId=@projectId,");
strSql.Append("xuhao=@xuhao,");
strSql.Append("Distinguish=@Distinguish,");
strSql.Append("Stateofapproval=@Stateofapproval,");
strSql.Append("SAE=@SAE,");
strSql.Append("AD=@AD,");
strSql.Append("SAD=@SAD,");
strSql.Append("yinxiaozongjian=@yinxiaozongjian,");
strSql.Append("caiwu=@caiwu,");
strSql.Append("laoban=@laoban,");
strSql.Append("zhulaoban=@zhulaoban,");
strSql.Append("paymentapplicationformiId=@paymentapplicationformiId,");
strSql.Append("Rejection=@Rejection");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@projectId", SqlDbType.Int, 4),
new SqlParameter("@xuhao", SqlDbType.Int, 4),
new SqlParameter("@Distinguish", SqlDbType.Int, 4),
new SqlParameter("@Stateofapproval", SqlDbType.Int, 4),
new SqlParameter("@SAE", SqlDbType.NVarChar, 50),
new SqlParameter("@AD", SqlDbType.NVarChar, 50),
new SqlParameter("@SAD", SqlDbType.NVarChar, 50),
new SqlParameter("@yinxiaozongjian", SqlDbType.NVarChar, 50),
new SqlParameter("@caiwu", SqlDbType.NVarChar, 50),
new SqlParameter("@laoban", SqlDbType.NVarChar, 50),
new SqlParameter("@zhulaoban", SqlDbType.NVarChar, 50),
new SqlParameter("@paymentapplicationformiId", SqlDbType.Int, 4),
new SqlParameter("@Rejection", SqlDbType.NVarChar, 500),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.projectId;
parameters[1].Value = model.xuhao;
parameters[2].Value = model.Distinguish;
parameters[3].Value = model.Stateofapproval;
parameters[4].Value = model.SAE;
parameters[5].Value = model.AD;
parameters[6].Value = model.SAD;
parameters[7].Value = model.yinxiaozongjian;
parameters[8].Value = model.caiwu;
parameters[9].Value = model.laoban;
parameters[10].Value = model.zhulaoban;
parameters[11].Value = model.paymentapplicationformiId;
parameters[12].Value = model.Rejection;
parameters[13].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Paymentnode DataRowToModel(DataRow row)
{
Model.Paymentnode model = new Model.Paymentnode();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["projectId"] != null && row["projectId"].ToString() != "")
{
model.projectId = int.Parse(row["projectId"].ToString());
}
if (row["xuhao"] != null && row["xuhao"].ToString() != "")
{
model.xuhao = int.Parse(row["xuhao"].ToString());
}
if (row["Distinguish"] != null && row["Distinguish"].ToString() != "")
{
model.Distinguish = int.Parse(row["Distinguish"].ToString());
}
if (row["Stateofapproval"] != null && row["Stateofapproval"].ToString() != "")
{
model.Stateofapproval = int.Parse(row["Stateofapproval"].ToString());
}
if (row["SAE"] != null)
{
model.SAE = row["SAE"].ToString();
}
if (row["AD"] != null)
{
model.AD = row["AD"].ToString();
}
if (row["SAD"] != null)
{
model.SAD = row["SAD"].ToString();
}
if (row["yinxiaozongjian"] != null)
{
model.yinxiaozongjian = row["yinxiaozongjian"].ToString();
}
if (row["caiwu"] != null)
{
model.caiwu = row["caiwu"].ToString();
}
if (row["laoban"] != null)
{
model.laoban = row["laoban"].ToString();
}
if (row["zhulaoban"] != null)
{
model.zhulaoban = row["zhulaoban"].ToString();
}
if (row["paymentapplicationformiId"] != null && row["paymentapplicationformiId"].ToString() != "")
{
model.paymentapplicationformiId = int.Parse(row["paymentapplicationformiId"].ToString());
}
if (row["Rejection"] != null)
{
model.Rejection = row["Rejection"].ToString();
}
try
{
if (row["ProjectName"] != null)
{
model.ProjectName = row["ProjectName"].ToString();
}
}
catch (Exception e)
{
}
}
return(model);
}
