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); }