public int Update(DailyPayAmtRestrictInfo oParam) { string sql = @"UPDATE Fin_DailyPayAmtRestrict SET TopPublicPayAmt=@TopPublicPayAmt, AllocatedPublicAmt=@AllocatedPublicAmt, TopPrivatePayAmt=@TopPrivatePayAmt, AllocatedPrivateAmt=@AllocatedPrivateAmt, CreateUserSysNo=@CreateUserSysNo, CreateTime=@CreateTime WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramTopPublicPayAmt = new SqlParameter("@TopPublicPayAmt", SqlDbType.Decimal, 9); SqlParameter paramAllocatedPublicAmt = new SqlParameter("@AllocatedPublicAmt", SqlDbType.Decimal, 9); SqlParameter paramTopPrivatePayAmt = new SqlParameter("@TopPrivatePayAmt", SqlDbType.Decimal, 9); SqlParameter paramAllocatedPrivateAmt = new SqlParameter("@AllocatedPrivateAmt", SqlDbType.Decimal, 9); SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4); SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.TopPublicPayAmt != AppConst.DecimalNull) { paramTopPublicPayAmt.Value = oParam.TopPublicPayAmt; } else { paramTopPublicPayAmt.Value = System.DBNull.Value; } if (oParam.AllocatedPublicAmt != AppConst.DecimalNull) { paramAllocatedPublicAmt.Value = oParam.AllocatedPublicAmt; } else { paramAllocatedPublicAmt.Value = System.DBNull.Value; } if (oParam.TopPrivatePayAmt != AppConst.DecimalNull) { paramTopPrivatePayAmt.Value = oParam.TopPrivatePayAmt; } else { paramTopPrivatePayAmt.Value = System.DBNull.Value; } if (oParam.AllocatedPrivateAmt != AppConst.DecimalNull) { paramAllocatedPrivateAmt.Value = oParam.AllocatedPrivateAmt; } else { paramAllocatedPrivateAmt.Value = System.DBNull.Value; } if (oParam.CreateUserSysNo != AppConst.IntNull) { paramCreateUserSysNo.Value = oParam.CreateUserSysNo; } else { paramCreateUserSysNo.Value = System.DBNull.Value; } if (oParam.CreateTime != AppConst.DateTimeNull) { paramCreateTime.Value = oParam.CreateTime; } else { paramCreateTime.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramTopPublicPayAmt); cmd.Parameters.Add(paramAllocatedPublicAmt); cmd.Parameters.Add(paramTopPrivatePayAmt); cmd.Parameters.Add(paramAllocatedPrivateAmt); cmd.Parameters.Add(paramCreateUserSysNo); cmd.Parameters.Add(paramCreateTime); return(SqlHelper.ExecuteNonQuery(cmd)); }
public int Insert(DailyPayAmtRestrictInfo oParam) { string sql = @"INSERT INTO Fin_DailyPayAmtRestrict ( TopPublicPayAmt, AllocatedPublicAmt, TopPrivatePayAmt, AllocatedPrivateAmt, CreateUserSysNo, CreateTime ) VALUES ( @TopPublicPayAmt, @AllocatedPublicAmt, @TopPrivatePayAmt, @AllocatedPrivateAmt, @CreateUserSysNo, @CreateTime );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramTopPublicPayAmt = new SqlParameter("@TopPublicPayAmt", SqlDbType.Decimal, 9); SqlParameter paramAllocatedPublicAmt = new SqlParameter("@AllocatedPublicAmt", SqlDbType.Decimal, 9); SqlParameter paramTopPrivatePayAmt = new SqlParameter("@TopPrivatePayAmt", SqlDbType.Decimal, 9); SqlParameter paramAllocatedPrivateAmt = new SqlParameter("@AllocatedPrivateAmt", SqlDbType.Decimal, 9); SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4); SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime); paramSysNo.Direction = ParameterDirection.Output; if (oParam.TopPublicPayAmt != AppConst.DecimalNull) { paramTopPublicPayAmt.Value = oParam.TopPublicPayAmt; } else { paramTopPublicPayAmt.Value = System.DBNull.Value; } if (oParam.AllocatedPublicAmt != AppConst.DecimalNull) { paramAllocatedPublicAmt.Value = oParam.AllocatedPublicAmt; } else { paramAllocatedPublicAmt.Value = System.DBNull.Value; } if (oParam.TopPrivatePayAmt != AppConst.DecimalNull) { paramTopPrivatePayAmt.Value = oParam.TopPrivatePayAmt; } else { paramTopPrivatePayAmt.Value = System.DBNull.Value; } if (oParam.AllocatedPrivateAmt != AppConst.DecimalNull) { paramAllocatedPrivateAmt.Value = oParam.AllocatedPrivateAmt; } else { paramAllocatedPrivateAmt.Value = System.DBNull.Value; } if (oParam.CreateUserSysNo != AppConst.IntNull) { paramCreateUserSysNo.Value = oParam.CreateUserSysNo; } else { paramCreateUserSysNo.Value = System.DBNull.Value; } if (oParam.CreateTime != AppConst.DateTimeNull) { paramCreateTime.Value = oParam.CreateTime; } else { paramCreateTime.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramTopPublicPayAmt); cmd.Parameters.Add(paramAllocatedPublicAmt); cmd.Parameters.Add(paramTopPrivatePayAmt); cmd.Parameters.Add(paramAllocatedPrivateAmt); cmd.Parameters.Add(paramCreateUserSysNo); cmd.Parameters.Add(paramCreateTime); return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo)); }