/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.Pay_Service model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Pay_Service]("); strSql.Append("[CompID],[CompName],[ServiceType],[OutData],[Price],[CreateDate],[CreateUser],[OutOfData],[PayedPrice],[IsAudit],[ts],[modifyuser])"); strSql.Append(" values ("); strSql.Append("@CompID,@CompName,@ServiceType,@OutData,@Price,@CreateDate,@CreateUser,@OutOfData,@PayedPrice,@IsAudit,@ts,@modifyuser)"); strSql.Append(";select @@Identity"); SqlParameter[] parameters = { new SqlParameter("@CompID", SqlDbType.Int), new SqlParameter("@CompName", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceType", SqlDbType.Int), new SqlParameter("@OutData", SqlDbType.DateTime), new SqlParameter("@Price", SqlDbType.Decimal), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Int), new SqlParameter("@OutOfData", SqlDbType.TinyInt), new SqlParameter("@PayedPrice", SqlDbType.Decimal), new SqlParameter("@IsAudit", SqlDbType.Int), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@modifyuser", SqlDbType.Int) }; parameters[0].Value = model.CompID; if (model.CompName != null) { parameters[1].Value = model.CompName; } else { parameters[1].Value = DBNull.Value; } parameters[2].Value = model.ServiceType; if (model.OutData != DateTime.MinValue) { parameters[3].Value = model.OutData; } else { parameters[3].Value = DBNull.Value; } parameters[4].Value = model.Price; parameters[5].Value = model.CreateDate; parameters[6].Value = model.CreateUser; parameters[7].Value = model.OutOfData; parameters[8].Value = model.PayedPrice; parameters[9].Value = model.IsAudit; parameters[10].Value = model.ts; parameters[11].Value = model.modifyuser; return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters))); }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private Hi.Model.Pay_Service GetModel(DataRow r) { Hi.Model.Pay_Service model = new Hi.Model.Pay_Service(); model.ID = SqlHelper.GetInt(r["ID"]); model.CompID = SqlHelper.GetInt(r["CompID"]); model.CompName = SqlHelper.GetString(r["CompName"]); model.ServiceType = SqlHelper.GetInt(r["ServiceType"]); model.OutData = SqlHelper.GetDateTime(r["OutData"]); model.Price = SqlHelper.GetDecimal(r["Price"]); model.CreateDate = SqlHelper.GetDateTime(r["CreateDate"]); model.CreateUser = SqlHelper.GetInt(r["CreateUser"]); model.OutOfData = SqlHelper.Getbyte(r["OutOfData"]); model.PayedPrice = SqlHelper.GetDecimal(r["PayedPrice"]); model.IsAudit = SqlHelper.GetInt(r["IsAudit"]); model.ts = SqlHelper.GetDateTime(r["ts"]); model.dr = SqlHelper.GetInt(r["dr"]); model.modifyuser = SqlHelper.GetInt(r["modifyuser"]); return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.Pay_Service model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [Pay_Service] set "); strSql.Append("[CompID]=@CompID,"); strSql.Append("[CompName]=@CompName,"); strSql.Append("[ServiceType]=@ServiceType,"); strSql.Append("[OutData]=@OutData,"); strSql.Append("[Price]=@Price,"); strSql.Append("[CreateDate]=@CreateDate,"); strSql.Append("[CreateUser]=@CreateUser,"); strSql.Append("[OutOfData]=@OutOfData,"); strSql.Append("[PayedPrice]=@PayedPrice,"); strSql.Append("[IsAudit]=@IsAudit,"); strSql.Append("[ts]=@ts,"); strSql.Append("[dr]=@dr,"); strSql.Append("[modifyuser]=@modifyuser"); strSql.Append(" where [ID]=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@CompID", SqlDbType.Int), new SqlParameter("@CompName", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceType", SqlDbType.Int), new SqlParameter("@OutData", SqlDbType.DateTime), new SqlParameter("@Price", SqlDbType.Decimal), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Int), new SqlParameter("@OutOfData", SqlDbType.TinyInt), new SqlParameter("@PayedPrice", SqlDbType.Decimal), new SqlParameter("@IsAudit", SqlDbType.Int), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@dr", SqlDbType.SmallInt), new SqlParameter("@modifyuser", SqlDbType.Int) }; parameters[0].Value = model.ID; parameters[1].Value = model.CompID; if (model.CompName != null) { parameters[2].Value = model.CompName; } else { parameters[2].Value = DBNull.Value; } parameters[3].Value = model.ServiceType; if (model.OutData != DateTime.MinValue) { parameters[4].Value = model.OutData; } else { parameters[4].Value = DBNull.Value; } parameters[5].Value = model.Price; parameters[6].Value = model.CreateDate; parameters[7].Value = model.CreateUser; parameters[8].Value = model.OutOfData; parameters[9].Value = model.PayedPrice; parameters[10].Value = model.IsAudit; parameters[11].Value = model.ts; parameters[12].Value = model.dr; parameters[13].Value = model.modifyuser; return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0); }